public void GetPrintStyleDefault(WebHelper w, Dictionary <string, object> kv)
{
sys_t_print_style_default style = w.GetObject <sys_t_print_style_default>("style");
DataTable tb = bll.GetPrintStyleDefault(style);
w.Write(tb);
}
public void DelDefault(sys_t_print_style_default style)
{
JsonRequest r = new JsonRequest();
r.Write("style", style);
r.request("/print?t=DelDefault");
if (!r.ReadSuccess())
{
throw new Exception(r.ReadMessage());
}
}
public void DelDefault(sys_t_print_style_default style)
{
string sql = "select * from sys_t_print_style_default where report_id='" + style.report_id +
"' and oper_id='" + style.oper_id + "' ";
var print_style = d.ExecuteToModel <sys_t_print_style_default>(sql, null);
if (print_style == null)
{
throw new Exception("不存在样式");
}
d.ExecuteScalar("delete from sys_t_print_style_default where style_id='" + style.style_id + "' and oper_id='" + style.oper_id + "'", null);
}
public void UpdateDefault(sys_t_print_style_default style)
{
string sql = "select * from sys_t_print_style_default where report_id='" + style.report_id +
"' and oper_id='" + style.oper_id + "' ";
var print_style = d.ExecuteToModel <sys_t_print_style_default>(sql, null);
if (print_style == null)
{
throw new Exception("不存在样式");
}
d.Update(style, "oper_id,report_id");
}
public void AddDefault(sys_t_print_style_default style)
{
string sql = "select * from sys_t_print_style_default where report_id='" + style.report_id +
"' and oper_id='" + style.oper_id + "' ";
var print_style = d.ExecuteToModel <sys_t_print_style_default>(sql, null);
if (print_style != null)
{
UpdateDefault(style);
}
else
{
d.Insert(style);
}
}
public DataTable GetPrintStyleDefault(sys_t_print_style_default style)
{
JsonRequest r = new JsonRequest();
r.Write("style", style);
r.request("/print?t=GetPrintStyleDefault");
if (!r.ReadSuccess())
{
throw new Exception(r.ReadMessage());
}
DataTable tb = r.GetDataTable();
return(tb);
}
public Dictionary <string, sys_t_print_style_default> GetDefaultDic(sys_t_print_style_default style)
{
JsonRequest r = new JsonRequest();
r.Write("style", style);
r.request("/print?t=GetPrintStyleDefault");
if (!r.ReadSuccess())
{
throw new Exception(r.ReadMessage());
}
Dictionary <string, sys_t_print_style_default> style_dic = r.GetDicOfTable <string, sys_t_print_style_default>("report_id");
return(style_dic);
}
public DataTable GetPrintStyleDefault(sys_t_print_style_default style)
{
string sql = "select * from sys_t_print_style_default where 1=1 ";
if (!string.IsNullOrEmpty(style.report_id))
{
sql += " and report_id='" + style.report_id + "' ";
}
if (!string.IsNullOrEmpty(style.oper_id))
{
sql += " and oper_id='" + style.oper_id + "' ";
}
DataTable tb = d.ExecuteToTable(sql, null);
return(tb);
}
public void DelDefault(WebHelper w, Dictionary <string, object> kv)
{
sys_t_print_style_default style = w.GetObject <sys_t_print_style_default>("style");
bll.DelDefault(style);
}
