public int Update(SqlTransaction trans, BackStockModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Sm_back_Stock set ");
builder.Append("rcode=@rcode,");
builder.Append("scode=@scode,");
builder.Append("number=@number,");
builder.Append("sprice=@sprice,");
builder.Append("corp=@corp,");
builder.Append("intype=@intype,");
builder.Append("linkcode=@linkcode");
builder.Append(" where rsid=@rsid ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@rsid", SqlDbType.NVarChar, 50), new SqlParameter("@rcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@scode", SqlDbType.VarChar, 50), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@sprice", SqlDbType.Decimal, 9), new SqlParameter("@corp", SqlDbType.NVarChar, 0x40), new SqlParameter("@intype", SqlDbType.NVarChar, 0x40), new SqlParameter("@linkcode", SqlDbType.NVarChar, 0x40) };
commandParameters[0].Value = model.rsid;
commandParameters[1].Value = model.rcode;
commandParameters[2].Value = model.scode;
commandParameters[3].Value = model.number;
commandParameters[4].Value = model.sprice;
commandParameters[5].Value = model.corp;
commandParameters[6].Value = model.intype;
commandParameters[7].Value = model.linkcode;
if (trans == null)
{
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
public BackStockModel GetModel(string rsid)
{
StringBuilder builder = new StringBuilder();
builder.Append("select rsid,rcode,scode,number,sprice,corp,intype,linkcode from Sm_back_Stock ");
builder.Append(" where rsid=@rsid ");
BackStockModel model = null;
using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@rsid", rsid) }))
{
if (reader.Read())
{
model = this.ReaderBind(reader);
}
}
return(model);
}
public BackStockModel ReaderBind(IDataReader dataReader)
{
BackStockModel model = new BackStockModel {
rsid = dataReader["rsid"].ToString(),
rcode = dataReader["rcode"].ToString(),
scode = dataReader["scode"].ToString()
};
object obj2 = dataReader["number"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.number = (decimal)obj2;
}
obj2 = dataReader["sprice"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.sprice = (decimal)obj2;
}
model.corp = dataReader["corp"].ToString();
model.intype = dataReader["intype"].ToString();
model.linkcode = dataReader["linkcode"].ToString();
return(model);
}
public int Add(SqlTransaction trans, BackStockModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Sm_back_Stock(");
builder.Append("rsid,rcode,scode,number,sprice,corp,intype,linkcode,TaskId)");
builder.Append(" values (");
builder.Append("@rsid,@rcode,@scode,@number,@sprice,@corp,@intype,@linkcode,@TaskId)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@rsid", SqlDbType.NVarChar, 50), new SqlParameter("@rcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@scode", SqlDbType.VarChar, 50), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@sprice", SqlDbType.Decimal, 9), new SqlParameter("@corp", SqlDbType.NVarChar, 0x40), new SqlParameter("@intype", SqlDbType.NVarChar, 0x40), new SqlParameter("@linkcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@TaskId", SqlDbType.NVarChar, 0x40) };
commandParameters[0].Value = model.rsid;
commandParameters[1].Value = model.rcode;
commandParameters[2].Value = model.scode;
commandParameters[3].Value = model.number;
commandParameters[4].Value = model.sprice;
commandParameters[5].Value = model.corp;
commandParameters[6].Value = model.intype;
commandParameters[7].Value = model.linkcode;
commandParameters[8].Value = model.taskId;
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, BackStockModel model)
{
return(this.backStock.Update(trans, model));
}
public int Add(SqlTransaction trans, BackStockModel model)
{
return(this.backStock.Add(trans, model));
}
private void save(string type)
{
this.UpdateDataSource();
using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString))
{
sqlConnection.Open();
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
try
{
RefundingModel refundingModel = new RefundingModel();
refundingModel.annx = "";
refundingModel.explain = this.txtExplain.Text;
refundingModel.flowstate = Convert.ToInt32(this.hdflowstate.Value);
refundingModel.intime = Convert.ToDateTime(this.txtInTime.Text);
refundingModel.person = this.txtPeople.Value;
refundingModel.rcode = this.txtPPCode.Text;
refundingModel.rid = this.hdGuid.Value;
refundingModel.procode = this.hdnProjectCode.Value;
refundingModel.isin = false;
refundingModel.tcode = this.hfldTrea.Value;
int num;
if (base.Request.QueryString["id"] != null)
{
num = this.refundingBll.Update(sqlTransaction, refundingModel);
}
else
{
num = this.refundingBll.Add(sqlTransaction, refundingModel);
}
if (num != 0)
{
this.backStockBll.DeleteByWhere(sqlTransaction, " where rcode='" + refundingModel.rcode + "'");
DataTable dataTable = (DataTable)this.ViewState["DataTable"];
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
BackStockModel backStockModel = new BackStockModel();
backStockModel.corp = dataRow["CorpId"].ToString();
backStockModel.intype = "";
backStockModel.linkcode = dataRow["orcode"].ToString();
backStockModel.number = Convert.ToDecimal(dataRow["tnumber"]);
backStockModel.rcode = this.txtPPCode.Text;
backStockModel.rsid = Guid.NewGuid().ToString();
backStockModel.scode = dataRow["scode"].ToString();
backStockModel.sprice = Convert.ToDecimal(dataRow["sprice"]);
backStockModel.taskId = dataRow["TaskId"].ToString();
this.backStockBll.Add(sqlTransaction, backStockModel);
}
}
}
sqlTransaction.Commit();
StringBuilder stringBuilder = new StringBuilder();
if (type == "pc")
{
stringBuilder.Append("top.ui.show('" + this.SetMsg() + "成功！');").Append(Environment.NewLine);
stringBuilder.Append("winclose('AddRefunding','RefundingList.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('系统提示：\\n\\n添加失败！');");
}
}
}
}
