/// <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); }