public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
NameValueCollection rp = context.Request.Form;
Guid rwid = new Guid(rp["rwid"]);
List<BaseEntity> list = new List<BaseEntity>();
string msg = string.Empty;
PersonInfo curentperson = null;
string zprenstr = rp["zpren[]"];
try
{
PersonInfoManager plogic = new PersonInfoManager();
string[] zpren = zprenstr.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < zpren.Length; i++)
{
if (i == 0)
{
curentperson = plogic.GetItemById(new Guid(zpren[i]));
}
WorkHandLog log = new WorkHandLog();
log.ID = Guid.NewGuid();
log.WorkID = rwid;
log.CurrentStaus = "处理中";
log.ChuliYj = "工作指派";
if (!string.IsNullOrEmpty(context.Session["UserName"] as string))
{
log.Uper = new Guid(context.Session["UserID"].ToString());
log.UpName = context.Session["RealName"] as string;
}
log.DownEr = new Guid(zpren[i]);
log.DownName = plogic.GetItemById(log.DownEr.Value).RealName;
log.HandDate = DateTime.Now;
log.HandResult = "已指派";
log.HandSequence = 1;
list.Add(log);
}
WorkInfo work = new WorkInfo();
work.ID = rwid;
work.RecordStatus = Sharp.Common.StatusType.update;
work.Status = "处理中";
work.CurrentUser = curentperson.RealName;
list.Add(work);
int result = new WorkInfoManager().Save(list);
context.Response.Write("{\"success\":\"true\"}");
}
catch (Exception ex)
{
msg = ex.Message;
}
if (!string.IsNullOrEmpty(msg))
{
byte[] bytes = Encoding.UTF8.GetBytes(msg.Replace("\r\n", "<br/>"));
string encode = Convert.ToBase64String(bytes);
context.Response.Write("{\"success\":\"false\",\"msg\":\"" + encode + "\"}");
}
context.Response.End();
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest rp = context.Request;
WorkInfoManager manager = new WorkInfoManager();
int currentPage = int.Parse(rp["pagenum"]);
int pageSize = int.Parse(rp["pagesize"]);
int count = 0, recordCount = 0;
string workstatus = rp["Workstatus"];
WhereClip where = null;
if (!string.IsNullOrEmpty(workstatus))
{
where = WorkInfo._.Status == workstatus;
}
string UserId = string.Empty;
if (!string.IsNullOrEmpty(rp["IsDaiBan"]))
{
UserId = context.Session["UserID"].ToString() + ";" + rp["IsDaiBan"];
}
else
{
if (context.Session["AllDepart"] != null)
{
List<AdministrativeRegions> list = context.Session["AllDepart"] as List<AdministrativeRegions>;
if (list != null && list.Count > 0)
{
string[] dparr = new string[list.Count];
for (int i = 0; i < list.Count; i++)
{
dparr[i] = list[i].ID.ToString();
}
if (WhereClip.IsNullOrEmpty(where))
{
where = ShebeiInfo._.SocrceDepart.In(dparr);
}
else
{
where = where && ShebeiInfo._.SocrceDepart.In(dparr);
}
}
}
}
DataTable dt = manager.GetDataTable(currentPage + 1, pageSize, UserId, where, WorkInfo._.CreateDate.Desc, ref count, ref recordCount);
string result = JsonConvert.Convert2Json(dt);
context.Response.Write("{ \"totalRecords\":\"" + recordCount + "\",\"rows\":" + result + "}");
context.Response.End();
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string sbid = context.Request.QueryString["sbid"];
string type = context.Request.QueryString["type"];
DataTable dt = new WorkInfoManager().GetWorkHandType(sbid, type);
string result = JsonConvert.Convert2Json(dt);
context.Response.Write("{\"total\":\"1\",\"rows\":" + result + "}");
context.Response.End();
}
public void ProcessRequest(HttpContext context)
{
HttpRequest rp = context.Request;
WorkInfoManager manager = new WorkInfoManager();
WhereClip where = WorkHandLog._.WorkID == rp["WorkID"];// WorkHandLog._.DownEr == new Guid(context.Session["UserID"].ToString());
DataTable dt = manager.GetDaiBanDataTable(where, WorkHandLog._.HandSequence.Asc && WorkHandLog._.HandDate.Desc);
string result = JsonConvert.Convert2Json(dt);
context.Response.Write(result);
context.Response.End();
}
public void ProcessRequest(HttpContext context)
{
string sbid = context.Request.QueryString["sbid"];
string name = context.Request.QueryString["name"];
string type = context.Request.QueryString["type"];
ExcelOperator eo = new ExcelOperator();
DataTable dt = new WorkInfoManager().GetWorkHandType(sbid, type);
IWorkbook work = eo.GenerateSheet(dt, name);
string path = Guid.NewGuid() + ".xls";
string dict = context.Server.MapPath("~\\upload\\") + "exportxml";
if (Directory.Exists(dict))
{
string[] fs = Directory. GetFileSystemEntries(dict);
foreach (string item in fs)
{
File.Delete(item);
}
}
while (!Directory.Exists(dict))
{
Directory.CreateDirectory(dict);
}
string newpath = dict + "\\" + path; ;
try
{
using (Stream stream = File.Open(newpath, FileMode.OpenOrCreate, FileAccess.ReadWrite))
{
work.Write(stream);
}
context.Response.Write("{\"success\":\"true\",\"msg\":\"" + path + "\"}");
}
catch (Exception ex)
{
path = "错误：" + ex.Message;
path = path.Replace("\r\n", "<br/>");
byte[] bytes = Encoding.UTF8.GetBytes(path);
string encode = Convert.ToBase64String(bytes);
context.Response.Write("{\"success\":\"false\",\"msg\":\"" + encode + "\"}");
}
context.Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
string desc_tmpl = "报工设备：{0} 报工时间：{1} <br/><br/>处理意见：{2}";
if (!IsPostBack)
{
WorkInfoManager wkMgr = new WorkInfoManager();
string id = Request.QueryString.Get("id");
WhereClip where = WorkInfo._.ID == new Guid(id);
OrderByClip order = WorkInfo._.CreateDate.Desc;
int count = 0;
DataTable dtwk = wkMgr.GetDataTable(1, 1, where, order, ref count, ref count);
news_title.InnerHtml = "报修设备：" + dtwk.Rows[0]["Name"].ToString();
//news_desc.InnerHtml = string.Format(desc_tmpl, dtwk.Rows[0]["Name"], dtwk.Rows[0]["GuZhangXx"], dtwk.Rows[0]["ChuLiYiJian"]);
news_content.InnerHtml = string.Format(desc_tmpl, dtwk.Rows[0]["Name"], dtwk.Rows[0]["GuZhangXx"], dtwk.Rows[0]["ChuLiYiJian"]); ;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
WorkInfoManager Manager = new WorkInfoManager();
txtWorkID.Value = Request.QueryString["ID"];
DataTable dt = Manager.GetWorkInfo(txtWorkID.Value);
if (dt.Rows.Count == 1)
{
txtChuliYj.Value = dt.Rows[0]["ChuLiYiJian"] as string;
txtShebei.Value = dt.Rows[0]["ShebeiName"] as string;
txtGZXX.Value = dt.Rows[0]["GuZhangXx"] as string;
txtCurrentStaus.Value = dt.Rows[0]["Status"] as string;
WorkHandLog last = Manager.GetLstWorkHandInfo(txtWorkID.Value);
if (last != null)
{
txtLastHandle.Value = last.ChuliYj;
}
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest rp = context.Request;
string msg = string.Empty;
try
{
if (string.IsNullOrEmpty(rp["txtID"]))
{
entity.ID = Guid.NewGuid();
}
else
{
entity.ID = new Guid(rp["txtID"]);
entity.RecordStatus = StatusType.update;
}
entity.SbID = new Guid(rp["txtSbID"]);
entity.GuZhangXx = rp["txtGuZhangXx"];
entity.ChuLiYiJian = rp["txtChuLiYiJian"];
if (!string.IsNullOrEmpty(rp["txtPlanTime"]))
{
entity.PlanTime = DateTime.Parse(rp["txtPlanTime"]);
}
entity.Status = "制单";
if (string.IsNullOrEmpty(context.Session["UserName"] as string))
{
entity.CreaterID = Guid.NewGuid();
entity.CreaterName = "管理员";
}
else
{
entity.CreaterID = new Guid(context.Session["UserID"].ToString());
entity.CreaterName = context.Session["UserName"] as string;
}
if (!string.IsNullOrEmpty(rp["txtRealTime"]))
{
entity.RealTime = DateTime.Parse(rp["txtRealTime"]);
}
entity.Note = rp["txtNote"];
if (!string.IsNullOrEmpty(rp["txtCity"]))
{
entity.City = new Guid(rp["txtCity"]);
}
if (!string.IsNullOrEmpty(rp["txtXian"]))
{
entity.Xian = new Guid(rp["txtXian"]);
}
if (!string.IsNullOrEmpty(rp["txtZhen"]))
{
entity.Zhen = new Guid(rp["txtZhen"]);
}
entity.Address = rp["txtAddress"];
entity.Tel = rp["txtTel"];
entity.CreateDate = DateTime.Now;
entity.Guzhang = rp["txtGuzhang"];
WorkInfoManager manager = new WorkInfoManager();
manager.Save(entity);
context.Response.Write("{\"success\":\"true\",\"ID\":\"" + entity.ID + "\"}");
}
catch (Exception ex)
{
msg = ex.Message;
}
if (!string.IsNullOrEmpty(msg))
{
byte[] bytes = Encoding.UTF8.GetBytes(msg.Replace("\r\n", "<br/>"));
string encode = Convert.ToBase64String(bytes);
context.Response.Write("{\"success\":\"false\",\"msg\":\"" + encode + "\"}");
}
context.Response.End();
}
private void GerneraotrDaiBan(string UserId)
{
string tem = @" <tr class='{6}'>
<td align='center'>
{0}
</td>
<td>
{1}
</td>
<td align='center'>
{2}
</td>
<td align='center'>
{3}
</td>
<td align='center'>
{4}
</td>
<td align='center'>
<a href='WorkHandLogEdit.aspx?ID={5}'>办理</a>
</td>
</tr>";
WorkInfoManager manager = new WorkInfoManager();
int pageCount = 0, recordCount = 0;
DataTable dt = manager.GetDaiBanDataTable(1, 5, WorkHandLog._.DownEr == new Guid(Session["UserID"].ToString()), WorkHandLog._.HandDate.Desc, ref pageCount, ref recordCount);
StringBuilder sb = new StringBuilder();
int i = 1;
foreach (DataRow item in dt.Rows)
{
string temodd = odd_bg;
if (i % 2 == 0)
{
temodd = "";
}
sb.AppendFormat(tem, i++, item["GuZhangXx"], ((DateTime)item["HandDate"]).ToString("yyyy-MM-dd"), item["UpName"], item["Status"], item["WorkID"], temodd);
}
DaiBanRenWU = sb.ToString();
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest rp = context.Request;
string msg = string.Empty;
try
{
WorkInfoManager manager = new WorkInfoManager();
List<BaseEntity> entityList = new List<BaseEntity>();
int maxsequenc = manager.GetMaxSequence(new Guid(rp["txtWorkID"]));
string zt = rp["txtHandResult"];
WorkInfo work = new WorkInfo();
work.ID = new Guid(rp["txtWorkID"]);
work = manager.GetItemById(work.ID);
work.RecordStatus = StatusType.update;
work.Status = zt;
ShebeiInfo s = new ShebeiInfo();
s = new ShebeiInfoManager().GetItemById(work.SbID);
if (zt == "处理中")
{
string[] zprid = rp["txtZprID"].Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
string[] zprName = rp["txtZprName"].Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
work.CurrentUser = rp["txtZprName"];
for (int i = 0; i < zprid.Length; i++)
{
WorkHandLog tem = SetValue(rp, context);
tem.DownEr = new Guid(zprid[i]);
tem.DownName = zprName[i];
tem.HandSequence = maxsequenc;
entityList.Add(tem);
}
s.State = zt;
}
else
{
work.RealTime = DateTime.Now;
work.CurrentUser = manager.GetLastUserName(work.ID) ;
WorkHandLog tem = SetValue(rp, context);
tem.HandSequence = maxsequenc;
int handType = 0;
int.TryParse(rp["txtHandType"], out handType);
tem.HandType = handType;
entityList.Add(tem);
s.State = "正常";
if (rp["txtHandType"] == "0")
{
//维修
string sql = "update ShebeiInfo set GZTJ=isnull(GZTJ,0)+1 where id='" + s.ID + "'";
Sharp.Data.SessionFactory.Default.FromCustomSql(sql).ExecuteNonQuery();
}
else if (rp["txtHandType"] == "1")
{
//更换
string sql = "update ShebeiInfo set GHTJ=isnull(GHTJ,0)+1 where id='" + s.ID + "'";
Sharp.Data.SessionFactory.Default.FromCustomSql(sql).ExecuteNonQuery();
}
}
entityList.Add(work);
entityList.Add(s);
manager.Save(entityList);
context.Response.Write("{\"success\":\"true\"}");
}
catch (Exception ex)
{
msg = ex.Message;
}
if (!string.IsNullOrEmpty(msg))
{
byte[] bytes = Encoding.UTF8.GetBytes(msg.Replace("\r\n", "<br/>"));
string encode = Convert.ToBase64String(bytes);
context.Response.Write("{\"success\":\"false\",\"msg\":\"" + encode + "\"}");
}
context.Response.End();
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest rp = context.Request;
WorkInfoManager manager = new WorkInfoManager();
int currentPage = int.Parse(rp["pagenum"]);
int pageSize = int.Parse(rp["pagesize"]) ;
int count = 0, recordCount = 0;
string workstatus = rp["Workstatus"];
WhereClip where = new WhereClip();
if (context.Session["AllDepart"] != null)
{
List<AdministrativeRegions> list = context.Session["AllDepart"] as List<AdministrativeRegions>;
if (list != null && list.Count > 0)
{
string[] dparr = new string[list.Count];
for (int i = 0; i < list.Count; i++)
{
dparr[i] = list[i].ID.ToString();
}
if (WhereClip.IsNullOrEmpty(where))
{
where = ShebeiInfo._.SocrceDepart.In(dparr);
}
else
{
where = where && ShebeiInfo._.SocrceDepart.In(dparr);
}
}
}
if (!string.IsNullOrEmpty(workstatus))
{
where.And(WorkInfo._.Status == workstatus);
}
if (!string.IsNullOrEmpty(context.Request["begindate"]))
{
string begin = context.Request["begindate"];
if (!string.IsNullOrEmpty(begin))
{
where = where && WorkInfo._.CreateDate >= begin;
}
}
if (!string.IsNullOrEmpty(context.Request["enddate"]))
{
string enddate = context.Request["enddate"];
if (!string.IsNullOrEmpty(enddate))
{
where = where && WorkInfo._.CreateDate <= enddate;
}
}
if (!string.IsNullOrEmpty(context.Request["username"]))
{
where = where && WorkInfo._.CurrentUser.Contains(context.Request["username"]);
}
if (!string.IsNullOrEmpty(context.Request["sbcode"]))
{
where = where && ShebeiInfo._.Code.Contains(context.Request["sbcode"]);
}
if (!string.IsNullOrEmpty(context.Request["sbname"]))
{
where = where && ShebeiInfo._.Name.Contains(context.Request["sbname"]);
}
OrderByClip or = WorkInfo._.CreateDate.Desc;
if (!string.IsNullOrEmpty(context.Request["sortdatafield"]))
{
if (!string.IsNullOrEmpty(context.Request["sortorder"]) && context.Request["sortorder"] == "desc")
{
or = new OrderByClip(context.Request["sortdatafield"] + " desc");
}
else
{
or = new OrderByClip(context.Request["sortdatafield"]);
}
}
DataTable dt = manager.GetDataTable(currentPage + 1, pageSize, where, or, ref count, ref recordCount);
string result = JsonConvert.Convert2Json(dt);
context.Response.Write("{ \"totalRecords\":\"" + recordCount + "\",\"rows\":" + result + "}");
context.Response.End();
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest rp = context.Request;
WorkInfoManager manager = new WorkInfoManager();
int currentPage = int.Parse(rp["pagenum"]);
int pageSize = int.Parse(rp["pagesize"]);
int count = 0, recordCount = 0;
string workstatus = rp["Workstatus"];
WhereClip where = null;
where = WorkInfo._.CreateDate.Like("%%");
if (!string.IsNullOrEmpty(workstatus))
{
where.And(WorkInfo._.Status == workstatus);
}
if (!string.IsNullOrEmpty(context.Request["RQ"]))
{
string[] datestr = context.Request["RQ"].ToString().Split('@');
string begin = datestr[0];
if (!string.IsNullOrEmpty(begin))
{
where.And(WorkInfo._.CreateDate >= begin);
}
string end = datestr[1];
if (!string.IsNullOrEmpty(end))
{
where.And(WorkInfo._.CreateDate <= end);
}
}
if (!string.IsNullOrEmpty(context.Request["USERNAME"]))
{
where.And(WorkInfo._.CreaterName.Like("%" + context.Request["USERNAME"].ToString() + "%"));
}
if (!string.IsNullOrEmpty(context.Request["SBNAME"]))
{
where.And(ShebeiInfo._.Name.Like("%" + context.Request["SBNAME"].ToString() + "%"));
}
if (!string.IsNullOrEmpty(context.Request["SBZT"]))
{
where.And(WorkInfo._.Status.Like("%" + context.Request["SBZT"].ToString() + "%"));
}
if (!string.IsNullOrEmpty(context.Request["GZXX"]))
{
where.And(WorkInfo._.GuZhangXx.Like("%" + context.Request["GZXX"].ToString() + "%"));
}
if (context.Session["AllDepart"] != null)
{
List<AdministrativeRegions> list = context.Session["AllDepart"] as List<AdministrativeRegions>;
if (list != null && list.Count > 0)
{
string[] dparr = new string[list.Count];
for (int i = 0; i < list.Count; i++)
{
dparr[i] = list[i].ID.ToString();
}
if (WhereClip.IsNullOrEmpty(where))
{
where = ShebeiInfo._.SocrceDepart.In(dparr);
}
else
{
where = where && ShebeiInfo._.SocrceDepart.In(dparr);
}
}
}
OrderByClip or = WorkInfo._.CreateDate.Desc;
if (!string.IsNullOrEmpty(context.Request["sortdatafield"]))
{
if (!string.IsNullOrEmpty(context.Request["sortorder"]) && context.Request["sortorder"] == "desc")
{
or = new OrderByClip(context.Request["sortdatafield"] + " desc");
}
else
{
or = new OrderByClip(context.Request["sortdatafield"]);
}
}
if (!string.IsNullOrEmpty(context.Request["index"]))
{
pageSize = 4;
}
DataTable dt = manager.GetDataTable(currentPage + 1, pageSize, where, or, ref count, ref recordCount);
string result = JsonConvert.Convert2Json(dt);
context.Response.Write("{ \"totalRecords\":\"" + recordCount + "\",\"rows\":" + result + "}");
context.Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserName"] != null)
{
hid.Value = Session["UserName"].ToString();
}
if (!IsPostBack)
{
NoticeInfoManager ntMgr = new NoticeInfoManager();
down.InnerText = "主办单位：长清公安分局";
string titlepix = "首页";
switch (Request.FilePath.ToLower())
{
case "/indexxjsb.aspx":
titlepix = "巡检设备";
break;
case "/indexkaoqin.aspx":
titlepix = "考勤统计";
break;
case "/indexpaigong.aspx":
titlepix = "派工统计";
break;
case "/indexXjsb.aspx":
titlepix = "巡检设备";
break;
}
ttt.Text = titlepix + "-长清公安分局运维综合管理系统";
//NoticeInfo notice = ntMgr.GetTopText(true);
//string s = "<a style='color:#FFFFFF; ' href='newsinfo.aspx?id={0}'>{1}</a>";
//if (notice != null)
//{
// hidZuiTopTongZhi.Value = string.Format(s, notice.ID, notice.TITLE);
//}
//NoticeInfo notice = ntMgr.GetTopText(false);
//string s = "<a style='font-family:Microsoft YaHei;color:#FFFF00;font-size:24px;' href='newsinfo.aspx?id={0}'>{1}</a>";
//if (notice != null)
//{
// hidTopTongZhid.Value = string.Format(s, notice.ID, notice.TITLE);
//}
WorkInfoManager wkMgr = new WorkInfoManager();
WhereClip where = WorkInfo._.Status == "制单";
OrderByClip order = WorkInfo._.CreateDate.Desc;
int count = 0;
if ( Session["AllDepart"] != null)
{
List<AdministrativeRegions> list = Session["AllDepart"] as List<AdministrativeRegions>;
if (list != null && list.Count > 0)
{
string[] dparr = new string[list.Count];
for (int i = 0; i < list.Count; i++)
{
dparr[i] = list[i].ID.ToString();
}
if (WhereClip.IsNullOrEmpty(where))
{
where = ShebeiInfo._.SocrceDepart.In(dparr);
}
else
{
where = where && ShebeiInfo._.SocrceDepart.In(dparr);
}
}
}
DataTable dtwk = wkMgr.GetGzDataTable(1, 4, where, order, ref count, ref count);
string s = "<a style='font-family:Microsoft YaHei;color:#FFFF00;font-size:24px;' >{0}</a>";
string msg = string.Empty;
if (dtwk == null || dtwk.Rows.Count == 0)
{
msg = "没有最新设备报修信息，所有报修设备信息都已派工";
}
else
{
foreach (DataRow item in dtwk.Rows)
{
msg += item["Name"] + "(" + item["Code"] + ")：" + item["Guzhang"];
msg += " | ";
}
}
hidTopTongZhid.Value = string.Format(s, msg); ;
}
}
