public static int Update(AllocationStockModel stockModel)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Sm_Allocation_Stock set ");
builder.Append("number=@number where asid=@asid ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@number", SqlDbType.Int), new SqlParameter("@asid", SqlDbType.NVarChar, 50) };
commandParameters[0].Value = stockModel.Number;
commandParameters[1].Value = stockModel.Asid;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
public static int Insert(SqlTransaction trans, AllocationStockModel stockModel)
{
StringBuilder builder = new StringBuilder();
builder.Append(" insert into Sm_Allocation_Stock(asid,scode,acode,sprice,corp,number) ");
builder.Append(" values(newid(),@scode,@acode,@sprice,@corp,@number) ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@acode", SqlDbType.NVarChar, 0x40), new SqlParameter("@scode", SqlDbType.VarChar, 50), new SqlParameter("@sprice", SqlDbType.Decimal), new SqlParameter("@corp", SqlDbType.NVarChar, 0x40), new SqlParameter("@number", SqlDbType.Decimal) };
commandParameters[0].Value = stockModel.ACode;
commandParameters[1].Value = stockModel.SCode;
commandParameters[2].Value = stockModel.Sprice;
commandParameters[3].Value = stockModel.Corp;
commandParameters[4].Value = stockModel.Number;
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}