public int Update(SqlTransaction trans, SmPurchaseplanStockModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Sm_Purchaseplan_Stock set ");
builder.Append("scode=@scode,");
builder.Append("ppcode=@ppcode,");
builder.Append("number=@number,");
builder.Append("arrivalDate=@arrivalDate, ");
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("@ppcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@arrivalDate", SqlDbType.DateTime), new SqlParameter("@remark", SqlDbType.NVarChar) };
commandParameters[0].Value = model.wpsid;
commandParameters[1].Value = model.scode;
commandParameters[2].Value = model.ppcode;
commandParameters[3].Value = model.number;
if (model.ArrivalDate == "")
{
commandParameters[4].Value = DBNull.Value;
}
else
{
commandParameters[4].Value = model.ArrivalDate;
}
commandParameters[5].Value = model.remark;
if (trans == null)
{
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
public int Add(SqlTransaction trans, SmPurchaseplanStockModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Sm_Purchaseplan_Stock(");
builder.Append("wpsid,scode,ppcode,number,arrivalDate,remark)");
builder.Append(" values (");
builder.Append("@wpsid,@scode,@ppcode,@number,@arrivalDate,@remark)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@wpsid", SqlDbType.NVarChar, 50), new SqlParameter("@scode", SqlDbType.VarChar, 50), new SqlParameter("@ppcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@arrivalDate", SqlDbType.DateTime), new SqlParameter("@remark", SqlDbType.NVarChar) };
commandParameters[0].Value = model.wpsid;
commandParameters[1].Value = model.scode;
commandParameters[2].Value = model.ppcode;
commandParameters[3].Value = model.number;
if ((model.ArrivalDate == "") || (model.ArrivalDate == null))
{
commandParameters[4].Value = DBNull.Value;
}
else
{
commandParameters[4].Value = model.ArrivalDate;
}
commandParameters[5].Value = model.remark;
if (trans == null)
{
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
public SmPurchaseplanStockModel GetModel(string wpsid)
{
StringBuilder builder = new StringBuilder();
builder.Append("select wpsid,scode,ppcode,number,arrivalDate,remark from Sm_Purchaseplan_Stock ");
builder.Append(" where wpsid=@wpsid ");
SmPurchaseplanStockModel 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 SmPurchaseplanStockModel ReaderBind(IDataReader dataReader)
{
SmPurchaseplanStockModel model = new SmPurchaseplanStockModel {
wpsid = dataReader["wpsid"].ToString(),
scode = dataReader["scode"].ToString(),
ppcode = dataReader["ppcode"].ToString()
};
object obj2 = dataReader["number"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.number = (decimal)obj2;
}
obj2 = dataReader["arrivalDate"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.ArrivalDate = (string)obj2;
}
return(model);
}
public int Update(SqlTransaction trans, SmPurchaseplanStockModel model)
{
return(this.smPurchaseplanStock.Update(trans, model));
}
public int Add(SqlTransaction trans, SmPurchaseplanStockModel model)
{
return(this.smPurchaseplanStock.Add(trans, model));
}
private void save(string type)
{
using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString))
{
sqlConnection.Open();
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
try
{
SmPurchaseplanModel smPurchaseplanModel = new SmPurchaseplanModel();
smPurchaseplanModel.acceptstate = 0;
smPurchaseplanModel.annx = "";
smPurchaseplanModel.explain = this.txtExplain.Text;
smPurchaseplanModel.flowstate = Convert.ToInt32(this.hdflowstate.Value);
smPurchaseplanModel.intime = Convert.ToDateTime(this.txtInTime.Text);
smPurchaseplanModel.person = this.txtPeople.Value;
smPurchaseplanModel.ppcode = this.txtPPCode.Text;
smPurchaseplanModel.ppid = this.hdGuid.Value;
smPurchaseplanModel.Project = this.hdnProjectCode.Value;
int num;
if (base.Request.QueryString["id"] != null)
{
num = this.smPurchaseplanBll.Update(sqlTransaction, smPurchaseplanModel);
}
else
{
num = this.smPurchaseplanBll.Add(sqlTransaction, smPurchaseplanModel);
}
if (num != 0)
{
this.smPurchaseplanStockBll.DeleteByWhere(sqlTransaction, " where ppcode='" + smPurchaseplanModel.ppcode + "'");
DataTable dataTable = (DataTable)this.ViewState["DataTable"];
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
SmPurchaseplanStockModel smPurchaseplanStockModel = new SmPurchaseplanStockModel();
smPurchaseplanStockModel.scode = dataRow["scode"].ToString();
smPurchaseplanStockModel.number = this.GetNumByScode(dataRow["scode"].ToString());
smPurchaseplanStockModel.ppcode = this.txtPPCode.Text;
smPurchaseplanStockModel.wpsid = Guid.NewGuid().ToString();
if (this.gvNeedNote.Rows.Count > 0)
{
foreach (GridViewRow gridViewRow in this.gvNeedNote.Rows)
{
Label label = (Label)gridViewRow.FindControl("lbscode");
string text = label.Text;
if (text == dataRow["scode"].ToString())
{
TextBox textBox = (TextBox)gridViewRow.FindControl("txtarrivalDate");
if (!string.IsNullOrEmpty(textBox.Text.Trim()))
{
smPurchaseplanStockModel.ArrivalDate = textBox.Text.Trim().ToString();
}
else
{
smPurchaseplanStockModel.ArrivalDate = "";
}
TextBox textBox1 = (TextBox)gridViewRow.FindControl("txtarrivalDateNeed");
if (!string.IsNullOrEmpty(textBox1.Text.Trim()))
{
smPurchaseplanStockModel.ArrivalDateNeed = textBox1.Text.Trim().ToString();
}
else
{
smPurchaseplanStockModel.ArrivalDateNeed = "";
}
TextBox textBox2 = (TextBox)gridViewRow.FindControl("txtRemark");
smPurchaseplanStockModel.remark = textBox2.Text.Trim();
break;
}
}
}
this.smPurchaseplanStockBll.Add(sqlTransaction, smPurchaseplanStockModel);
}
}
}
this.UpdateWantplanAState(sqlTransaction, this.hdlfWantplanCodes.Value);
sqlTransaction.Commit(); StringBuilder stringBuilder = new StringBuilder();
if (type == "pc")
{
string arg_317_0 = string.Empty;
stringBuilder.Append("top.ui.show('" + this.SetMsg() + "成功！');").Append(Environment.NewLine);
stringBuilder.Append("winclose('AddSmPurchaseplan','SmPurchaseplanList.aspx?PrjGuid=" + this.hdnProjectCode.Value + "',true)");
}
else
{
stringBuilder.Append("alert('保存成功');");
stringBuilder.Append("parent.location.reload();");
} base.RegisterScript(stringBuilder.ToString());
}
catch (Exception)
{
sqlTransaction.Rollback();
if (type == "pc")
{
base.RegisterScript("top.ui.show('" + this.SetMsg() + "失败！');");
}
else
{
base.RegisterScript("alert(('" + this.SetMsg() + "失败！'));");
}
}
}
}
