// GET api/values/5
public Response <t_bd_item_info> Get(string id)
{
StringBuilder sc = new StringBuilder();
Response <t_bd_item_info> rsp = new Response <t_bd_item_info>();
t_bd_item_info dd = null;
rsp.Code = 1;
try
{
string item_no = id.ToString();
RedisClient _redClient = null;
try
{
_redClient = new RedisClient(MU._redIp, int.Parse(MU._redPort));
if (_redClient != null)
{
sc.AppendLine("_redClient 不为空");
dd = _redClient.Get <t_bd_item_info>(item_no);
}
}
catch (Exception exRed)
{
sc.AppendLine("连接redis或Get时异常:" + exRed.Message);
}
if (dd == null)
{
sc.AppendLine("缓存中不存在");
rsp.Message = "缓存中不存在";
string conn = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (SqlConnection sconn = new SqlConnection(conn))
{
sconn.Open();
string sql = string.Format("select * from t_bd_item_info where rtrim(item_no)='{0}'", item_no);
SqlDataAdapter sda = new SqlDataAdapter(sql, sconn);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
sc.AppendLine("数据库中存在");
rsp.Message = "数据库中存在";
dd = RowToModel.DataRowTot_bd_item_info(dt.Rows[0]);
if (_redClient != null)
{
try
{
_redClient.Set <t_bd_item_info>(item_no, dd, DateTime.Now.AddMinutes(1));
}
catch (Exception exRedSet)
{
sc.AppendLine(" redis Get时异常:" + exRedSet.Message);
}
}
}
else
{
sc.AppendLine("数据库中不存在");
rsp.Message = "数据库中不存在";
}
}
}
else
{
sc.AppendLine("缓存中存在");
rsp.Message = "缓存中存在";
}
}
catch (Exception ex)
{
rsp.Code = 0;
rsp.Message = ex.Message;
sc.AppendLine("ex:" + ex.Message);
}
finally
{
GLog.WLog(sc.ToString());
}
rsp.Data = dd;
return(rsp);
}
public static t_bd_item_info DataRowTot_bd_item_info(DataRow row)
{
t_bd_item_info model = new t_bd_item_info();
model.item_subno = SIString.TryStr(row["item_subno"]);
model.item_name = SIString.TryStr(row["item_name"]);
model.item_subname = SIString.TryStr(row["item_subname"]);
model.unit_no = SIString.TryStr(row["unit_no"]);
model.item_size = SIString.TryStr(row["item_size"]);
model.combine_sta = SIString.TryStr(row["combine_sta"]);
model.status = SIString.TryStr(row["status"]);
model.display_flag = SIString.TryStr(row["display_flag"]);
model.po_cycle = SIString.TryInt(row["po_cycle"]);
model.so_cycle = SIString.TryInt(row["so_cycle"]);
model.automin_flag = SIString.TryStr(row["automin_flag"]);
model.en_dis = SIString.TryStr(row["en_dis"]);
model.change_price = SIString.TryStr(row["change_price"]);
model.purchase_tax = SIString.TryDec(row["purchase_tax"]);
model.sale_tax = SIString.TryDec(row["sale_tax"]);
model.purchase_spec = SIString.TryDec(row["purchase_spec"]);
model.shipment_spec = SIString.TryDec(row["shipment_spec"]);
model.item_supcust = SIString.TryStr(row["item_supcust"]);
model.main_supcust = SIString.TryStr(row["main_supcust"]);
model.item_stock = SIString.TryStr(row["item_stock"]);
model.abc = SIString.TryStr(row["abc"]);
model.branch_price = SIString.TryStr(row["branch_price"]);
model.item_rem = SIString.TryStr(row["item_rem"]);
model.vip_acc_flag = SIString.TryStr(row["vip_acc_flag"]);
model.vip_acc_num = SIString.TryDec(row["vip_acc_num"]);
model.dpfm_type = SIString.TryStr(row["dpfm_type"]);
model.return_rate = SIString.TryDec(row["return_rate"]);
model.update_date = SIString.TryStr(row["update_date"]);
model.pro_code1 = SIString.TryStr(row["pro_code1"]);
model.pro_code2 = SIString.TryStr(row["pro_code2"]);
model.pro_code3 = SIString.TryStr(row["pro_code3"]);
model.pro_code4 = SIString.TryStr(row["pro_code4"]);
model.pro_code5 = SIString.TryStr(row["pro_code5"]);
model.pro_code6 = SIString.TryStr(row["pro_code6"]);
model.item_picture = SIString.TryStr(row["item_picture"]);
model.sale_flag = SIString.TryStr(row["sale_flag"]);
model.valid_days = SIString.TryDec(row["valid_days"]);
model.memo = SIString.TryStr(row["memo"]);
model.item_com = SIString.TryStr(row["item_com"]);
model.product_area = SIString.TryStr(row["product_area"]);
model.measure_flag = SIString.TryStr(row["measure_flag"]);
model.item_sup_flag = SIString.TryStr(row["item_sup_flag"]);
model.sup_rate = SIString.TryDec(row["sup_rate"]);
model.picture_type = SIString.TryStr(row["picture_type"]);
model.base_price1 = SIString.TryDec(row["base_price1"]);
model.base_price2 = SIString.TryDec(row["base_price2"]);
model.base_price3 = SIString.TryDec(row["base_price3"]);
model.base_price4 = SIString.TryDec(row["base_price4"]);
model.base_price5 = SIString.TryDec(row["base_price5"]);
model.base_price6 = SIString.TryDec(row["base_price6"]);
model.base_price7 = SIString.TryDec(row["base_price7"]);
model.base_price8 = SIString.TryDec(row["base_price8"]);
model.new_oper_id = SIString.TryStr(row["new_oper_id"]);
model.modify_oper_id = SIString.TryStr(row["modify_oper_id"]);
model.en_gift = SIString.TryStr(row["en_gift"]);
model.promote_flag = SIString.TryStr(row["promote_flag"]);
return(model);
}
