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