/// <summary>
/// 获取产品信息
/// </summary>
private void Select()
{
try
{
string method = context.Request.Params["method"].ToString();
if (method == "model")
{
string TID = context.Request.Params["TID"].ToString();
string ProductCode = context.Request.Params["ProductCode"].ToString();
string sql = " 1=1 ";
if (!string.IsNullOrEmpty(TID))
{
sql += string.Format(" AND TID = {0}", TID);
}
if (!string.IsNullOrEmpty(ProductCode))
{
sql += string.Format(" AND ProductCode = '{0}'", ProductCode);
}
//CLog.WriteErrLog(sql);
ProductInfoMDL model = DataDAL.GetModel(sql);
if (model != null)
{
ReturnData.Code = "1";
ReturnData.Msg = "OK";
ReturnData.Data = model;
}
}
else if (method == "search")
{
string sql = " 1=1 ";
string ProductType = context.Request.Params["ProductType"].ToString();
//string ProductCode = context.Request.Params["ProductCode"].ToString();
//CLog.WriteErrLog(ProductType);
//if (!string.IsNullOrEmpty(ProductCode))
//{
// sql += string.Format(" AND ProductCode = '{0}'", ProductCode);
//}
if (!string.IsNullOrEmpty(ProductType))
{
sql += string.Format(" AND ProductType = '{0}'", ProductType);
}
sql += " ORDER BY ProductCode ASC";
//CLog.WriteErrLog(sql);
DataSet set = DataDAL.GetList(sql);
if (set != null && set.Tables.Count > 0)
{
DataTable table = set.Tables[0];
if (table != null && table.Rows.Count > 0)
{
object obj = TableHelper.TableToObj(table);
ReturnData.Code = "1";
ReturnData.Msg = "OK";
ReturnData.Data = obj;
}
}
}
}
catch (Exception ex)
{
CLog.WriteErrLog(ex.Message);
}
}
