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); ; } }