public int Update(ProductPriceRangeInfo oParam)
{
string sql = @"Update product_price_range
set RangeID=@RangeID,RangeName=@RangeName,RangeFrom=@RangeFrom,RangeTo=@RangeTo
where SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4);
SqlParameter paramRangeID = new SqlParameter("@RangeID", SqlDbType.Int,4);
SqlParameter paramRangeName = new SqlParameter("@RangeName", SqlDbType.NVarChar,100);
SqlParameter paramRangeFrom = new SqlParameter("@RangeFrom", SqlDbType.Int,4);
SqlParameter paramRangeTo = new SqlParameter("@RangeTo", SqlDbType.Int,4);
if(oParam.SysNo != AppConst.IntNull)
paramSysNo.Value = oParam.SysNo;
else
paramSysNo.Value = System.DBNull.Value;
if(oParam.RangeID != AppConst.IntNull)
paramRangeID.Value = oParam.RangeID;
else
paramRangeID.Value = System.DBNull.Value;
if(oParam.RangeName != AppConst.StringNull)
paramRangeName.Value = oParam.RangeName;
else
paramRangeName.Value = System.DBNull.Value;
if(oParam.RangeFrom != AppConst.IntNull)
paramRangeFrom.Value = oParam.RangeFrom;
else
paramRangeFrom.Value = System.DBNull.Value;
if(oParam.RangeTo != AppConst.IntNull)
paramRangeTo.Value = oParam.RangeTo;
else
paramRangeTo.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramRangeID);
cmd.Parameters.Add(paramRangeName);
cmd.Parameters.Add(paramRangeFrom);
cmd.Parameters.Add(paramRangeTo);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Insert(ProductPriceRangeInfo oParam)
{
string sql = @"INSERT INTO product_price_range
(
RangeID,RangeName,RangeFrom,RangeTo
)
VALUES (
@RangeID,@RangeName,@RangeFrom,@RangeTo
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramRangeID = new SqlParameter("@RangeID", SqlDbType.Int,4);
SqlParameter paramRangeName = new SqlParameter("@RangeName", SqlDbType.NVarChar,100);
SqlParameter paramRangeFrom = new SqlParameter("@RangeFrom", SqlDbType.Int,4);
SqlParameter paramRangeTo = new SqlParameter("@RangeTo", SqlDbType.Int,4);
if(oParam.RangeID != AppConst.IntNull)
paramRangeID.Value = oParam.RangeID;
else
paramRangeID.Value = System.DBNull.Value;
if(oParam.RangeName != AppConst.StringNull)
paramRangeName.Value = oParam.RangeName;
else
paramRangeName.Value = System.DBNull.Value;
if(oParam.RangeFrom != AppConst.IntNull)
paramRangeFrom.Value = oParam.RangeFrom;
else
paramRangeFrom.Value = System.DBNull.Value;
if(oParam.RangeTo != AppConst.IntNull)
paramRangeTo.Value = oParam.RangeTo;
else
paramRangeTo.Value = System.DBNull.Value;
cmd.Parameters.Add(paramRangeID);
cmd.Parameters.Add(paramRangeName);
cmd.Parameters.Add(paramRangeFrom);
cmd.Parameters.Add(paramRangeTo);
return SqlHelper.ExecuteNonQuery(cmd);
}
public ProductPriceRangeInfo LoadPriceRange(int sysno)
{
string sql = "select sysno,rangeid,rangename,rangefrom,rangeto from product_price_range where sysno=" + sysno.ToString();
DataSet ds = SqlHelper.ExecuteDataSet(sql);
ProductPriceRangeInfo ppr = new ProductPriceRangeInfo();
if (Util.HasMoreRow(ds))
{
mapPriceRange(ppr, ds.Tables[0].Rows[0]);
}
else
{
ppr = null;
}
return ppr;
}
private void mapPriceRange(ProductPriceRangeInfo oParam, DataRow dr)
{
oParam.SysNo = int.Parse(dr["SysNo"].ToString().Trim());
oParam.RangeID = int.Parse(dr["RangeID"].ToString().Trim());
oParam.RangeName = dr["RangeName"].ToString().Trim();
oParam.RangeFrom = int.Parse(dr["RangeTo"].ToString().Trim());
oParam.RangeTo = int.Parse(dr["RangeTo"].ToString().Trim());
}
/// <summary>
/// ȡ�����м۸�������Ϣ
/// </summary>
/// <returns></returns>
public SortedList GetProductPriceRanges()
{
string sql = "select sysno,rangeid,rangename,rangefrom,rangeto from product_price_range order by rangeid";
DataSet ds = SqlHelper.ExecuteDataSet(sql);
SortedList st = new SortedList();
if (!Util.HasMoreRow(ds))
return st;
foreach (DataRow dr in ds.Tables[0].Rows)
{
ProductPriceRangeInfo ppr = new ProductPriceRangeInfo();
mapPriceRange(ppr, dr);
st.Add(ppr, null);
}
return st;
}