private void PrepareAddCommand(MaterialPlanStockModel model, out string cmdText, out SqlParameter[] parameters) { StringBuilder builder = new StringBuilder(); builder.Append("insert into Sm_Wantplan_Stock("); builder.Append("wpsid,scode,wpcode,number,arrivalDate,DesignCode,Remark,TaskId)"); builder.Append(" values ("); builder.Append("@wpsid,@scode,@wpcode,@number,@arrivalDate,@designCode,@remark,@taskId)"); parameters = new SqlParameter[] { new SqlParameter("@wpsid", SqlDbType.NVarChar, 50), new SqlParameter("@scode", SqlDbType.VarChar, 50), new SqlParameter("@wpcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@arrivalDate", SqlDbType.DateTime), new SqlParameter("@designCode", SqlDbType.NVarChar, 100), new SqlParameter("@remark", SqlDbType.NVarChar), new SqlParameter("@taskId", SqlDbType.NVarChar, 0x40) }; parameters[0].Value = model.wpsid; parameters[1].Value = model.scode; parameters[2].Value = model.wpcode; parameters[3].Value = model.number; if (model.ArrivalDate == null) { parameters[4].Value = DBNull.Value; } else { parameters[4].Value = model.ArrivalDate; } parameters[5].Value = model.DesignCode; parameters[6].Value = model.Remark; if (string.IsNullOrEmpty(model.TaskId)) { parameters[7].Value = string.Empty; } else { parameters[7].Value = model.TaskId; } cmdText = builder.ToString(); }
public MaterialPlanStockModel ReaderBind(IDataReader dataReader) { MaterialPlanStockModel model = new MaterialPlanStockModel { wpsid = dataReader["wpsid"].ToString(), scode = dataReader["scode"].ToString(), wpcode = dataReader["wpcode"].ToString() }; object obj2 = dataReader["number"]; if ((obj2 != null) && (obj2 != DBNull.Value)) { model.number = Convert.ToInt32(obj2); } obj2 = dataReader["arrivalDate"]; if ((obj2 != null) && (obj2 != DBNull.Value)) { model.ArrivalDate = obj2.ToString(); } obj2 = dataReader["arrivalDateNeed"]; if ((obj2 != null) && (obj2 != DBNull.Value)) { model.ArrivalDateNeed = obj2.ToString(); } model.Remark = dataReader["remark"].ToString(); return(model); }
public int Add(SqlTransaction truans, MaterialPlanStockModel model) { SqlParameter[] parameterArray; string cmdText = string.Empty; this.PrepareAddCommand(model, out cmdText, out parameterArray); return(SqlHelper.ExecuteNonQuery(truans, CommandType.Text, cmdText, parameterArray)); }
public MaterialPlanStockModel GetModel(string wpsid) { StringBuilder builder = new StringBuilder(); builder.Append("select wpsid,scode,wpcode,number,arrivalDate,remark from Sm_Wantplan_Stock "); builder.Append(" where wpsid=@wpsid "); MaterialPlanStockModel model = null; using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@wpsid", wpsid) })) { if (reader.Read()) { model = this.ReaderBind(reader); } } return(model); }
public MaterialPlanStockModel getWantPlanStockRow(string wpsid) { StringBuilder builder = new StringBuilder(); MaterialPlanStockModel model = new MaterialPlanStockModel(); builder.Append(" select * from Sm_Wantplan_Stock where wpsid=@wpsid"); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@wpsid", SqlDbType.NVarChar, 50) }; commandParameters[0].Value = wpsid; using (SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), commandParameters)) { while (reader.Read()) { model.wpsid = reader.GetString(0); model.scode = reader.GetString(1); model.wpcode = reader.GetString(2); model.number = reader.GetInt32(3); } } return(model); }
public int Update(MaterialPlanStockModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update Sm_Wantplan_Stock set "); builder.Append("scode=@scode,"); builder.Append("wpcode=@wpcode,"); builder.Append("number=@number, "); builder.Append("arrivalDate=@arrivalDate, "); builder.Append("DesignCode=@designCode, "); builder.Append("Remark=@remark "); builder.Append(" where wpsid=@wpsid "); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@wpsid", SqlDbType.NVarChar, 50), new SqlParameter("@scode", SqlDbType.VarChar, 50), new SqlParameter("@wpcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@arrivalDate", SqlDbType.DateTime), new SqlParameter("@designCode", SqlDbType.NVarChar, 100), new SqlParameter("@remark", SqlDbType.NVarChar) }; commandParameters[0].Value = model.wpsid; commandParameters[1].Value = model.scode; commandParameters[2].Value = model.wpcode; commandParameters[3].Value = model.number; commandParameters[4].Value = model.ArrivalDate; commandParameters[5].Value = model.DesignCode; commandParameters[6].Value = model.Remark; return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters)); }
public int Add(MaterialPlanStockModel model) { return(this.meterialPlanStock.Add(model)); }
public int Update(MaterialPlanStockModel model) { return(this.meterialPlanStock.Update(model)); }
private bool addMaterialList(SqlTransaction trans, ref string message) { bool result = true; if (this.gvSmWantPlanStock.Rows.Count > 0) { System.Collections.Generic.List <MaterialPlanStockModel> list = new System.Collections.Generic.List <MaterialPlanStockModel>(); System.Collections.Generic.Dictionary <string, decimal> dictionary = new System.Collections.Generic.Dictionary <string, decimal>(); foreach (GridViewRow gridViewRow in this.gvSmWantPlanStock.Rows) { MaterialPlanStockModel materialPlanStockModel = new MaterialPlanStockModel(); TextBox textBox = (TextBox)gridViewRow.FindControl("txtNumber"); Label label = (Label)gridViewRow.FindControl("lblCode"); Label label2 = (Label)gridViewRow.FindControl("lblDesignCode1"); TextBox textBox2 = (TextBox)gridViewRow.FindControl("txtarrivalDate"); TextBox textBox21 = (TextBox)gridViewRow.FindControl("txtarrivalDateNeed"); TextBox textBox3 = (TextBox)gridViewRow.FindControl("txtRemark"); materialPlanStockModel.scode = label.Text; materialPlanStockModel.wpcode = this.txtCode.Text; materialPlanStockModel.number = System.Convert.ToDecimal(textBox.Text); if (textBox2.Text.Trim().ToString() != "") { materialPlanStockModel.ArrivalDate = textBox2.Text.Trim().ToString(); } if (textBox21.Text.Trim().ToString() != "") { materialPlanStockModel.ArrivalDateNeed = textBox21.Text.Trim().ToString(); } materialPlanStockModel.DesignCode = label2.Text.Trim(); materialPlanStockModel.Remark = textBox3.Text.Trim(); HiddenField hiddenField = gridViewRow.FindControl("hfldTaskId") as HiddenField; if (!string.IsNullOrEmpty(hiddenField.Value.Trim())) { materialPlanStockModel.TaskId = hiddenField.Value.Trim(); } else { materialPlanStockModel.TaskId = string.Empty; } list.Add(materialPlanStockModel); foreach (string current in dictionary.Keys) { if (current == materialPlanStockModel.scode) { decimal dl = dictionary[materialPlanStockModel.scode]; dictionary[materialPlanStockModel.scode] = dl + materialPlanStockModel.number; } else { dictionary.Add(materialPlanStockModel.scode, materialPlanStockModel.number); } } } string str1 = StockParameter.ProjectAlarm; string str2 = ProjectAlarm.UnAlarm.ToString(); if (str1 == str2) // if (StockParameter.ProjectAlarm == ProjectAlarm.UnAlarm.ToString()) { DataTable dataTable = this.ViewState["MaterialPlanTable"] as DataTable; DataTable resourcesTable = this.ViewState["ResourcesTable"] as DataTable; if (dataTable != null && dataTable.Rows.Count != 0) { foreach (string current in dictionary.Keys) { DataRow[] array = dataTable.Select(string.Format("rCode = '{0}'", current)); if (array != null && array.Length != 0) { decimal d = System.Convert.ToDecimal(array[0]["fNumber"]); decimal d2 = System.Convert.ToDecimal(array[0]["aNumber"]); decimal d3 = dictionary[current]; if (d < d2 + d3) { message = message + this.getResourcesName(current, resourcesTable) + " 超出预算数量"; result = false; break; } } } } } this.materialStock.Add(trans, list); } return(result); }