public SendGoodsModel GetModel(string sgId)
{
StringBuilder builder = new StringBuilder();
builder.Append("select sgId,scode,snCode,number,suppyCode,price from sm_sendGoods ");
builder.Append(" where sgId=@sgId ");
SendGoodsModel model = null;
using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@sgId", sgId) }))
{
if (reader.Read())
{
model = this.ReaderBind(reader);
}
}
return(model);
}
public SendGoodsModel ReaderBind(IDataReader dataReader)
{
SendGoodsModel model = new SendGoodsModel {
sgId = dataReader["sgId"].ToString(),
scode = dataReader["scode"].ToString(),
snCode = dataReader["snCode"].ToString()
};
if (dataReader["number"].ToString() != "")
{
model.Number = new decimal?(decimal.Parse(dataReader["number"].ToString()));
}
model.suppyCode = dataReader["suppyCode"].ToString();
if (dataReader["price"].ToString() != "")
{
model.Price = new decimal?(decimal.Parse(dataReader["price"].ToString()));
}
return(model);
}
public int Add(SqlTransaction trans, SendGoodsModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into sm_sendGoods(");
builder.Append("sgId,scode,snCode,number,suppyCode,price)");
builder.Append(" values (");
builder.Append("@sgId,@scode,@snCode,@number,@suppyCode,@price)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@sgId", SqlDbType.NVarChar, 0x40), new SqlParameter("@scode", SqlDbType.VarChar, 100), new SqlParameter("@snCode", SqlDbType.NVarChar, 0x40), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@suppyCode", SqlDbType.VarChar, 100), new SqlParameter("@price", SqlDbType.Decimal, 9) };
commandParameters[0].Value = model.sgId;
commandParameters[1].Value = model.scode;
commandParameters[2].Value = model.snCode;
commandParameters[3].Value = model.Number;
commandParameters[4].Value = model.suppyCode;
commandParameters[5].Value = model.Price;
if (trans == null)
{
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
public int Update(SqlTransaction trans, SendGoodsModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update sm_sendGoods set ");
builder.Append("scode=@scode,");
builder.Append("snCode=@snCode,");
builder.Append("number=@number,");
builder.Append("suppyCode=@suppyCode,");
builder.Append("price=@price");
builder.Append(" where sgId=@sgId ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@scode", SqlDbType.VarChar, 100), new SqlParameter("@snCode", SqlDbType.NVarChar, 0x40), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@suppyCode", SqlDbType.VarChar, 100), new SqlParameter("@sgId", SqlDbType.NVarChar, 0x40), new SqlParameter("@price", SqlDbType.Decimal, 9) };
commandParameters[0].Value = model.scode;
commandParameters[1].Value = model.snCode;
commandParameters[2].Value = model.Number;
commandParameters[3].Value = model.suppyCode;
commandParameters[4].Value = model.sgId;
commandParameters[5].Value = model.Price;
if (trans == null)
{
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
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 void Add(SqlTransaction trans, SendGoodsModel modelGoods)
{
this.sendgoods.Add(trans, modelGoods);
}