/// <summary> /// 得到一个对象实体 /// </summary> public Common.Model.MouldingBom_Model GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 partNumber,matPart01,matPart02,customer,model,jigNo,cavityCount,partsWeight,cycleTime,blockCount,unitCount,machineID,userName,dateTime,remarks,partNumberAll from MouldingBom "); strSql.Append(" where "); SqlParameter[] parameters = { }; DBHelp.Reports.LogFile.DebugLog("AUTOCODE", "NameSpace:Common.DAL", "Class:MouldingBom_DAL", "Function: public Common.Model.MouldingBom_Model GetModel()"+ "TableName:MouldingBom", ""); Common.Model.MouldingBom_Model model = new Common.Model.MouldingBom_Model(); DataSet ds = DBHelp.SqlDB.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.partNumber = ds.Tables[0].Rows[0]["partNumber"].ToString(); model.matPart01 = ds.Tables[0].Rows[0]["matPart01"].ToString(); model.matPart02 = ds.Tables[0].Rows[0]["matPart02"].ToString(); model.customer = ds.Tables[0].Rows[0]["customer"].ToString(); model.model = ds.Tables[0].Rows[0]["model"].ToString(); model.jigNo = ds.Tables[0].Rows[0]["jigNo"].ToString(); if (ds.Tables[0].Rows[0]["cavityCount"].ToString() != "") { model.cavityCount = decimal.Parse(ds.Tables[0].Rows[0]["cavityCount"].ToString()); } if (ds.Tables[0].Rows[0]["partsWeight"].ToString() != "") { model.partsWeight = decimal.Parse(ds.Tables[0].Rows[0]["partsWeight"].ToString()); } if (ds.Tables[0].Rows[0]["cycleTime"].ToString() != "") { model.cycleTime = decimal.Parse(ds.Tables[0].Rows[0]["cycleTime"].ToString()); } if (ds.Tables[0].Rows[0]["blockCount"].ToString() != "") { model.blockCount = int.Parse(ds.Tables[0].Rows[0]["blockCount"].ToString()); } if (ds.Tables[0].Rows[0]["unitCount"].ToString() != "") { model.unitCount = int.Parse(ds.Tables[0].Rows[0]["unitCount"].ToString()); } model.machineID = ds.Tables[0].Rows[0]["machineID"].ToString(); model.userName = ds.Tables[0].Rows[0]["userName"].ToString(); if (ds.Tables[0].Rows[0]["dateTime"].ToString() != "") { model.dateTime = DateTime.Parse(ds.Tables[0].Rows[0]["dateTime"].ToString()); } model.remarks = ds.Tables[0].Rows[0]["remarks"].ToString(); model.partnumberall = ds.Tables[0].Rows[0]["partNumberAll"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public SqlCommand AddCommand(Common.Model.MouldingBom_Model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MouldingBom("); strSql.Append("partNumber,matPart01,matPart02,customer,model,jigNo,cavityCount,partsWeight,cycleTime,blockCount,unitCount,machineID,userName,dateTime,remarks,partNumberAll)"); strSql.Append(" values ("); strSql.Append("@partNumber,@matPart01,@matPart02,@customer,@model,@jigNo,@cavityCount,@partsWeight,@cycleTime,@blockCount,@unitCount,@machineID,@userName,@dateTime,@remarks,@partNumberAll)"); SqlParameter[] parameters = { new SqlParameter("@partNumber", SqlDbType.VarChar, 50), new SqlParameter("@matPart01", SqlDbType.VarChar, 50), new SqlParameter("@matPart02", SqlDbType.VarChar, 50), new SqlParameter("@customer", SqlDbType.VarChar, 50), new SqlParameter("@model", SqlDbType.VarChar, 50), new SqlParameter("@jigNo", SqlDbType.VarChar, 50), new SqlParameter("@cavityCount", SqlDbType.Decimal, 9), new SqlParameter("@partsWeight", SqlDbType.Decimal, 9), new SqlParameter("@cycleTime", SqlDbType.Decimal, 9), new SqlParameter("@blockCount", SqlDbType.Int, 4), new SqlParameter("@unitCount", SqlDbType.Int, 4), new SqlParameter("@machineID", SqlDbType.VarChar, 8), new SqlParameter("@userName", SqlDbType.VarChar, 50), new SqlParameter("@dateTime", SqlDbType.SmallDateTime), new SqlParameter("@remarks", SqlDbType.VarChar, 500), new SqlParameter("@partNumberAll", SqlDbType.VarChar, 500) }; DBHelp.Reports.LogFile.DebugLog("AUTOCODE", "NameSpace:Common.DAL", "Class:MouldingBom_DAL", "Function: public SqlCommand AddCommand(Common.Model.MouldingBom_Model model)"+ "TableName:MouldingBom", ";partNumber = " + (model.partNumber == null ? "" : model.partNumber.ToString()) + ";matPart01 = " + (model.matPart01 == null ? "" : model.matPart01.ToString()) + ";matPart02 = " + (model.matPart02 == null ? "" : model.matPart02.ToString()) + ";customer = " + (model.customer == null ? "" : model.customer.ToString()) + ";model = " + (model.model == null ? "" : model.model.ToString()) + ";jigNo = " + (model.jigNo == null ? "" : model.jigNo.ToString()) + ";cavityCount = " + (model.cavityCount == null ? "" : model.cavityCount.ToString()) + ";partsWeight = " + (model.partsWeight == null ? "" : model.partsWeight.ToString()) + ";cycleTime = " + (model.cycleTime == null ? "" : model.cycleTime.ToString()) + ";blockCount = " + (model.blockCount == null ? "" : model.blockCount.ToString()) + ";unitCount = " + (model.unitCount == null ? "" : model.unitCount.ToString()) + ";machineID = " + (model.machineID == null ? "" : model.machineID.ToString()) + ";userName = "******"" : model.userName.ToString()) + ";dateTime = " + (model.dateTime == null ? "" : model.dateTime.ToString()) + ";remarks = " + (model.remarks == null ? "" : model.remarks.ToString()) + ""); parameters[0].Value = model.partNumber == null ? (object)DBNull.Value : model.partNumber; parameters[1].Value = model.matPart01 == null ? (object)DBNull.Value : model.matPart01; parameters[2].Value = model.matPart02 == null ? (object)DBNull.Value : model.matPart02; parameters[3].Value = model.customer == null ? (object)DBNull.Value : model.customer; parameters[4].Value = model.model == null ? (object)DBNull.Value : model.model; parameters[5].Value = model.jigNo == null ? (object)DBNull.Value : model.jigNo; parameters[6].Value = model.cavityCount == null ? (object)DBNull.Value : model.cavityCount; parameters[7].Value = model.partsWeight == null ? (object)DBNull.Value : model.partsWeight; parameters[8].Value = model.cycleTime == null ? (object)DBNull.Value : model.cycleTime; parameters[9].Value = model.blockCount == null ? (object)DBNull.Value : model.blockCount; parameters[10].Value = model.unitCount == null ? (object)DBNull.Value : model.unitCount; parameters[11].Value = model.machineID == null ? (object)DBNull.Value : model.machineID; parameters[12].Value = model.userName == null ? (object)DBNull.Value : model.userName; parameters[13].Value = model.dateTime == null ? (object)DBNull.Value : model.dateTime; parameters[14].Value = model.remarks == null ? (object)DBNull.Value : model.remarks; parameters[15].Value = model.partnumberall == null ? (object)DBNull.Value : model.partnumberall; return(DBHelp.SqlDB.generateCommand(strSql.ToString(), parameters)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Common.Model.MouldingBom_Model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MouldingBom set "); strSql.Append("partNumber=@partNumber,"); strSql.Append("matPart01=@matPart01,"); strSql.Append("matPart02=@matPart02,"); strSql.Append("customer=@customer,"); strSql.Append("model=@model,"); strSql.Append("jigNo=@jigNo,"); strSql.Append("cavityCount=@cavityCount,"); strSql.Append("partsWeight=@partsWeight,"); strSql.Append("cycleTime=@cycleTime,"); strSql.Append("blockCount=@blockCount,"); strSql.Append("unitCount=@unitCount,"); strSql.Append("machineID=@machineID,"); strSql.Append("userName=@userName,"); strSql.Append("dateTime=@dateTime,"); strSql.Append("remarks=@remarks"); strSql.Append("partNumberAll=@partNumberAll"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@partNumber", SqlDbType.VarChar, 50), new SqlParameter("@matPart01", SqlDbType.VarChar, 50), new SqlParameter("@matPart02", SqlDbType.VarChar, 50), new SqlParameter("@customer", SqlDbType.VarChar, 50), new SqlParameter("@model", SqlDbType.VarChar, 50), new SqlParameter("@jigNo", SqlDbType.VarChar, 50), new SqlParameter("@cavityCount", SqlDbType.Decimal, 9), new SqlParameter("@partsWeight", SqlDbType.Decimal, 9), new SqlParameter("@cycleTime", SqlDbType.Decimal, 9), new SqlParameter("@blockCount", SqlDbType.Int, 4), new SqlParameter("@unitCount", SqlDbType.Int, 4), new SqlParameter("@machineID", SqlDbType.VarChar, 8), new SqlParameter("@userName", SqlDbType.VarChar, 50), new SqlParameter("@dateTime", SqlDbType.SmallDateTime), new SqlParameter("@remarks", SqlDbType.VarChar, 500), new SqlParameter("@partNumberAll", SqlDbType.VarChar, 500) }; parameters[0].Value = model.partNumber == null ? (object)DBNull.Value : model.partNumber; parameters[1].Value = model.matPart01 == null ? (object)DBNull.Value : model.matPart01; parameters[2].Value = model.matPart02 == null ? (object)DBNull.Value : model.matPart02; parameters[3].Value = model.customer == null ? (object)DBNull.Value : model.customer; parameters[4].Value = model.model == null ? (object)DBNull.Value : model.model; parameters[5].Value = model.jigNo == null ? (object)DBNull.Value : model.jigNo; parameters[6].Value = model.cavityCount == null ? (object)DBNull.Value : model.cavityCount; parameters[7].Value = model.partsWeight == null ? (object)DBNull.Value : model.partsWeight; parameters[8].Value = model.cycleTime == null ? (object)DBNull.Value : model.cycleTime; parameters[9].Value = model.blockCount == null ? (object)DBNull.Value : model.blockCount; parameters[10].Value = model.unitCount == null ? (object)DBNull.Value : model.unitCount; parameters[11].Value = model.machineID == null ? (object)DBNull.Value : model.machineID; parameters[12].Value = model.userName == null ? (object)DBNull.Value : model.userName; parameters[13].Value = model.dateTime == null ? (object)DBNull.Value : model.dateTime; parameters[14].Value = model.remarks == null ? (object)DBNull.Value : model.remarks; parameters[15].Value = model.partnumberall == null ? (object)DBNull.Value : model.partnumberall; DBHelp.Reports.LogFile.DebugLog("AUTOCODE", "NameSpace:Common.DAL", "Class:MouldingBom_DAL", "Function: public bool Update(Common.Model.MouldingBom_Model model)"+ "TableName:MouldingBom", ";partNumber = " + (model.partNumber == null ? "" : model.partNumber.ToString()) + ";matPart01 = " + (model.matPart01 == null ? "" : model.matPart01.ToString()) + ";matPart02 = " + (model.matPart02 == null ? "" : model.matPart02.ToString()) + ";customer = " + (model.customer == null ? "" : model.customer.ToString()) + ";model = " + (model.model == null ? "" : model.model.ToString()) + ";jigNo = " + (model.jigNo == null ? "" : model.jigNo.ToString()) + ";cavityCount = " + (model.cavityCount == null ? "" : model.cavityCount.ToString()) + ";partsWeight = " + (model.partsWeight == null ? "" : model.partsWeight.ToString()) + ";cycleTime = " + (model.cycleTime == null ? "" : model.cycleTime.ToString()) + ";blockCount = " + (model.blockCount == null ? "" : model.blockCount.ToString()) + ";unitCount = " + (model.unitCount == null ? "" : model.unitCount.ToString()) + ";machineID = " + (model.machineID == null ? "" : model.machineID.ToString()) + ";userName = "******"" : model.userName.ToString()) + ";dateTime = " + (model.dateTime == null ? "" : model.dateTime.ToString()) + ";remarks = " + (model.remarks == null ? "" : model.remarks.ToString()) + ""); int rows = DBHelp.SqlDB.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }