public void GetAll(WebHelper w, Dictionary <string, object> kv)
{
sys_t_print_style style = w.GetObject <sys_t_print_style>("style");
DataTable tb = bll.GetAll(style);
w.Write(tb);
}
public void Add(sys_t_print_style style)
{
var num = Conv.ToInt(d.ExecuteScalar(@"select count(1) +1
from sys_t_print_style
where report_id='" + style.report_id + "' and style_data!='_" + style.report_id + "_00'", null));
style.style_data = style.report_id + "_" + num.ToString("00");
d.Insert(style);
}
public void Del(sys_t_print_style style)
{
JsonRequest r = new JsonRequest();
r.Write("style", style);
r.request("/print?t=Del");
if (!r.ReadSuccess())
{
throw new Exception(r.ReadMessage());
}
}
public void Del(sys_t_print_style style)
{
string sql = "select * from sys_t_print_style where style_id='" + style.style_id + "'";
var print_style = d.ExecuteToModel <sys_t_print_style>(sql, null);
if (print_style == null)
{
throw new Exception("不存在样式");
}
if (print_style.update_time > style.update_time)
{
throw new Exception("样式已被修改");
}
d.ExecuteScalar("delete from sys_t_print_style where style_id='" + style.style_id + "'", null);
}
public Dictionary <string, sys_t_print_style> GetStyleDic(sys_t_print_style style)
{
JsonRequest r = new JsonRequest();
r.Write("style", style);
r.request("/print?t=GetAll");
if (!r.ReadSuccess())
{
throw new Exception(r.ReadMessage());
}
Dictionary <string, sys_t_print_style> style_dic = r.GetDicOfTable <string, sys_t_print_style>("style_id");
return(style_dic);
}
public DataTable GetAll(sys_t_print_style style)
{
JsonRequest r = new JsonRequest();
r.Write("style", style);
r.request("/print?t=GetAll");
if (!r.ReadSuccess())
{
throw new Exception(r.ReadMessage());
}
DataTable tb = r.GetDataTable();
return(tb);
}
public void Update(sys_t_print_style style)
{
string sql = "select * from sys_t_print_style where style_id='" + style.style_id + "'";
var print_style = d.ExecuteToModel <sys_t_print_style>(sql, null);
if (print_style == null)
{
throw new Exception("不存在样式");
}
if (print_style.update_time > style.update_time)
{
throw new Exception("样式已被修改");
}
style.update_time = DateTime.Now;
d.Update(style, "style_id");
}
private void btnOk_Click(object sender, EventArgs e)
{
try
{
IBLL.IPrint bll = new BLL.PrintBLL();
print_style.is_share = this.cbShare.Checked ? "1" : "0";
print_style.is_base = this.cbIsBase.Checked ? "1" : "0";
print_style.oper_id = Program.oper.oper_id;
print_style.style_name = this.txtStyleName.Text;
print_style.update_time = DateTime.Now;
if (string.IsNullOrEmpty(print_style.style_id))
{
print_style.style_id = Guid.NewGuid().ToString();
print_style.create_time = DateTime.Now;
bll.Add(print_style);
}
else
{
bll.Update(print_style);
}
sys_t_print_style style = PrintHelper.myStyle[print_style.style_id];
global::PrintHelper.BLL.PrintD p = new global::PrintHelper.BLL.PrintD();
global::PrintHelper.IBLL.IPrint print = p;
p.SaveStyle += new global::PrintHelper.BLL.PrintD.SaveStyleHandler((style1, xml) =>
{
PrintForm.PrintHelper.UpdateStyle(style1, xml);
});
print.Print(style.style_data,
PrintForm.PrintHelper.GetStyle(style.style_data),
PrintHelper.tb_main,
PrintHelper.tb_detail);
this.Close();
}
catch (Exception exception)
{
MsgForm.ShowFrom(exception);
}
}
public DataTable GetAll(sys_t_print_style style)
{
string sql = @"select p.*,
case when p.is_base='1' then '系统'
else (p.oper_id+'/'+o.oper_name)
end 用户
from sys_t_print_style p
left join sa_t_operator_i o on o.oper_id=p.oper_id
where 1=1 ";
if (!string.IsNullOrEmpty(style.report_id))
{
sql += " and report_id='" + style.report_id + "' ";
}
if (!string.IsNullOrEmpty(style.oper_id))
{
sql += " and (p.oper_id='" + style.oper_id + "' or p.is_share='1' or p.is_base='1')";
}
DataTable tb = d.ExecuteToTable(sql, null);
return(tb);
}
public void Del(WebHelper w, Dictionary <string, object> kv)
{
sys_t_print_style style = w.GetObject <sys_t_print_style>("style");
bll.Del(style);
}
