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)
{
}
}
public List <Model.BarCodeCreateRecord> GetList()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from BarCodeCreateRecord ");
Model.BarCodeCreateRecord model = new Model.BarCodeCreateRecord();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
List <Model.BarCodeCreateRecord> list = Common.DataTableToList.List <Model.BarCodeCreateRecord>(ds.Tables[0]);
return(list);
}
public List <Model.BarCode> GetList()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from BarCode");
//SqlParameter[] parameters = {
// new SqlParameter("@id", SqlDbType.Int,4)};
//parameters[0].Value = id;
Model.BarCodeCreateRecord model = new Model.BarCodeCreateRecord();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
List <Model.BarCode> aa = Common.DataTableToList.List <Model.BarCode>(ds.Tables[0]);
return(aa);
}
public Model.BarCodeCreateRecord GetModel(string BarCodeCreateRecordID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from BarCodeCreateRecord where BarCodeCreateRecordID=@BarCodeCreateRecordID");
SqlParameter[] parameters =
{
new SqlParameter("@BarCodeCreateRecordID", SqlDbType.Int, 8)
};
parameters[0].Value = BarCodeCreateRecordID;
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
Model.BarCodeCreateRecord model = Common.DataTableToList.List <Model.BarCodeCreateRecord>(ds.Tables[0])[0];
return(model);
}
/// <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);
}
