///创建访问数据库的参数 SqlParameter[] paramList = { sqlHelper.CreateInParam("@Name",SqlDbType.VarChar,200,sName), sqlHelper.CreateInParam("@CategoryID",SqlDbType.Int,4,nCategoryID), sqlHelper.CreateInParam("@Desn",SqlDbType.VarChar,200,sDesn), sqlHelper.CreateInParam("@Author",SqlDbType.VarChar,200,sAuthor), sqlHelper.CreateInParam("@Publish",SqlDbType.VarChar,200,sPublish), sqlHelper.CreateInParam("@PublishDate",SqlDbType.DateTime,8,dPublishDate), sqlHelper.CreateInParam("@ISBN",SqlDbType.VarChar,200,sISBN), sqlHelper.CreateInParam("@Foreword",SqlDbType.VarChar,8000,sForeword), sqlHelper.CreateInParam("@List",SqlDbType.VarChar,8000,sList), sqlHelper.CreateInParam("@OutLine",SqlDbType.VarChar,8000,sOutLine), sqlHelper.CreateInParam("@BuyInDate",SqlDbType.DateTime,8,dBuyInDate), sqlHelper.CreateInParam("@Price",SqlDbType.Money,8,dPrice), sqlHelper.CreateInParam("@TotalNum",SqlDbType.Int,4,nTotalNum), sqlHelper.CreateInParam("@Remark",SqlDbType.VarChar,8000,sRemark) }; try { ///执行存储过程 return (sqlHelper.RunProc("Pr_AddBook",paramList)); } catch (Exception ex) { ///抛出执行数据库异常 SystemError.CreateErrorLog(ex.Message); throw new Exception(ex.Message,ex); } }
订单管理界面
首页 上一页 4 5 6 7 8 9 10 下一页 尾页 7/10/10
电子商务论文范文