public JsonResult InitRptTemp(string emcode, string rtcode)
{
JsonData d = new JsonData();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_RptTemp sa = new Sys_RptTemp();
if (rtcode != "")
{
sa = stb.Query(" and rtcode='" + rtcode + "'");
}
else
{
Sys_EventMenu sem = semb.Query(" and emcode='" + emcode + "'");
if (sem != null)
{
sa.emcode = sem.emcode;
sa.emname = sem.emname;
}
sa.rtcode = stb.CreateCode().ToString().PadLeft(4, '0');
}
d.d = js.Serialize(sa);
}
else
{
d.d = iv.badstr;
}
return(Json(d));
}
public JsonResult SaveRptTemp(string dbcol, string dbtname, string dbwhere, string emcode, string emname, string rtcode, string thtext, string rtid, string rtname)
{
JsonData d = new JsonData();
Sys_RptTemp sa = new Sys_RptTemp();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
sa.dbcol = dbcol;
sa.dbtname = dbtname;
sa.dbwhere = dbwhere;
sa.emcode = emcode;
sa.emname = emname;
sa.rtcode = rtcode;
sa.rtname = rtname;
sa.thtext = thtext;
sa.cdate = DateTime.Now.ToString();
sa.maker = iv.u.ename;
if (rtid == "0")
{
if (stb.Add(sa) > 0)
{
d.d = "S";
}
else
{
d.d = "F";
}
}
else
{
if (stb.Update(sa))
{
d.d = "S";
}
else
{
d.d = "F";
}
}
}
else
{
d.d = iv.badstr;
}
return(Json(d));
}
public JsonResult QueryOne(string emcode)
{
JsonData d = new JsonData();
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
string where = " and emcode='" + emcode + "'";
Sys_RptTemp ls = stb.Query(where);
r = js.Serialize(ls);
}
else
{
r = iv.badstr;
}
d.d = r;
return(Json(d));
}
public static ArrayList QueryTTaskTj(string bdate, string emcode)
{
ArrayList r = new ArrayList();
DataTable lsr = new DataTable();
StringBuilder where = new StringBuilder();
StringBuilder wh2 = new StringBuilder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
DateTime dv = DateTime.Now;
if (bdate != null && bdate != "")
{
wh2.AppendFormat(" and bdate='{0}'", CommonBll.GetBdate(bdate));
}
else
{
wh2.AppendFormat(" and bdate='{0}'", DateTime.Now.ToString("yyyy-MM-dd"));
}
Sys_RptTemp srt = srtb.Query(" and emcode='" + emcode + "'");
if (srt != null)
{
lsr = tsb.QueryList(srt.dbtname, srt.dbcol, wh2.ToString() + srt.dbwhere, " ");
if (lsr != null)
{
int i = 1;
foreach (DataRow dr in lsr.Rows)
{
ArrayList al = new ArrayList();
if (lsr.Columns.Contains("xh"))
{
al.Add(i);
}
foreach (DataColumn column in lsr.Columns)
{
switch (column.Caption)
{
case "id":
break;
case "xh":
break;
default:
al.Add(dr[column].ToString());
break;
}
}
r.Add(al);
i++;
}
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList BlQueryProductions(string bdate, string emcode, string tabcode)
{
ArrayList r = new ArrayList();
DataTable lsr = new DataTable();
StringBuilder where = new StringBuilder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
Sys_RptTemp srt = srtb.Query(" and emcode='" + emcode + "'");
if (srt != null)
{
DateTime dv = DateTime.Now;
if (bdate != null && bdate != "")
{
where.AppendFormat(" and edate='{0}' ", CommonBll.GetBdate(bdate));
}
else
{
where.AppendFormat(" and edate='{0}' ", CommonBll.GetBdate(DateTime.Now.ToString()));
}
if (iv.u.dcode != "")
{
string sqlw = srt.dbwhere.Replace("[dcode]", iv.u.dcode.Substring(0, iv.u.dcode.Length - 4));
where.Append(CommonBll.SqlWhereReplace(iv.u, sqlw));
}
string sfield = srt.dbcol;
lsr = tsb.QueryList(srt.dbtname, sfield, where.ToString(), " order by edate asc");
if (lsr != null)
{
int xh = 1;
foreach (DataRow dr in lsr.Rows)
{
ArrayList al = new ArrayList();
foreach (DataColumn column in lsr.Columns)
{
switch (column.Caption)
{
case "xh":
al.Add(xh);
break;
case "sid":
break;
default:
al.Add(dr[column].ToString());
break;
}
}
xh++;
r.Add(al);
}
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
