/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hownet.Model.SizeTable model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SizeTable(");
strSql.Append("MainID,TableTypeID,FillMan,ZhiYang,BanFangZhuGuan,ShengChangBu,LastEditDate,LastEditMan,IsVerify,VerifyMan,VerifyDate,Remark,Images,LastEditRemark,MeasureID,DateTime,UpData)");
strSql.Append(" values (");
strSql.Append("@MainID,@TableTypeID,@FillMan,@ZhiYang,@BanFangZhuGuan,@ShengChangBu,@LastEditDate,@LastEditMan,@IsVerify,@VerifyMan,@VerifyDate,@Remark,@Images,@LastEditRemark,@MeasureID,@DateTime,@UpData)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MainID", SqlDbType.Int, 4),
new SqlParameter("@TableTypeID", SqlDbType.Int, 4),
new SqlParameter("@FillMan", SqlDbType.Int, 4),
new SqlParameter("@ZhiYang", SqlDbType.Int, 4),
new SqlParameter("@BanFangZhuGuan", SqlDbType.Int, 4),
new SqlParameter("@ShengChangBu", SqlDbType.Int, 4),
new SqlParameter("@LastEditDate", SqlDbType.DateTime),
new SqlParameter("@LastEditMan", SqlDbType.Int, 4),
new SqlParameter("@IsVerify", SqlDbType.Int, 4),
new SqlParameter("@VerifyMan", SqlDbType.Int, 4),
new SqlParameter("@VerifyDate", SqlDbType.DateTime),
new SqlParameter("@Remark", SqlDbType.NVarChar, 2000),
new SqlParameter("@Images", SqlDbType.NVarChar, 50),
new SqlParameter("@LastEditRemark", SqlDbType.NVarChar, 2000),
new SqlParameter("@MeasureID", SqlDbType.Int, 4),
new SqlParameter("@DateTime", SqlDbType.DateTime),
new SqlParameter("@UpData", SqlDbType.Int, 4)
};
parameters[0].Value = model.MainID;
parameters[1].Value = model.TableTypeID;
parameters[2].Value = model.FillMan;
parameters[3].Value = model.ZhiYang;
parameters[4].Value = model.BanFangZhuGuan;
parameters[5].Value = model.ShengChangBu;
parameters[6].Value = model.LastEditDate;
parameters[7].Value = model.LastEditMan;
parameters[8].Value = model.IsVerify;
parameters[9].Value = model.VerifyMan;
parameters[10].Value = model.VerifyDate;
parameters[11].Value = model.Remark;
parameters[12].Value = model.Images;
parameters[13].Value = model.LastEditRemark;
parameters[14].Value = model.MeasureID;
parameters[15].Value = model.DateTime;
parameters[16].Value = model.UpData;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
public void SaveSizePart(DataTable dt, int TaskID)
{
Hownet.BLL.SizePart bllSP = new SizePart();
Hownet.BLL.SizeTable bllSt = new SizeTable();
Hownet.BLL.MaterielAttribute blMa = new MaterielAttribute();
Hownet.Model.SizeTable modST = new Hownet.Model.SizeTable();
ArrayList PartList = new ArrayList();
ArrayList SizeList = new ArrayList();
bllSt.DelTask(TaskID);
PartList.Clear();
SizeList.Clear();
PartList.Add(0);
SizeList.Add(0);
for (int r = 1; r < dt.Rows.Count - 1; r++)
{
int partID = 0;
if (dt.DefaultView[r]["Part"].ToString() != string.Empty)
{
partID = bllSP.GetID(dt.DefaultView[r]["Part"].ToString());
}
PartList.Add(partID);
}
for (int c = 1; c < dt.Columns.Count; c++)
{
int sizeID = 0;
if (dt.DefaultView[0][c].ToString() != string.Empty)
{
sizeID = blMa.GetID(dt.DefaultView[0][c].ToString(), 2);
}
SizeList.Add(sizeID);
}
for (int r = 0; r < PartList.Count; r++)
{
if (PartList[r].ToString() != "0")
{
for (int c = 0; c < SizeList.Count; c++)
{
if (SizeList[c].ToString() != "0")
{
if (dt.DefaultView[r][c].ToString() != string.Empty && dt.DefaultView[r][c].ToString() != "0")
{
modST.ProduceTaskID = TaskID;
modST.SizeID = int.Parse(SizeList[c].ToString());
modST.SizePartID = int.Parse(PartList[r].ToString());
modST.Length = decimal.Parse(dt.DefaultView[r][c].ToString());
bllSt.Add(modST);
}
}
}
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Hownet.Model.SizeTable GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,MainID,TableTypeID,FillMan,ZhiYang,BanFangZhuGuan,ShengChangBu,LastEditDate,LastEditMan,IsVerify,VerifyMan,VerifyDate,Remark,Images,LastEditRemark,MeasureID,DateTime,UpData from SizeTable ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Hownet.Model.SizeTable model = new Hownet.Model.SizeTable();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["MainID"].ToString() != "")
{
model.MainID = int.Parse(ds.Tables[0].Rows[0]["MainID"].ToString());
}
if (ds.Tables[0].Rows[0]["TableTypeID"].ToString() != "")
{
model.TableTypeID = int.Parse(ds.Tables[0].Rows[0]["TableTypeID"].ToString());
}
if (ds.Tables[0].Rows[0]["FillMan"].ToString() != "")
{
model.FillMan = int.Parse(ds.Tables[0].Rows[0]["FillMan"].ToString());
}
if (ds.Tables[0].Rows[0]["ZhiYang"].ToString() != "")
{
model.ZhiYang = int.Parse(ds.Tables[0].Rows[0]["ZhiYang"].ToString());
}
if (ds.Tables[0].Rows[0]["BanFangZhuGuan"].ToString() != "")
{
model.BanFangZhuGuan = int.Parse(ds.Tables[0].Rows[0]["BanFangZhuGuan"].ToString());
}
if (ds.Tables[0].Rows[0]["ShengChangBu"].ToString() != "")
{
model.ShengChangBu = int.Parse(ds.Tables[0].Rows[0]["ShengChangBu"].ToString());
}
if (ds.Tables[0].Rows[0]["LastEditDate"].ToString() != "")
{
model.LastEditDate = DateTime.Parse(ds.Tables[0].Rows[0]["LastEditDate"].ToString());
}
if (ds.Tables[0].Rows[0]["LastEditMan"].ToString() != "")
{
model.LastEditMan = int.Parse(ds.Tables[0].Rows[0]["LastEditMan"].ToString());
}
if (ds.Tables[0].Rows[0]["IsVerify"].ToString() != "")
{
model.IsVerify = int.Parse(ds.Tables[0].Rows[0]["IsVerify"].ToString());
}
if (ds.Tables[0].Rows[0]["VerifyMan"].ToString() != "")
{
model.VerifyMan = int.Parse(ds.Tables[0].Rows[0]["VerifyMan"].ToString());
}
if (ds.Tables[0].Rows[0]["VerifyDate"].ToString() != "")
{
model.VerifyDate = DateTime.Parse(ds.Tables[0].Rows[0]["VerifyDate"].ToString());
}
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
model.Images = ds.Tables[0].Rows[0]["Images"].ToString();
model.LastEditRemark = ds.Tables[0].Rows[0]["LastEditRemark"].ToString();
if (ds.Tables[0].Rows[0]["MeasureID"].ToString() != "")
{
model.MeasureID = int.Parse(ds.Tables[0].Rows[0]["MeasureID"].ToString());
}
if (ds.Tables[0].Rows[0]["DateTime"].ToString() != "")
{
model.DateTime = DateTime.Parse(ds.Tables[0].Rows[0]["DateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["UpData"].ToString() != "")
{
model.UpData = int.Parse(ds.Tables[0].Rows[0]["UpData"].ToString());
}
model.A = 1;
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Hownet.Model.SizeTable model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SizeTable set ");
strSql.Append("MainID=@MainID,");
strSql.Append("TableTypeID=@TableTypeID,");
strSql.Append("FillMan=@FillMan,");
strSql.Append("ZhiYang=@ZhiYang,");
strSql.Append("BanFangZhuGuan=@BanFangZhuGuan,");
strSql.Append("ShengChangBu=@ShengChangBu,");
strSql.Append("LastEditDate=@LastEditDate,");
strSql.Append("LastEditMan=@LastEditMan,");
strSql.Append("IsVerify=@IsVerify,");
strSql.Append("VerifyMan=@VerifyMan,");
strSql.Append("VerifyDate=@VerifyDate,");
strSql.Append("Remark=@Remark,");
strSql.Append("Images=@Images,");
strSql.Append("LastEditRemark=@LastEditRemark,");
strSql.Append("MeasureID=@MeasureID,");
strSql.Append("DateTime=@DateTime,");
strSql.Append("UpData=@UpData");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@MainID", SqlDbType.Int, 4),
new SqlParameter("@TableTypeID", SqlDbType.Int, 4),
new SqlParameter("@FillMan", SqlDbType.Int, 4),
new SqlParameter("@ZhiYang", SqlDbType.Int, 4),
new SqlParameter("@BanFangZhuGuan", SqlDbType.Int, 4),
new SqlParameter("@ShengChangBu", SqlDbType.Int, 4),
new SqlParameter("@LastEditDate", SqlDbType.DateTime),
new SqlParameter("@LastEditMan", SqlDbType.Int, 4),
new SqlParameter("@IsVerify", SqlDbType.Int, 4),
new SqlParameter("@VerifyMan", SqlDbType.Int, 4),
new SqlParameter("@VerifyDate", SqlDbType.DateTime),
new SqlParameter("@Remark", SqlDbType.NVarChar, 2000),
new SqlParameter("@Images", SqlDbType.NVarChar, 50),
new SqlParameter("@LastEditRemark", SqlDbType.NVarChar, 2000),
new SqlParameter("@MeasureID", SqlDbType.Int, 4),
new SqlParameter("@DateTime", SqlDbType.DateTime),
new SqlParameter("@UpData", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.MainID;
parameters[2].Value = model.TableTypeID;
parameters[3].Value = model.FillMan;
parameters[4].Value = model.ZhiYang;
parameters[5].Value = model.BanFangZhuGuan;
parameters[6].Value = model.ShengChangBu;
parameters[7].Value = model.LastEditDate;
parameters[8].Value = model.LastEditMan;
parameters[9].Value = model.IsVerify;
parameters[10].Value = model.VerifyMan;
parameters[11].Value = model.VerifyDate;
parameters[12].Value = model.Remark;
parameters[13].Value = model.Images;
parameters[14].Value = model.LastEditRemark;
parameters[15].Value = model.MeasureID;
parameters[16].Value = model.DateTime;
parameters[17].Value = model.UpData;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
public DataTable SizePart(int TaskID)
{
Hownet.BLL.SizeTable bllST = new Hownet.BLL.SizeTable();
Hownet.Model.SizeTable modST = new Hownet.Model.SizeTable();
Hownet.BLL.ProduceTaskInfo pti = new ProduceTaskInfo();
DataTable dt = new DataTable();
dt.TableName = "Size";
dt.Clear();
dt.Columns.Clear();
dt.Columns.Add("Part", typeof(string));
dt.Rows.Add(dt.NewRow());
dt.Rows[0]["Part"] = "部位\\尺码";
SqlDataReader myReader = pti.GetSize(TaskID);
int i = 1;
ArrayList SizeList = new ArrayList();
ArrayList PartList = new ArrayList();
SizeList.Clear();
PartList.Clear();
SizeList.Add(0);
PartList.Add(0);
while (myReader.Read())
{
dt.Columns.Add("Columns" + i);
dt.Rows[0][i] = myReader[0].ToString();
SizeList.Add(int.Parse(myReader[1].ToString()));
i++;
}
myReader.Close();
SqlDataReader Part = bllST.GetPart(TaskID);
for (int c = dt.Columns.Count; c < 12; c++)
{
dt.Columns.Add("Columns" + c);
}
i = 1;
while (Part.Read())
{
dt.Rows.Add(dt.NewRow());
dt.Rows[i][0] = Part[0].ToString();
PartList.Add(int.Parse(Part[1].ToString()));
i++;
}
Part.Close();
for (int r = 1; r < SizeList.Count; r++)
{
for (int c = 1; c < PartList.Count; c++)
{
modST.SizeID = int.Parse(SizeList[r].ToString());
modST.SizePartID = int.Parse(PartList[c].ToString());
modST.ProduceTaskID = TaskID;
dt.Rows[c][r] = bllST.GetValue(modST);
}
}
return(dt);
}
