private void DoAdd() { Model.BarCodeCreateRecord BarCodeCreateRecord = new Model.BarCodeCreateRecord(); BLL.BarCodeCreateRecord bll = new BLL.BarCodeCreateRecord(); Model.manager adminmodel = Session[DTKeys.SESSION_ADMIN_INFO] as Model.manager; BarCodeCreateRecord.GoodCount = int.Parse(txtGoodCount.Text); BarCodeCreateRecord.BoxSum = Convert.ToInt32(txtBoxsum.Text.Trim()); BarCodeCreateRecord.RetrospectCode = txtRetrospect.Text; BarCodeCreateRecord.Operator = adminmodel.id; BarCodeCreateRecord.Batch = txtBatch.Text.Trim(); BarCodeCreateRecord.State = 1; BarCodeCreateRecord.CreateTime = DateTime.Now; BarCodeCreateRecord.Remark = txtRemark.Text; BarCodeCreateRecord.GoodBarCode = txtGoodBarCode.Text.Trim(); //BarCodeCreateRecord.BrokerageRatio = Convert.ToDecimal(txtBrokerageRatio.Text.Trim()); //BarCodeCreateRecord.IntegralRatio = Convert.ToInt32(txtIntegralRatio.Text.Trim()); Model.BarCode BarCode = new Model.BarCode(); BarCode.CreateTime = DateTime.Now; BarCode.State = 1; Model.GoodCategory gc = new Model.GoodCategory(); BLL.GoodCategory bllgc = new BLL.GoodCategory(); try { bll.Add(BarCodeCreateRecord, BarCode); int i = bll.GetMaxID(); if (i != 0) { ExcelOut(i.ToString()); Response.Redirect("/admin/BarCode/BarCodeCreateDetail.aspx?id=" + i); } } catch (Exception e) { } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Model.BarCodeCreateRecord barCodeCreateRecord, Model.BarCode BarCode) { dal.Add(barCodeCreateRecord, BarCode); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Model.BarCodeCreateRecord barCodeCreateRecord, Model.BarCode BarCode) { StringBuilder strSql = new StringBuilder(); strSql.Append(" declare @BarCodeCreateRecordID int "); strSql.Append(" insert into BarCodeCreateRecord("); strSql.Append("UniqueID,GoodCount,RetrospectCode,Operator,batch,boxsum,CreateTime,Remark,GoodBarCode,BrokerageRatio,IntegralRatio)"); strSql.Append(" values ("); strSql.Append("newid(),@GoodCount,@RetrospectCode,@Operator,@batch,@boxsum,@CreateTime,@barCodeCreateRecordRemark,@GoodBarCode,@BrokerageRatio,@IntegralRatio)"); strSql.Append(";set @BarCodeCreateRecordID= @@IDENTITY"); int BoxSum = 0; if (barCodeCreateRecord.GoodCount % barCodeCreateRecord.BoxSum == 0) { BoxSum = barCodeCreateRecord.BoxSum; } else { BoxSum = barCodeCreateRecord.BoxSum + 1; } for (int i = 0; i < BoxSum; i++) { int standard = barCodeCreateRecord.GoodCount / barCodeCreateRecord.BoxSum; string boxCode = new Common.Rule().GetBarCode(6); if (i == BoxSum - 1 && barCodeCreateRecord.GoodCount % barCodeCreateRecord.BoxSum > 0) { standard = barCodeCreateRecord.GoodCount % barCodeCreateRecord.BoxSum; } for (int j = 0; j < standard; j++) { strSql.Append(" insert BarCode(UniqueID,BoxCode,LogisticsCode,IntegralCode,CreateTime,Operator,State,BarCodeCreateRecordID)"); strSql.Append(" values ("); strSql.Append("newid(),"); strSql.Append("'" + boxCode + DateTime.Now.Year.ToString().Substring(2) + barCodeCreateRecord.GoodBarCode); //strSql.Append("','" + barCodeCreateRecord.RetrospectCode + "'+" + "'" + DateTime.Now.Year.ToString().Substring(2) + "'" + "+right('000000'+CAST(cast((right(@IntegralCode,6)) as int)+" + sum + " as varchar(50)),6)"); strSql.Append("','" + barCodeCreateRecord.RetrospectCode + "'+" + "'" + DateTime.Now.Year.ToString().Substring(2) + "'+'" + new Common.Rule().GetBarCode(10)); strSql.Append("','" + new Common.Rule().GetBarCode(4) + DateTime.Now.Year.ToString().Substring(2) + new Common.Rule().GetBarCode(4)); strSql.Append("',@CreateTime,@Operator,@BarCodeState,@BarCodeCreateRecordID)"); } } SqlParameter[] parameters = { new SqlParameter("@GoodCount", SqlDbType.Int, 8), new SqlParameter("@RetrospectCode", SqlDbType.VarChar, 50), new SqlParameter("@Operator", SqlDbType.Int, 8), new SqlParameter("@Batch", SqlDbType.VarChar, 50), new SqlParameter("@boxsum", SqlDbType.Int, 8), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@barCodeCreateRecordRemark", SqlDbType.Text), new SqlParameter("@GoodBarCode", SqlDbType.VarChar, 10), new SqlParameter("@BrokerageRatio", SqlDbType.Decimal), new SqlParameter("@IntegralRatio", SqlDbType.Int, 8), new SqlParameter("@BarCodeState", SqlDbType.Int, 8), }; parameters[0].Value = barCodeCreateRecord.GoodCount; parameters[1].Value = barCodeCreateRecord.RetrospectCode; parameters[2].Value = barCodeCreateRecord.Operator; parameters[3].Value = barCodeCreateRecord.Batch; parameters[4].Value = barCodeCreateRecord.BoxSum; parameters[5].Value = barCodeCreateRecord.CreateTime; parameters[6].Value = barCodeCreateRecord.Remark; parameters[7].Value = barCodeCreateRecord.GoodBarCode; parameters[8].Value = barCodeCreateRecord.BrokerageRatio; parameters[9].Value = barCodeCreateRecord.IntegralRatio; parameters[10].Value = BarCode.State; System.Collections.Hashtable ht = new System.Collections.Hashtable(); ht.Add(strSql, parameters); DbHelperSQL.ExecuteSqlTran(ht); }