public void UpdateWare_Bill_Count(int lgIndex, SqlCommand cmd, MWare_Bill_Count model)
{
StringBuilder strSql = new StringBuilder();
SqlParameter[] parameters;
///////////////////////////////////////////////
strSql.Append("SP_Ware_Bill_Count_EditVerify");
parameters = new SqlParameter[] {
new SqlParameter("@LgIndex", SqlDbType.Int),
new SqlParameter("@PKCode", SqlDbType.VarChar, 25)
};
parameters[0].Value = lgIndex;
parameters[1].Value = model.ID;
cmd.ExecuteMySPQuery(strSql.ToString(), parameters);
/////////////////////////////////////////////////////////////////
strSql.Clear();
strSql.Append("update Ware_Bill_Count set ");
strSql.Append("WhCode=@WhCode,");
strSql.Append("FBCode=@FBCode,");
strSql.Append("Remark=@Remark");
strSql.Append(" where ID=@ID ");
parameters = new SqlParameter[] {
new SqlParameter("@WhCode", SqlDbType.VarChar, 10),
new SqlParameter("@FBCode", SqlDbType.VarChar, 10),
new SqlParameter("@Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@ID", SqlDbType.VarChar, 25)
};
parameters[0].Value = model.WhCode;
parameters[1].Value = model.FBCode;
parameters[2].Value = model.Remark;
parameters[3].Value = model.ID;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}
private void PreparePD(int lgIndex, SqlCommand cmd, MWare_Bill_Count model)
{
model.Sub_PD.ID = model.ID;
_DW.AddWare_Bill_PD(lgIndex, cmd, model.Sub_PD);
model.Sub_PD_Detail2.ForEach(it => it.ID = model.ID);
_DW.AddWare_Bill_Count_PD_Detail2(lgIndex, cmd, model.Sub_PD_Detail2);
}
protected override void PrepareAddSub(int lgIndex, SqlCommand cmd, object t)
{
MWare_Bill_Count model = t as MWare_Bill_Count;
switch (model.MType)
{
case "L":
this.PreparePD(lgIndex, cmd, model);
break;
default:
break;
}
this.PrepareAddExtend(lgIndex, cmd, model);
}
public void UpdateEditWare_Bill_Count(int lgIndex, SqlCommand cmd, MWare_Bill_Count model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Ware_Bill_Count set ");
strSql.Append("Remark=@Remark");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@ID", SqlDbType.VarChar, 25)
};
parameters[0].Value = model.Remark;
parameters[1].Value = model.ID;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}
private void PrepareExtend(MWare_Bill_Count model)
{
model.Sub_Extend = new MWare_Bill_Count_Extend()
{
ID = model.ID,
SumQty1 = 0,
SumQty2 = 0,
SumQty = 0,
};
switch (model.MType)
{
case "L":
break;
default:
break;
}
}
private void PrepareAddExtend(int lgIndex, SqlCommand cmd, MWare_Bill_Count model)
{
this.PrepareExtend(model);
_DW.AddWare_Bill_Count_Extend(lgIndex, cmd, model.Sub_Extend);
}
protected override void PrepareAddMain(int lgIndex, SqlCommand cmd, object t)
{
MWare_Bill_Count model = t as MWare_Bill_Count;
_DW.AddWare_Bill_Count(lgIndex, cmd, model);
}
private void UpdatePD(int lgIndex, SqlCommand cmd, MWare_Bill_Count model)
{
_DW.UpdateWare_Bill_PD(lgIndex, cmd, model.Sub_PD);
_DW.UpdateWare_Bill_Count_PD_Detail2(lgIndex, cmd, model.Sub_PD_Detail2);
}
public void AddWare_Bill_Count(int lgIndex, SqlCommand cmd, MWare_Bill_Count model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Ware_Bill_Count(");
strSql.Append("ID,BCode,BDate,BType,MType,StCode,WhCode,FBCode,Remark,KJYear,Period,Maker,MName,MDate,Starter,StartName,StartTime,Ender,EndName,EndTime,F_Del,Deler,DelName,DelDate)");
strSql.Append(" values (");
strSql.Append("@ID,@BCode,@BDate,@BType,@MType,@StCode,@WhCode,@FBCode,@Remark,@KJYear,@Period,@Maker,@MName,@MDate,@Starter,@StartName,@StartTime,@Ender,@EndName,@EndTime,@F_Del,@Deler,@DelName,@DelDate)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 25),
new SqlParameter("@BCode", SqlDbType.VarChar, 30),
new SqlParameter("@BDate", SqlDbType.Date, 3),
new SqlParameter("@BType", SqlDbType.VarChar, 10),
new SqlParameter("@MType", SqlDbType.VarChar, 10),
new SqlParameter("@StCode", SqlDbType.VarChar, 10),
new SqlParameter("@WhCode", SqlDbType.VarChar, 10),
new SqlParameter("@FBCode", SqlDbType.VarChar, 50),
new SqlParameter("@Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@KJYear", SqlDbType.Int, 4),
new SqlParameter("@Period", SqlDbType.Int, 4),
new SqlParameter("@Maker", SqlDbType.VarChar, 10),
new SqlParameter("@MName", SqlDbType.NVarChar, 30),
new SqlParameter("@MDate", SqlDbType.DateTime),
new SqlParameter("@Starter", SqlDbType.VarChar, 10),
new SqlParameter("@StartName", SqlDbType.NVarChar, 30),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@Ender", SqlDbType.VarChar, 10),
new SqlParameter("@EndName", SqlDbType.NVarChar, 30),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@F_Del", SqlDbType.Bit, 1),
new SqlParameter("@Deler", SqlDbType.VarChar, 10),
new SqlParameter("@DelName", SqlDbType.NVarChar, 30),
new SqlParameter("@DelDate", SqlDbType.DateTime)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.BCode;
parameters[2].Value = model.BDate;
parameters[3].Value = model.BType;
parameters[4].Value = model.MType;
parameters[5].Value = model.StCode;
parameters[6].Value = model.WhCode;
parameters[7].Value = model.FBCode;
parameters[8].Value = model.Remark;
parameters[9].Value = model.KJYear;
parameters[10].Value = model.Period;
parameters[11].Value = model.Maker;
parameters[12].Value = model.MName;
parameters[13].Value = System.DateTime.Now; //model.MDate;
parameters[14].Value = ""; //model.Starter;
parameters[15].Value = ""; //model.StartName;
parameters[16].Value = System.DBNull.Value; // model.StartTime;
parameters[17].Value = ""; //model.Ender;
parameters[18].Value = ""; //model.EndName;
parameters[19].Value = System.DBNull.Value; //model.EndTime;
parameters[20].Value = false; // model.F_Del;
parameters[21].Value = ""; // model.Deler;
parameters[22].Value = ""; //model.DelName;
parameters[23].Value = System.DBNull.Value; //model.DelDate;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}
public void UpdateEdit(string dbCode, int lgIndex, MWare_Bill_Count t)
{
bllUpdateEdit.UpdateEdit(dbCode, lgIndex, t);
}
public string Add(string dbCode, int lgIndex, MWare_Bill_Count t)
{
return(bll.Add(dbCode, lgIndex, t));
}
