public void SaveBow(DataTable dt, int TaskID) { Hownet.BLL.SizeBow bllSB = new SizeBow(); Hownet.BLL.Materiel bllMat = new Materiel(); Hownet.BLL.MaterielAttribute blMa = new MaterielAttribute(); Hownet.Model.SizeBow modSB = new Hownet.Model.SizeBow(); int sizeID = 0; modSB.ProduceTaskID = TaskID; for (int c = 1; c < dt.Columns.Count; c++) { if (dt.DefaultView[0][c].ToString() != string.Empty) { sizeID = blMa.GetID(dt.DefaultView[0][c].ToString(), 2); modSB.SizeID = sizeID; if (dt.DefaultView[2][c] != null && dt.DefaultView[2][c].ToString() != string.Empty) { modSB.BowID = bllMat.GetID(dt.DefaultView[2][c].ToString()); } if (dt.DefaultView[1][c] != null && dt.DefaultView[2][c].ToString() != string.Empty) { modSB.CottonID = bllMat.GetID(dt.DefaultView[1][c].ToString()); } modSB.SizeBowID = bllSB.SelectSize(TaskID, sizeID); if (modSB.SizeBowID != 0) { bllSB.Update(modSB); } else { bllSB.Add(modSB); } } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Hownet.Model.SizeBow GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,SizeID,BowID,CottonID,TaskID,Sash,OpenSash,PlasticBone,Remark from SizeBow "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Hownet.Model.SizeBow model = new Hownet.Model.SizeBow(); 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]["SizeID"].ToString() != "") { model.SizeID = int.Parse(ds.Tables[0].Rows[0]["SizeID"].ToString()); } if (ds.Tables[0].Rows[0]["BowID"].ToString() != "") { model.BowID = int.Parse(ds.Tables[0].Rows[0]["BowID"].ToString()); } if (ds.Tables[0].Rows[0]["CottonID"].ToString() != "") { model.CottonID = int.Parse(ds.Tables[0].Rows[0]["CottonID"].ToString()); } if (ds.Tables[0].Rows[0]["TaskID"].ToString() != "") { model.TaskID = int.Parse(ds.Tables[0].Rows[0]["TaskID"].ToString()); } if (ds.Tables[0].Rows[0]["Sash"].ToString() != "") { model.Sash = int.Parse(ds.Tables[0].Rows[0]["Sash"].ToString()); } if (ds.Tables[0].Rows[0]["OpenSash"].ToString() != "") { model.OpenSash = int.Parse(ds.Tables[0].Rows[0]["OpenSash"].ToString()); } if (ds.Tables[0].Rows[0]["PlasticBone"].ToString() != "") { model.PlasticBone = int.Parse(ds.Tables[0].Rows[0]["PlasticBone"].ToString()); } model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); model.A = 1; return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.SizeBow model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SizeBow("); strSql.Append("SizeID,BowID,CottonID,TaskID,Sash,OpenSash,PlasticBone,Remark)"); strSql.Append(" values ("); strSql.Append("@SizeID,@BowID,@CottonID,@TaskID,@Sash,@OpenSash,@PlasticBone,@Remark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SizeID", SqlDbType.Int, 4), new SqlParameter("@BowID", SqlDbType.Int, 4), new SqlParameter("@CottonID", SqlDbType.Int, 4), new SqlParameter("@TaskID", SqlDbType.Int, 4), new SqlParameter("@Sash", SqlDbType.Int, 4), new SqlParameter("@OpenSash", SqlDbType.Int, 4), new SqlParameter("@PlasticBone", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.SizeID; parameters[1].Value = model.BowID; parameters[2].Value = model.CottonID; parameters[3].Value = model.TaskID; parameters[4].Value = model.Sash; parameters[5].Value = model.OpenSash; parameters[6].Value = model.PlasticBone; parameters[7].Value = model.Remark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Hownet.Model.SizeBow model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SizeBow set "); strSql.Append("SizeID=@SizeID,"); strSql.Append("BowID=@BowID,"); strSql.Append("CottonID=@CottonID,"); strSql.Append("TaskID=@TaskID,"); strSql.Append("Sash=@Sash,"); strSql.Append("OpenSash=@OpenSash,"); strSql.Append("PlasticBone=@PlasticBone,"); strSql.Append("Remark=@Remark"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@SizeID", SqlDbType.Int, 4), new SqlParameter("@BowID", SqlDbType.Int, 4), new SqlParameter("@CottonID", SqlDbType.Int, 4), new SqlParameter("@TaskID", SqlDbType.Int, 4), new SqlParameter("@Sash", SqlDbType.Int, 4), new SqlParameter("@OpenSash", SqlDbType.Int, 4), new SqlParameter("@PlasticBone", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.ID; parameters[1].Value = model.SizeID; parameters[2].Value = model.BowID; parameters[3].Value = model.CottonID; parameters[4].Value = model.TaskID; parameters[5].Value = model.Sash; parameters[6].Value = model.OpenSash; parameters[7].Value = model.PlasticBone; parameters[8].Value = model.Remark; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }