public int Update(ResourceNewPriceModel resNewPriceModel)
{
int num = 0;
if ((resNewPriceModel.rCode != "") && (resNewPriceModel.rptCode != ""))
{
num = ResourceEdit.Update(resNewPriceModel);
}
return(num);
}
public static int Insert(ResourceNewPriceModel resNewPriceModel)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Sm_Resource_Price(");
builder.Append("rpid,rcode,rptcode,price)");
builder.Append(" values (");
builder.Append("@rpid,@rcode,@rptcode,@price)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@rpid", SqlDbType.NVarChar, 50), new SqlParameter("@rcode", SqlDbType.VarChar, 50), new SqlParameter("@rptcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@price", SqlDbType.Decimal, 9) };
commandParameters[0].Value = resNewPriceModel.rptId;
commandParameters[1].Value = resNewPriceModel.rCode;
commandParameters[2].Value = resNewPriceModel.rptCode;
commandParameters[3].Value = resNewPriceModel.Price;
return(int.Parse(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters).ToString()));
}
public static int Update(ResourceNewPriceModel resNewPriceModel)
{
StringBuilder builder = new StringBuilder();
builder.Append(" begin if(select count(*) from Sm_Resource_Price where rptcode=@rptcode and rcode=@rcode)>0 ");
builder.Append(" begin ");
builder.Append(" update Sm_Resource_Price set ");
builder.Append(" price=@price ");
builder.Append(" where rptcode=@rptcode and rcode=@rcode");
builder.Append(" end ");
builder.Append(" else ");
builder.Append(" begin ");
builder.Append(" insert into Sm_Resource_Price(rpid,rcode,rptcode,price) ");
builder.Append(" values(@rpid,@rcode,@rptcode,@price) ");
builder.Append(" end ");
builder.Append(" end ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@rcode", SqlDbType.NVarChar, 0x80), new SqlParameter("@rptcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@price", SqlDbType.Decimal), new SqlParameter("@rpid", SqlDbType.NVarChar, 0x80) };
commandParameters[0].Value = resNewPriceModel.rCode;
commandParameters[1].Value = resNewPriceModel.rptCode;
commandParameters[2].Value = resNewPriceModel.Price;
commandParameters[3].Value = resNewPriceModel.rptId;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
