public receiveGoods GetModel(string sgId)
{
StringBuilder builder = new StringBuilder();
builder.Append("select sgId,scode,rnID,number,price,suppyCode from sm_receiveGoods ");
builder.Append(" where sgId=@sgId ");
receiveGoods goods = null;
using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@sgId", sgId) }))
{
if (reader.Read())
{
goods = this.ReaderBind(reader);
}
}
return(goods);
}
public receiveGoods ReaderBind(IDataReader dataReader)
{
receiveGoods goods = new receiveGoods {
sgId = dataReader["sgId"].ToString(),
scode = dataReader["scode"].ToString(),
rnID = dataReader["rnID"].ToString()
};
if (dataReader["number"].ToString() != "")
{
goods.number = new decimal?(decimal.Parse(dataReader["number"].ToString()));
}
if (dataReader["price"].ToString() != "")
{
goods.price = new decimal?(decimal.Parse(dataReader["price"].ToString()));
}
goods.suppyCode = dataReader["suppyCode"].ToString();
return(goods);
}
public int Add(SqlTransaction trans, receiveGoods model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into sm_receiveGoods(");
builder.Append("sgId,scode,rnID,number,price,suppyCode)");
builder.Append(" values (");
builder.Append("@sgId,@scode,@rnID,@number,@price,@suppyCode)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@sgId", SqlDbType.NVarChar, 0x40), new SqlParameter("@scode", SqlDbType.NVarChar, 0x40), new SqlParameter("@rnID", SqlDbType.NVarChar, 0x40), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@price", SqlDbType.Decimal, 9), new SqlParameter("@suppyCode", SqlDbType.NVarChar, 50) };
commandParameters[0].Value = model.sgId;
commandParameters[1].Value = model.scode;
commandParameters[2].Value = model.rnID;
commandParameters[3].Value = model.number;
commandParameters[4].Value = model.price;
commandParameters[5].Value = model.suppyCode;
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, receiveGoods model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update sm_receiveGoods set ");
builder.Append("scode=@scode,");
builder.Append("rnID=@rnID,");
builder.Append("number=@number,");
builder.Append("price=@price,");
builder.Append("suppyCode=@suppyCode");
builder.Append(" where sgId=@sgId ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@scode", SqlDbType.NVarChar, 0x40), new SqlParameter("@rnID", SqlDbType.NVarChar, 0x40), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@price", SqlDbType.Decimal, 9), new SqlParameter("@suppyCode", SqlDbType.NVarChar, 50), new SqlParameter("@sgId", SqlDbType.NVarChar, 0x40) };
commandParameters[0].Value = model.scode;
commandParameters[1].Value = model.rnID;
commandParameters[2].Value = model.number;
commandParameters[3].Value = model.price;
commandParameters[4].Value = model.suppyCode;
commandParameters[5].Value = model.sgId;
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)
{
if (this.treasuryBll.IsRelationTreasury(this.hdfPrjCode.Value))
{
string str = "";
using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString))
{
sqlConnection.Open();
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
try
{
sm_receiveNote sm_receiveNote = new sm_receiveNote();
sm_receiveNote.remark = this.txtRemark.Text.ToString();
sm_receiveNote.snId = this.hdGuid.Value;
sm_receiveNote.rnTime = new DateTime?(DateTime.Now);
sm_receiveNote.rnUser = base.UserCode;
sm_receiveNote.rnId = this.hdfSnId.Value;
sm_receiveNote.rnCode = this.hdfrnCode.Value;
sm_receiveNote.stId = "";
sm_receiveNote.soId = "";
sm_receiveNote.Explain = this.txtExplain.Text.ToString();
int num = 0;
string a = base.Request["type"].ToString();
if (a == "add")
{
num = this.receiveNote.Add(sqlTransaction, sm_receiveNote);
}
else
{
if (a == "edit")
{
num = this.receiveNote.Update(sqlTransaction, sm_receiveNote);
this.receiveGood.Delete(sqlTransaction, this.hdfSnId.Value);
}
}
if (num != 0)
{
DataTable dataTable = (DataTable)this.ViewState["DataTable"];
if (dataTable != null)
{
int num2 = 0;
foreach (DataRow dataRow in dataTable.Rows)
{
if (base.Request.QueryString["id"] == null && string.IsNullOrEmpty(this.hdnCodeList.Value))
{
str = str + "'" + dataRow["wpcode"].ToString() + "',";
}
TextBox textBox = this.gvNeedNote.Rows[num2].FindControl("txtNum") as TextBox;
receiveGoods receiveGoods = new receiveGoods();
if (textBox.Text != "")
{
receiveGoods.number = new decimal?(Convert.ToDecimal(textBox.Text));
}
else
{
receiveGoods.number = new decimal?(0m);
}
receiveGoods.scode = dataRow["scode"].ToString();
receiveGoods.rnID = this.hdfSnId.Value;
receiveGoods.sgId = Guid.NewGuid().ToString();
try
{
receiveGoods.price = new decimal?(Convert.ToDecimal(dataRow["price"].ToString()));
}
catch
{
receiveGoods.price = new decimal?(0m);
}
receiveGoods.suppyCode = dataRow["suppyCode"].ToString();
this.receiveGood.Add(sqlTransaction, receiveGoods);
num2++;
}
}
}
this.sendnote.updateState(sqlTransaction, this.hdGuid.Value);
sqlTransaction.Commit();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("top.ui.alert('" + this.SetMsg() + "成功！');").Append(Environment.NewLine);
stringBuilder.Append("top.ui.tabSuccess({parentName: '_addReceiveNote'});");
base.RegisterScript(stringBuilder.ToString());
}
catch
{
sqlTransaction.Rollback();
base.RegisterScript("alert('系统提示：\\n\\n对不起" + this.SetMsg() + "失败！');");
}
return;
}
}
StringBuilder stringBuilder2 = new StringBuilder();
stringBuilder2.Append("top.ui.alert('收货项目对应的仓库被更改，请设置此项目对应的仓库');").Append(Environment.NewLine);
stringBuilder2.Append("top.ui.tabSuccess({parentName: '_addReceiveNote'});");
base.RegisterScript(stringBuilder2.ToString());
}
public int Add(SqlTransaction trans, receiveGoods receiveGoodsModel)
{
return(this.receiveGood.Add(trans, receiveGoodsModel));
}
