public int Add(SqlTransaction trans, StorageStockModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Sm_Storage_Stock(");
builder.Append("ssid,scode,stcode,number,sprice,corp,intype,linkcode,checkCondition)");
builder.Append(" values (");
builder.Append("@ssid,@scode,@stcode,@number,@sprice,@corp,@intype,@linkcode,@checkCondition)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ssid", SqlDbType.NVarChar, 50), new SqlParameter("@scode", SqlDbType.VarChar, 50), new SqlParameter("@stcode", SqlDbType.NVarChar, 0x40), 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("@checkCondition", SqlDbType.VarChar, 50) };
commandParameters[0].Value = model.ssid;
commandParameters[1].Value = model.scode;
commandParameters[2].Value = model.stcode;
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 (model.CheckCondition != null)
{
commandParameters[8].Value = model.CheckCondition;
}
else
{
commandParameters[8].Value = "";
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
public int Update(SqlTransaction trans, StorageStockModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Sm_Storage_Stock set ");
builder.Append("scode=@scode,");
builder.Append("stcode=@stcode,");
builder.Append("number=@number,");
builder.Append("sprice=@sprice,");
builder.Append("corp=@corp,");
builder.Append("intype=@intype,");
builder.Append("linkcode=@linkcode");
builder.Append("checkCondition=@checkCondition");
builder.Append(" where ssid=@ssid ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ssid", SqlDbType.NVarChar, 50), new SqlParameter("@scode", SqlDbType.VarChar, 50), new SqlParameter("@stcode", SqlDbType.NVarChar, 0x40), 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("@checkCondition", SqlDbType.NVarChar, 50) };
commandParameters[0].Value = model.ssid;
commandParameters[1].Value = model.scode;
commandParameters[2].Value = model.stcode;
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.CheckCondition;
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
private void AddStorageStock(SqlTransaction trans)
{
if (this.ViewState["DataTable"] is DataTable)
{
DataTable table = this.ViewState["DataTable"] as DataTable;
List <StorageStockModel> lstModel = new List <StorageStockModel>();
foreach (DataRow row in table.Rows)
{
StorageStockModel item = new StorageStockModel {
ssid = Guid.NewGuid().ToString(),
scode = row["ResourceCode"].ToString(),
stcode = this.Scode,
number = Convert.ToDecimal(row["number"].ToString()),
sprice = Convert.ToDecimal(row["price"].ToString()),
corp = row["suppyCode"].ToString(),
intype = string.Empty,
linkcode = this.ReceiveNoteModel.rnId
};
lstModel.Add(item);
}
this.storageStock.Add(trans, lstModel);
}
}
public int Add(SqlTransaction trans, StorageStockModel model)
{
return(this.dal.Add(null, model));
}
public int Update(SqlTransaction trans, StorageStockModel model)
{
return(this.dal.Update(trans, model));
}
public int Update(StorageStockModel model)
{
return(this.dal.Update(null, model));
}
public int Add(StorageStockModel model)
{
return(this.dal.Add(null, model));
}
