public int Update(SqlTransaction trans, SendNodteModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update sm_SendNote set ");
builder.Append("snCode=@snCode,");
builder.Append("snAddTime=@snAddTime,");
builder.Append("snAddUser=@snAddUser,");
builder.Append("sendState=@sendState,");
builder.Append("remark=@remark,");
builder.Append("prjCode=@prjCode,");
builder.Append("limits=@limits");
builder.Append(" where snId=@snId ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@snCode", SqlDbType.VarChar, 100), new SqlParameter("@snAddTime", SqlDbType.DateTime), new SqlParameter("@snAddUser", SqlDbType.VarChar, 50), new SqlParameter("@sendState", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 0x3e8), new SqlParameter("@prjCode", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@snId", SqlDbType.NVarChar, 0x40), new SqlParameter("@limits", SqlDbType.VarChar, 0x3e8) };
commandParameters[0].Value = model.snCode;
commandParameters[1].Value = model.snAddTime;
commandParameters[2].Value = model.snAddUser;
commandParameters[3].Value = model.sendState;
commandParameters[4].Value = model.remark;
commandParameters[5].Value = model.prjCode;
commandParameters[6].Value = model.snId;
commandParameters[7].Value = model.Limits;
if (trans == null)
{
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
public void InitPage()
{
PtYhmcBll ptYhmcBll = new PtYhmcBll();
SendNodteModel sendNoteModel = this.sendNote.GetSendNoteModel(base.Request.QueryString["ic"]);
this.lblremark.Text = sendNoteModel.remark;
this.lblsnCode.Text = sendNoteModel.snCode;
this.lblsnAddUser.Text = ptYhmcBll.GetModelById(sendNoteModel.snAddUser).v_xm;
this.lblsnAddTime.Text = sendNoteModel.snAddTime.ToString();
PrjInfoModel modelByPrjGuid = this.pTPrjInfoBll.GetModelByPrjGuid(sendNoteModel.prjCode.ToString());
if (modelByPrjGuid != null)
{
this.lblProjectName.Text = modelByPrjGuid.PrjName;
}
this.lblBllProducer.Text = ptYhmcBll.GetModelById(base.UserCode).v_xm;
this.lblPrintDate.Text = DateTime.Now.ToShortDateString();
this.hdGuid.Value = sendNoteModel.snId;
string userName = this.am.GetUserName(sendNoteModel.Limits.ToString());
this.labLimit.Text = userName;
string[] snId = new string[]
{
sendNoteModel.snId
};
this.ViewState["DataTable"] = this.sendGoods.GetResourceBypncode(snId);
this.BindGv();
}
public void InitPage()
{
if (base.Request.QueryString["t"] != null)
{
this.btnDel.Enabled = false;
this.btnSave.Enabled = false;
this.btnSelectByd.Disabled = true;
}
if (base.Request.QueryString["id"] != null)
{
this.lblTitle.Text = "编辑发货通知单";
SendNodteModel sendNoteModel = this.sendnote.GetSendNoteModel(base.Request.QueryString["id"]);
this.txtAddUser.Value = this.yhmc.GetModelById(sendNoteModel.snAddUser).v_xm;
this.txtremark.Text = sendNoteModel.remark;
this.txtsnAddTime.Text = sendNoteModel.snAddTime.ToString();
this.txtsnCode.Text = sendNoteModel.snCode;
this.txtProjectName.Value = this.pTPrjInfoBll.GetModelByPrjGuid(sendNoteModel.prjCode.ToString()).PrjName;
this.hdnProjectCode.Value = sendNoteModel.prjCode.ToString();
this.hdGuid.Value = sendNoteModel.snId;
this.hdnCodeList.Value = "1";
string userName = this.am.GetUserName(sendNoteModel.Limits.ToString());
this.hf.Value = sendNoteModel.Limits.ToString();
this.TBoxConsignee.Value = userName;
string[] snId = new string[]
{
sendNoteModel.snId
};
this.ViewState["DataTable"] = this.sendgoods.GetResourceBypncode(snId);
this.BindGv();
return;
}
this.lblTitle.Text = "新增发货通知单";
this.hdnProjectCode.Value = this.prjId;
this.txtProjectName.Value = this.pTPrjInfoBll.GetModelByPrjGuid(this.prjId).PrjName;
this.txtsnCode.Text = DateTime.Now.ToString("yyyyMMddHHmmss");
this.txtsnAddTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
this.hdGuid.Value = Guid.NewGuid().ToString();
this.txtAddUser.Value = PageHelper.QueryUser(this, base.UserCode);
string[] snId2 = new string[]
{
"''"
};
DataTable resourceBypncode = this.sendgoods.GetResourceBypncode(snId2);
this.ViewState["DataTable"] = resourceBypncode;
this.BindGv();
}
public SendNodteModel GetModel(string snId)
{
StringBuilder builder = new StringBuilder();
builder.Append("select snId,snCode,snAddTime,snAddUser,sendState,remark,prjCode,limits from sm_SendNote ");
builder.Append(" where snId=@snId ");
SendNodteModel model = null;
using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@snId", snId) }))
{
if (reader.Read())
{
model = this.ReaderBind(reader);
}
}
return(model);
}
public void InitPage()
{
if (base.Request.QueryString["id"] != null)
{
SendNodteModel sendNodteModel = new SendNodteModel();
string a = base.Request["type"].ToString();
if (a == "add")
{
sendNodteModel = this.sendnote.GetSendNoteModel(base.Request.QueryString["id"]);
this.lblTitle.Text = "新增发货通知单";
this.hdfSnId.Value = Guid.NewGuid().ToString();
string[] snId = new string[]
{
sendNodteModel.snId
};
this.ViewState["DataTable"] = this.sendgoods.GetResourceBypncode(snId);
string value = "/StockManage/sendGoods/ViewSendNote.aspx?ic=" + base.Request["id"].ToString();
this.ifView.Attributes.Add("src", value);
}
else
{
if (a == "edit")
{
sm_receiveNote modelByrnId = this.receiveNote.GetModelByrnId(base.Request.QueryString["id"]);
this.lblTitle.Text = "编辑发货通知单";
this.hdfSnId.Value = modelByrnId.rnId.ToString();
this.txtRemark.Text = modelByrnId.remark.ToString();
this.txtExplain.Text = modelByrnId.Explain.ToString();
string[] rnid = new string[]
{
modelByrnId.rnId
};
this.ViewState["DataTable"] = this.receiveGood.getResourceByRnid(rnid);
sendNodteModel = this.sendnote.GetSendNoteModel(modelByrnId.snId);
string value2 = "/StockManage/sendGoods/ViewSendNote.aspx?ic=" + modelByrnId.snId;
this.ifView.Attributes.Add("src", value2);
}
}
this.hdfSendUser.Value = sendNodteModel.snAddUser;
this.hdfPrjCode.Value = sendNodteModel.prjCode.ToString();
this.hdGuid.Value = sendNodteModel.snId;
this.hdfrnCode.Value = sendNodteModel.snCode;
this.hdnCodeList.Value = "1";
this.BindGv();
}
}
public void SendModel()
{
PtYhmcBll ptYhmcBll = new PtYhmcBll();
SendNodteModel sendNoteModel = this.sendNote.GetSendNoteModel(this.hdfSend.Value);
this.sendremark.Text = sendNoteModel.remark;
this.sendCode.Text = sendNoteModel.snCode;
this.sendAddUser.Text = ptYhmcBll.GetModelById(sendNoteModel.snAddUser).v_xm;
this.sendAddTime.Text = sendNoteModel.snAddTime.ToString();
this.lblProjectName.Text = this.pTPrjInfoBll.GetModelByPrjGuid(sendNoteModel.prjCode.ToString()).PrjName;
string userName = this.am.GetUserName(sendNoteModel.Limits.ToString());
this.sendLimit.Text = userName;
string[] snId = new string[]
{
sendNoteModel.snId
};
this.ViewState["DataSend"] = this.sendGoods.GetResourceBypncode(snId);
this.SendResoce();
}
public SendNodteModel ReaderBind(IDataReader dataReader)
{
SendNodteModel model = new SendNodteModel {
snId = dataReader["snId"].ToString(),
snCode = dataReader["snCode"].ToString()
};
if (dataReader["snAddTime"].ToString() != "")
{
model.snAddTime = new DateTime?(DateTime.Parse(dataReader["snAddTime"].ToString()));
}
model.snAddUser = dataReader["snAddUser"].ToString();
if (dataReader["sendState"].ToString() != "")
{
model.sendState = new int?(int.Parse(dataReader["sendState"].ToString()));
}
model.remark = dataReader["remark"].ToString();
if (dataReader["prjCode"].ToString() != "")
{
model.prjCode = new Guid(dataReader["prjCode"].ToString());
}
model.Limits = dataReader["limits"].ToString();
return(model);
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString))
{
sqlConnection.Open();
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
try
{
SendNodteModel sendNodteModel = new SendNodteModel();
sendNodteModel.sendState = new int?(0);
sendNodteModel.remark = this.txtremark.Text;
sendNodteModel.snId = this.hdGuid.Value;
sendNodteModel.snAddTime = new DateTime?(Convert.ToDateTime(this.txtsnAddTime.Text));
sendNodteModel.snAddUser = base.UserCode;
sendNodteModel.snCode = this.txtsnCode.Text;
if (this.hdnProjectCode.Value != "")
{
sendNodteModel.prjCode = new Guid(this.hdnProjectCode.Value);
}
else
{
sendNodteModel.prjCode = new Guid("00000000-0000-0000-0000-000000000000");
}
sendNodteModel.Limits = (
from c in this.hf.Value.Split(new char[]
{
','
})
where c.Length == 8
select c).ToCsv();
int num;
if (base.Request.QueryString["id"] != null)
{
num = this.sendnote.Update(sqlTransaction, sendNodteModel);
}
else
{
num = this.sendnote.Add(sqlTransaction, sendNodteModel);
}
int num2 = 0;
if (num != 0)
{
this.sendgoods.DeleteBysnId(sqlTransaction, sendNodteModel.snId);
DataTable dataTable = (DataTable)this.ViewState["DataTable"];
if (dataTable != null)
{
int num3 = 0;
foreach (DataRow dataRow in dataTable.Rows)
{
TextBox textBox = this.gvNeedNote.Rows[num3].FindControl("txtNum") as TextBox;
SendGoodsModel sendGoodsModel = new SendGoodsModel();
if (textBox.Text != "")
{
sendGoodsModel.Number = new decimal?(Convert.ToDecimal(textBox.Text));
}
else
{
sendGoodsModel.Number = new decimal?(0m);
}
sendGoodsModel.scode = dataRow["scode"].ToString();
sendGoodsModel.snCode = this.hdGuid.Value;
sendGoodsModel.sgId = Guid.NewGuid().ToString();
TextBox textBox2 = this.gvNeedNote.Rows[num3].FindControl("txtPrice") as TextBox;
try
{
sendGoodsModel.Price = new decimal?(Convert.ToDecimal(textBox2.Text.ToString()));
}
catch
{
sendGoodsModel.Price = new decimal?(0m);
}
Label label = this.gvNeedNote.Rows[num3].FindControl("labCrop") as Label;
if (label.ToolTip == "")
{
num2 = 1;
break;
}
sendGoodsModel.suppyCode = label.ToolTip;
this.sendgoods.Add(sqlTransaction, sendGoodsModel);
num3++;
}
if (num2 == 1)
{
base.RegisterScript("top.ui.alert('供应商不能为空');");
return;
}
}
}
if (num2 == 0)
{
this.UpdateWantplanAState(sqlTransaction, this.hdlfWantplanCodes.Value.Trim());
sqlTransaction.Commit();
string mes;
if (base.Request.QueryString["id"] != null)
{
mes = "现场收货通知：发货单号为" + sendNodteModel.snCode + "的发货单已修改。";
}
mes = "现场收货通知：发货单号为" + sendNodteModel.snCode + "的物资已发货。";
string[] array = (
from c in this.hf.Value.Split(new char[]
{
','
})
where c.Length == 8
select c).ToArray <string>();
string[] array2 = array;
for (int i = 0; i < array2.Length; i++)
{
string jsyhdm = array2[i];
this.getOrganiger(sendNodteModel.snId, mes, jsyhdm);
}
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("top.ui.show('" + this.SetMsg() + "成功！');").Append(Environment.NewLine);
stringBuilder.Append("top.ui.tabSuccess({parentName: '_addSendNote'});");
base.RegisterScript(stringBuilder.ToString());
}
else
{
if (num2 == 1)
{
new StringBuilder();
base.RegisterScript("top.ui.show('" + this.SetMsg() + "失败！');");
}
}
}
catch
{
sqlTransaction.Rollback();
base.RegisterScript("alert('系统提示：\\n\\n对不起" + this.SetMsg() + "失败！');");
}
}
}
public int Update(SqlTransaction trans, SendNodteModel model)
{
return(this.sendnote.Update(trans, model));
}
public int Add(SqlTransaction trans, SendNodteModel model)
{
return(this.sendnote.Add(trans, model));
}