protected void btnSaveWX_Click(object sender, System.EventArgs e)
{
this.UpdateDataSource();
using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString))
{
sqlConnection.Open();
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
try
{
SmWastageModel smWastageModel = new SmWastageModel();
smWastageModel.Explain = this.txtExplain.Text;
smWastageModel.Flowstate = System.Convert.ToInt32(this.hdflowstate.Value);
smWastageModel.InputDate = System.Convert.ToDateTime(this.txtInTime.Text);
smWastageModel.Isout = false;
smWastageModel.Code = this.txtWastageCode.Text;
smWastageModel.Id = this.hdGuid.Value;
smWastageModel.InputPerson = this.txtPeople.Value;
smWastageModel.Treasurycode = this.hfldTrea.Value;
int num;
if (this.action == "update")
{
num = this.smWastageBll.Update(sqlTransaction, smWastageModel);
}
else
{
num = this.smWastageBll.Add(sqlTransaction, smWastageModel);
}
if (num != 0)
{
this.smWastageStockBll.DeleteByWhere(sqlTransaction, " where wastageCode='" + smWastageModel.Code + "' ");
DataTable dataTable = (DataTable)this.ViewState["DataTable"];
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
SmWastageStockModel smWastageStockModel = new SmWastageStockModel();
smWastageStockModel.Corp = dataRow["CorpId"].ToString();
smWastageStockModel.Number = System.Convert.ToDecimal(dataRow["number"]);
smWastageStockModel.WastageCode = this.txtWastageCode.Text;
smWastageStockModel.Id = System.Guid.NewGuid().ToString();
smWastageStockModel.ResourceCode = dataRow["ResourceCode"].ToString();
smWastageStockModel.Sprice = System.Convert.ToDecimal(dataRow["sprice"]);
this.smWastageStockBll.Add(sqlTransaction, smWastageStockModel);
}
}
}
sqlTransaction.Commit();
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.Append("alert('" + this.SetMsg() + "成功！');").Append(System.Environment.NewLine);
//stringBuilder.Append("winclose('AddReserve','SmWastageList.aspx',true)");
stringBuilder.Append("parent.location.reload();");
base.RegisterScript(stringBuilder.ToString());
}
catch (System.Exception)
{
sqlTransaction.Rollback();
base.RegisterScript("alert('系统提示：\\n\\n对不起" + this.SetMsg() + "失败！');");
}
}
}
public SmWastageStockModel GetModel(string wastageStockId)
{
StringBuilder builder = new StringBuilder();
builder.Append("select WastageStockId,WastageCode,ResourceCode,Sprice,Number,Corp from Sm_Wastage_Stock ");
builder.Append(" where WastageStockId=@WastageStockId ");
SmWastageStockModel model = null;
using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@WastageStockId", wastageStockId) }))
{
if (reader.Read())
{
model = this.ReaderBind(reader);
}
}
return(model);
}
public SmWastageStockModel ReaderBind(IDataReader dataReader)
{
SmWastageStockModel model = new SmWastageStockModel {
Id = dataReader["WastageStockId"].ToString(),
WastageCode = dataReader["WastageCode"].ToString(),
ResourceCode = dataReader["ResourceCode"].ToString()
};
object obj2 = dataReader["Sprice"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.Sprice = (decimal)obj2;
}
obj2 = dataReader["Number"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.Number = (decimal)obj2;
}
model.Corp = dataReader["Corp"].ToString();
return(model);
}
public int Add(SqlTransaction trans, SmWastageStockModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Sm_Wastage_Stock(");
builder.Append("WastageStockId,WastageCode,ResourceCode,Sprice,Number,Corp)");
builder.Append(" values (");
builder.Append("@WastageStockId,@WastageCode,@ResourceCode,@Sprice,@Number,@Corp)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@WastageStockId", SqlDbType.NVarChar, 50), new SqlParameter("@WastageCode", SqlDbType.NVarChar, 0x40), new SqlParameter("@ResourceCode", SqlDbType.VarChar, 50), new SqlParameter("@Sprice", SqlDbType.Decimal, 9), new SqlParameter("@Number", SqlDbType.Decimal, 9), new SqlParameter("@Corp", SqlDbType.NVarChar, 0x40) };
commandParameters[0].Value = model.Id;
commandParameters[1].Value = model.WastageCode;
commandParameters[2].Value = model.ResourceCode;
commandParameters[3].Value = model.Sprice;
commandParameters[4].Value = model.Number;
commandParameters[5].Value = model.Corp;
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, SmWastageStockModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("UPDATE Sm_Wastage_Stock SET ");
builder.Append("WastageCode=@WastageCode,");
builder.Append("ResourceCode=@ResourceCode,");
builder.Append("Sprice=@Sprice,");
builder.Append("Number=@Number,");
builder.Append("Corp=@Corp");
builder.Append(" where WastageStockId=@WastageStockId ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@WastageStockId", SqlDbType.NVarChar, 50), new SqlParameter("@WastageCode", SqlDbType.NVarChar, 0x40), new SqlParameter("@ResourceCode", SqlDbType.VarChar, 50), new SqlParameter("@Sprice", SqlDbType.Decimal, 9), new SqlParameter("@Number", SqlDbType.Decimal, 9), new SqlParameter("@Corp", SqlDbType.NVarChar, 0x40) };
commandParameters[0].Value = model.Id;
commandParameters[1].Value = model.WastageCode;
commandParameters[2].Value = model.ResourceCode;
commandParameters[3].Value = model.Sprice;
commandParameters[4].Value = model.Number;
commandParameters[5].Value = model.Corp;
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, SmWastageStockModel model)
{
return(this.smWastageStock.Update(trans, model));
}
public int Add(SqlTransaction trans, SmWastageStockModel model)
{
return(this.smWastageStock.Add(trans, model));
}
