/// <summary> /// 查询全部 /// </summary> private void GetAllCar() { string errmsg = ""; DataTable dt = new DataTable(); DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); DataTable dt3 = new DataTable(); string data = Request["data"]; int page = 0; int totalnum = 0; //记录总数 int pagecount = 0; //页总数 int pagesize = 15; BLLProposer mybll = new BLLProposer(); RequesReturnCar rm = ObjectSerializeHelper.JsonToObject <RequesReturnCar>(data); page = rm.page; bool result = mybll.GetAllCar(pagesize, page, ref totalnum, ref pagecount, ref dt, ref dt1, ref dt2, ref dt3, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower) + ",\"data1\":" + ObjectSerializeHelper.DataTableToJson(dt1, ObjectSerializeHelper.ColumnNameLetterCase.ToLower) + ",\"data2\":" + ObjectSerializeHelper.DataTableToJson(dt2, ObjectSerializeHelper.ColumnNameLetterCase.ToLower) + ",\"data3\":" + ObjectSerializeHelper.DataTableToJson(dt3, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); json += ",\"pagecount\":" + pagecount; json += ",\"totalnum\":" + totalnum; Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }
/// <summary> /// 拒绝原因 /// </summary> private void ApplyFalse() { string errmsg = ""; DataTable dt = new DataTable(); string data = Request["data"]; //string applycode = Request["applycode"]; //string reason = Request["reason"]; RequesCarFalse rm = ObjectSerializeHelper.JsonToObject <RequesCarFalse>(data); string applycode = rm.applycode; string reason = rm.reason; string susercode = rm.susercode; BLLProposer mybll = new BLLProposer(); bool result = mybll.ApplyFalse(applycode, reason, susercode, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }
/// <summary> /// 重新选择车牌 /// </summary> private void RegainCar() { string errmsg = ""; DataTable dt = new DataTable(); string data = Request["data"]; RequesDCar rm = ObjectSerializeHelper.JsonToObject <RequesDCar>(data); string applycode = rm.applycode; string platenumber = rm.platenumber; string Oldplatenumber = rm.Oldplatenumber; string reremark = rm.reremark; BLLProposer mybll = new BLLProposer(); bool result = mybll.RegainCar(applycode, platenumber, Oldplatenumber, reremark, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }
/// <summary> /// 查询通过 /// </summary> private void GetTrue() { string errmsg = ""; string data = Request["data"]; DataTable dt = new DataTable(); RequesGetTure rm = ObjectSerializeHelper.JsonToObject <RequesGetTure>(data); string pagecode = rm.pagecode; string nowrow = rm.nowrow; BLLUserManage mybll = new BLLUserManage(); bool result = mybll.GetTrue(pagecode, nowrow, ref dt, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }
/// <summary> /// excle查询 /// </summary> private void GetExcel() { string errmsg = ""; int page = 0; int totalnum = 0; //记录总数 int pagecount = 0; //页总数 int pagesize = 15; DataTable dt = new DataTable(); string data = Request["data"]; RequesExcel rm = ObjectSerializeHelper.JsonToObject <RequesExcel>(data); BLLUniversalExcel mybll = new BLLUniversalExcel(); bool result = mybll.updataAddExcleHeader(pagesize, page, ref totalnum, ref pagecount, ref dt, rm.pagecode, rm.onetypehcode, rm.onetype, rm.onetypevalues, rm.datetypehcode, rm.datetypeselecttype, rm.startdate, rm.enddata, rm.startdata_time, rm.enddata_time, rm.digitaltypehcode, rm.digitaltypeselecttype, rm.twotypetype, rm.oneval1, rm.oneval2, rm.choosetypehcode, rm.choosetypeselecttype, rm.choosetype, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); json += ",\"pagecount\":" + pagecount; json += ",\"totalnum\":" + totalnum; Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }
/// <summary> /// 点击驳回 /// </summary> private void Applyfalse() { string errmsg = ""; string data = Request["data"]; DataTable dt = new DataTable(); RequesFalse rm = ObjectSerializeHelper.JsonToObject <RequesFalse>(data); string pagecode = rm.pagecode; string usercode = rm.usercode; string nowrows = rm.nowrows; string sort = rm.sort; string cause = rm.cause; BLLUserManage mybll = new BLLUserManage(); bool result = mybll.Applyfalse(pagecode, nowrows, sort, cause, usercode, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }
/// <summary> /// 查询行dengdeng /// </summary> private void GetRow() { string errmsg = ""; string data = Request["data"]; DataTable dt = new DataTable(); DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); DataTable dt3 = new DataTable(); DataTable dt4 = new DataTable(); DataTable dt5 = new DataTable(); RequestRow info = ObjectSerializeHelper.JsonToObject <RequestRow>(data); string pagecode = info.pagecode; string usercode = info.usercode; string nowrow = info.nowrow; BLLUserManage mybll = new BLLUserManage(); bool result = mybll.GetRow(pagecode, usercode, nowrow, ref dt, ref dt1, ref dt2, ref dt3, ref dt4, ref dt5, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower) + ",\"data1\":" + ObjectSerializeHelper.DataTableToJson(dt1, ObjectSerializeHelper.ColumnNameLetterCase.ToLower) + ",\"data2\":" + ObjectSerializeHelper.DataTableToJson(dt2, ObjectSerializeHelper.ColumnNameLetterCase.ToLower) + ",\"data3\":" + ObjectSerializeHelper.DataTableToJson(dt3, ObjectSerializeHelper.ColumnNameLetterCase.ToLower) + ",\"data4\":" + ObjectSerializeHelper.DataTableToJson(dt4, ObjectSerializeHelper.ColumnNameLetterCase.ToLower) + ",\"data5\":" + ObjectSerializeHelper.DataTableToJson(dt5, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }
/// <summary> /// 角色授权#### /// </summary> private void RoleAu() { string errmsg = ""; DataTable dt = new DataTable(); string data = Request["data"]; RequestRole info = ObjectSerializeHelper.JsonToObject <RequestRole>(data); string pagecode = info.pagecode; string rolecode = info.rolecode; string usercode = info.usercode; List <RequestRolePage> rolepage = info.rolepage; BLLUserManage mybll = new BLLUserManage(); bool result = mybll.RoleAu(pagecode, rolepage, usercode, rolecode, ref errmsg); if (result) { Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "")); Response.End(); } else { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } }
/// <summary> /// 车辆情况 /// </summary> private void GetUseCar() { string errmsg = ""; DataTable dt = new DataTable(); string data = Request["data"]; RequesUseCar rm = ObjectSerializeHelper.JsonToObject <RequesUseCar>(data); string platenumber = rm.oneval; string plat = rm.onetype; string datetype = rm.datetype; // string usercode = rm.usercode; string startdate = rm.startdate; string enddate = rm.enddate; string sort = rm.sort; string sortfield = rm.sortfield; BLLProposer mybll = new BLLProposer(); bool result = mybll.GetUseCar(platenumber, plat, startdate, datetype, enddate, sort, sortfield, ref dt, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }
/// <summary> /// 立即还车 /// </summary> private void SendReturn() { string errmsg = ""; DataTable dt = new DataTable(); string data = Request["data"]; RequesCarFalse rm = ObjectSerializeHelper.JsonToObject <RequesCarFalse>(data); string applycode = rm.applycode; string endplay = rm.endplay; string returnremark = rm.returnremark; string usercode = rm.usercode; BLLProposer mybll = new BLLProposer(); bool result = mybll.SendReturn(applycode, endplay, returnremark, usercode, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }
/// <summary> /// 提交派车申请单 /// </summary> private void SendCar() { string errmsg = ""; DataTable dt = new DataTable(); string data = Request["data"]; //string usercode = Request["usercode"]; RequesSendCar rm = ObjectSerializeHelper.JsonToObject <RequesSendCar>(data); string applyname = rm.applyname; string accent = rm.accent; string department = rm.department; string proposernomber = rm.proposernomber; string endsite = rm.endsite; string purpose = rm.purpose; string servicetime = rm.servicetime; string usercode = rm.usercode; BLLProposer mybll = new BLLProposer(); bool result = mybll.SendCar(applyname, accent, department, proposernomber, endsite, purpose, servicetime, usercode, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }
/// <summary> /// 更新添加表头 /// </summary> private void updataAddExcleHeader() { string errmsg = ""; string data = Request["data"]; RequestUniversalExcle rm = ObjectSerializeHelper.JsonToObject <RequestUniversalExcle>(data); BLLUniversalExcel mybll = new BLLUniversalExcel(); bool result = mybll.updataAddExcleHeader(rm.pagecode, rm.ExcelHeader, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "")); Response.End(); } }
/// <summary> /// 添加表 /// </summary> private void addPage() { string errmsg = ""; string data = Request["data"]; RequestTable info = ObjectSerializeHelper.JsonToObject <RequestTable>(data); string usercode = info.usercode; string pagename = info.pagename; // string gader = info.gader; //审核等级 BLLUserManage mybll = new BLLUserManage(); bool result = mybll.addPage(pagename, usercode, info.审核用户, ref errmsg); if (result) { Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "")); Response.End(); } else { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } }
/// <summary> /// 车辆明细 /// </summary> private void GetUseCarDetail() { string errmsg = ""; DataTable dt = new DataTable(); string data = Request["data"]; int page = 0; int totalnum = 0; //记录总数 int pagecount = 0; //页总数 int pagesize = 20; RequesUseCar rm = ObjectSerializeHelper.JsonToObject <RequesUseCar>(data); string platenumber = rm.oneval; string plat = rm.onetype; string datetype = rm.datetype; // string usercode = rm.usercode; string startdate = rm.startdate; string enddate = rm.enddate; string username = rm.username; string applyname = rm.applyname; string sort = rm.sort; string sortfield = rm.sortfield; BLLProposer mybll = new BLLProposer(); bool result = mybll.GetUseCarDetail(platenumber, plat, startdate, datetype, enddate, username, applyname, sort, sortfield, page, pagesize, ref totalnum, ref pagecount, ref dt, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); json += ",\"pagecount\":" + pagecount; json += ",\"totalnum\":" + totalnum; Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }
/// <summary> /// 编辑行 /// </summary> private void updateRow() { string errmsg = ""; string data = Request["data"]; DataTable dt = new DataTable(); RequesRow rm = ObjectSerializeHelper.JsonToObject <RequesRow>(data); BLLUserManage mybll = new BLLUserManage(); bool result = mybll.updateRow(rm.编辑的数据, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }
/// <summary> /// 获取表名页面列表 /// </summary> private void GetRolePageList() { string errmsg = ""; DataTable dt = new DataTable(); string data = Request["data"]; RequestGet info = ObjectSerializeHelper.JsonToObject <RequestGet>(data); string rolecode = info.rolecode; BLLUserManage mybll = new BLLUserManage(); bool result = mybll.GetRolePageList(rolecode, ref dt, ref errmsg); if (result) { string str = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt); Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", str)); Response.End(); } else { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } }
/// <summary> /// 提交申请 /// </summary> private void GetUsercode() { string errmsg = ""; DataTable dt = new DataTable(); string data = Request["data"]; // string usercode = Request["usercode"]; RequesReturnCar rm = ObjectSerializeHelper.JsonToObject <RequesReturnCar>(data); string usercode = rm.usercode; BLLProposer mybll = new BLLProposer(); bool result = mybll.GetUsercode(usercode, ref dt, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }
/// <summary> /// 删除表头 /// </summary> private void deleteHead() { string errmsg = ""; string data = Request["data"]; DataTable dt = new DataTable(); RequesDelete rm = ObjectSerializeHelper.JsonToObject <RequesDelete>(data); //string hcode = rm.hcode; //string pagecode = rm.pagecode; //string usercode = rm.usercode; BLLUserManage mybll = new BLLUserManage(); bool result = mybll.deleteHead(rm.要删除的数据, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }