void IBLL.IPayment.Add(Model.bi_t_payment_info item)
{
string sql = "select * from bi_t_payment_info where pay_way='" + item.pay_way + "'";
DB.IDB db = new DB.DBByAutoClose(Appsetting.conn);
var tb = db.ExecuteToTable(sql, null);
if (tb.Rows.Count != 0)
{
throw new Exception("已经存在付款编码" + item.pay_way);
}
db.Insert(item);
}
public void change(WebHelper w, Dictionary <string, object> kv)
{
Model.bi_t_payment_info item = w.GetObject <Model.bi_t_payment_info>();
bll.Change(item);
}
void IServiceBase.Request(string t, string pars, out string res)
{
try
{
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars);
var kv = r.ToDictionary();
IBLL.IPayment bll = new BLL.Payment();
if (t == "get_list")
{
var tb = bll.GetList( );
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("data", tb);
res = w.ToString();
}
else if (t == "get_item")
{
string pay_way = r.Read("pay_way");
var tb = bll.GetItem(pay_way);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("data", tb);
res = w.ToString();
}
else if (t == "add")
{
Model.bi_t_payment_info item = new Model.bi_t_payment_info();
item.pay_way = r.Read("pay_way");
item.pay_name = r.Read("pay_name");
item.pay_flag = r.Read("pay_flag");
item.display = r.Read("display");
item.visa_id = r.Read("visa_id");
bll.Add(item);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else if (t == "change")
{
Model.bi_t_payment_info item = new Model.bi_t_payment_info();
item.pay_way = r.Read("pay_way");
item.pay_name = r.Read("pay_name");
item.pay_flag = r.Read("pay_flag");
item.display = r.Read("display");
item.visa_id = r.Read("visa_id");
bll.Change(item);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else if (t == "delete")
{
string pay_way = r.Read("pay_way");
bll.Delete(pay_way);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else
{
throw new Exception("未找到方法" + t);
}
}
catch (Exception ex)
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "-1");
w.Append("errMsg", ex.Message);
res = w.ToString();
}
}
void IBLL.IPayment.Change(Model.bi_t_payment_info item)
{
DB.IDB db = new DB.DBByAutoClose(Appsetting.conn);
db.Update(item, "pay_way");
}
