/// <summary>
/// get all productsaleprice
/// <summary>
/// <param name=productid>productid</param>
/// <param name=out emsg>return error message</param>
///<returns>details of all productsaleprice</returns>
public BindingCollection <modProductSalePrice> GetProductSalePrice(string productid, out string emsg)
{
try
{
BindingCollection <modProductSalePrice> modellist = new BindingCollection <modProductSalePrice>();
//Execute a query to read the categories
string sql = string.Format("select b.product_id,a.cust_level,isnull(b.price, 0) price from customer_level a left join "
+ "(select * from product_sale_price where product_id='{0}') b on a.cust_level=b.cust_level order by b.product_id,a.cust_level", productid);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modProductSalePrice model = new modProductSalePrice();
model.ProductId = productid;
model.CustLevel = dalUtility.ConvertToString(rdr["cust_level"]);
model.Price = dalUtility.ConvertToDecimal(rdr["price"]);
modellist.Add(model);
}
}
emsg = null;
return(modellist);
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
/// <summary>
/// get table record
/// <summary>
/// <param name=productid>productid</param>
/// <param name=custlevel>custlevel</param>
/// <param name=out emsg>return error message</param>
///<returns>get a record detail of productsaleprice</returns>
public modProductSalePrice GetItem(string productid, string custlevel, out string emsg)
{
try
{
//Execute a query to read the categories
string sql = string.Format("select product_id,cust_level,price,update_user,update_time from product_sale_price where product_id='{0}' and cust_level='{1}' order by product_id,cust_level", productid, custlevel);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
if (rdr.Read())
{
modProductSalePrice model = new modProductSalePrice();
model.ProductId = dalUtility.ConvertToString(rdr["product_id"]);
model.CustLevel = dalUtility.ConvertToString(rdr["cust_level"]);
model.Price = dalUtility.ConvertToDecimal(rdr["price"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
emsg = null;
return(model);
}
else
{
emsg = "Error on read data";
return(null);
}
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
/// <summary>
/// get all productsaleprice
/// <summary>
/// <param name=productid>productid</param>
/// <param name=out emsg>return error message</param>
///<returns>details of all productsaleprice</returns>
public BindingCollection <modProductSalePrice> GetIList(string productid, out string emsg)
{
try
{
BindingCollection <modProductSalePrice> modellist = new BindingCollection <modProductSalePrice>();
//Execute a query to read the categories
string sql = string.Format("select product_id,cust_level,price,update_user,update_time from product_sale_price where product_id='{0}' order by product_id,cust_level", productid);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modProductSalePrice model = new modProductSalePrice();
model.ProductId = dalUtility.ConvertToString(rdr["product_id"]);
model.CustLevel = dalUtility.ConvertToString(rdr["cust_level"]);
model.Price = dalUtility.ConvertToDecimal(rdr["price"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
modellist.Add(model);
}
}
emsg = null;
return(modellist);
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
/// <summary>
/// update a productsaleprice
/// <summary>
/// <param name=productid>productid</param>
/// <param name=custlevel>custlevel</param>
/// <param name=mod>model object of productsaleprice</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Update(string productid, string custlevel, modProductSalePrice mod, out string emsg)
{
try
{
string sql = string.Format("update product_sale_price set price='{0}',update_user='******',update_time=getdate() where product_id='{2}' and cust_level='{3}'", mod.Price, mod.UpdateUser, productid, custlevel);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = null;
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(false);
}
}
