public string SaveQrStyle() { string masterData = System.Web.HttpContext.Current.Request.Form["masterData"]; DataTable masterDt = new DataTable(); if (!string.IsNullOrWhiteSpace(masterData)) { masterDt = DataConverterHelper.ToDataTable(masterData, "select * from fg3_qrcode_style"); } ResponseResult result = new ResponseResult(); try { result = proxy.SaveQrStyle(masterDt); } catch (Exception ex) { result.Status = "error"; result.Msg = ex.Message.ToString(); } string response = JsonConvert.SerializeObject(result); return(response); }
public string SaveTree() { string NavigationTree = System.Web.HttpContext.Current.Request.Form["NavigationTree"]; long userid = AppInfoBase.UserID; DataTable NavigationTreeTable = DataConverterHelper.ToDataTable(NavigationTree, "select * from fg3_process_tree"); int iret; try { iret = proxy.SaveTree(NavigationTreeTable); if (iret > 0) { return("{status : \"ok\"}"); } else { return("{status : \"error\",messsage:\"保存失败\"}"); } } catch (Exception ex) { //throw new Exception(ex.Message); return("{status : \"error\",messsage:\"" + ex.Message + "\"}"); } }
public bool SaveBizDataByMobileApp(WorkFlowExecutionContext ec, Dictionary <string, string> jsonData) { string bizID = ec.BillInfo.BizID; //业务类型EFORM0000000130 string eformid = bizID.Substring(5); string tableNameM = "p_form" + eformid + "_m"; string tableNameD = "p_form" + eformid + "_d"; if (jsonData.ContainsKey(tableNameM) && !string.IsNullOrEmpty(jsonData[tableNameM].ToString())) { DataTable dtM = DataConverterHelper.ToDataTable(jsonData[tableNameM].ToString(), string.Format("select * from {0}", tableNameM)); DbHelper.Update(dtM, string.Format("select * from {0}", tableNameM)); } //获取所有明细表dt DataTable detailList = DbHelper.GetDataTable(string.Format("select tname from ctl_tbl where tname like '{0}%'", tableNameD)); if (detailList != null && detailList.Rows.Count > 0) { DataTable[] dtD = new DataTable[detailList.Rows.Count]; for (int i = 0; i < detailList.Rows.Count; i++) { tableNameD = detailList.Rows[i]["tname"].ToString(); if (jsonData.ContainsKey(tableNameD) && !string.IsNullOrEmpty(jsonData[tableNameD].ToString())) { dtD[i] = DataConverterHelper.ToDataTable(jsonData[tableNameD].ToString(), string.Format("select * from {0}", tableNameD)); DbHelper.Update(dtD[i], string.Format("select * from {0}", tableNameD)); } } } return(true); }
/// <summary> /// 保存编码规则 /// </summary> /// <returns></returns> public int Save() { try { string data = System.Web.HttpContext.Current.Request.Params["griddata"]; string c_btype = System.Web.HttpContext.Current.Request.Params["treetype"]; string deletedata = System.Web.HttpContext.Current.Request.Params["deletedata"]; DataTable dt = DataConverterHelper.ToDataTable(data, "select * from c_pfc_billnorule_m"); DataTable deldt = new DataTable(); deldt.Columns.Add("key", Type.GetType("System.String")); if (!string.IsNullOrEmpty(deletedata)) { var del = JArray.Parse(JsonConvert.DeserializeObject(deletedata).ToString()); foreach (var ss in del) { DataRow deldr = deldt.NewRow(); deldr["key"] = ss["row"]["key"]; deldt.Rows.Add(deldr); } } return(facade.Save(dt, c_btype, deldt)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 保存查询条件设置信息 /// </summary> /// <returns></returns> public string SaveQueryInfo() { string pageid = System.Web.HttpContext.Current.Request.Params["pageid"]; string griddata = System.Web.HttpContext.Current.Request.Params["griddata"]; string gridchange = System.Web.HttpContext.Current.Request.Params["gridchange"]; //修改行 DataTable dt = DataConverterHelper.ToDataTable(griddata, "select ccode,'' as definetype, searchtable,searchfield,fname_chn,isplay,combflg,defaultdata,playindex AS displayindex,sortmode,sortorder from c_sys_search"); DataTable dtchange = DataConverterHelper.ToDataTable(gridchange, "select ccode,pageid,'' as definetype, searchtable,searchfield,fname_chn,isplay,combflg,defaultdata,playindex AS displayindex,sortmode,sortorder from c_sys_search"); int iret = proxy.SaveQueryInfo(dtchange, dt, pageid, AppInfoBase.OCode, AppInfoBase.LoginID); ResponseResult result = new ResponseResult(); if (iret > 0) { result.Status = ResponseStatus.Success; } else { result.Status = ResponseStatus.Error; } string response = JsonConvert.SerializeObject(result); return(response); }
public string Save(string data) { try { DataTable dt = DataConverterHelper.ToDataTable(data, "select * from fg_individualform"); int iret = proxy.Save(dt); ResponseResult result = new ResponseResult(); if (iret > 0) { result.Status = ResponseStatus.Success; } else { result.Status = ResponseStatus.Error; } string response = JsonConvert.SerializeObject(result); return(response); } catch (Exception ex) { ResponseResult result = new ResponseResult(); result.Status = ResponseStatus.Error; result.Msg = ex.Message; string response = JsonConvert.SerializeObject(result); return(response); //return "{Status : \"error\",Msg:'" + ex.Message + "'}"; } }
public string Save() { string masterId = System.Web.HttpContext.Current.Request.Form["masterid"]; string masterdata = System.Web.HttpContext.Current.Request.Form["masterData"]; string sysdata = System.Web.HttpContext.Current.Request.Form["sysdata"]; string userdata = System.Web.HttpContext.Current.Request.Form["userdata"]; string detailtabledata = System.Web.HttpContext.Current.Request.Form["detailtabledata"]; string queryPropData = System.Web.HttpContext.Current.Request.Form["queryPropData"]; string richQueryData = System.Web.HttpContext.Current.Request.Form["richQueryData"]; DataTable masterdt = new DataTable(); DataTable sysdt = new DataTable(); DataTable userdt = new DataTable(); DataTable detaildt = new DataTable(); DataTable queryPropDt = new DataTable(); DataTable richQueryDt = new DataTable(); if (!string.IsNullOrWhiteSpace(masterdata)) { masterdt = DataConverterHelper.ToDataTable(masterdata, "select * from fg_helpinfo_master"); } if (!string.IsNullOrWhiteSpace(sysdata)) { sysdt = DataConverterHelper.ToDataTable(sysdata, "select * from fg_helpinfo_sys"); } if (!string.IsNullOrWhiteSpace(userdata)) { userdt = DataConverterHelper.ToDataTable(userdata, "select * from fg_helpinfo_user"); } if (!string.IsNullOrWhiteSpace(queryPropData)) { queryPropDt = DataConverterHelper.ToDataTable(queryPropData, "select * from fg_helpinfo_queryprop"); } if (!string.IsNullOrWhiteSpace(richQueryData)) { richQueryDt = DataConverterHelper.ToDataTable(richQueryData, "select * from fg_helpinfo_richquery"); } if (!string.IsNullOrWhiteSpace(detailtabledata)) { detaildt = DataConverterHelper.ToDataTable(detailtabledata, "select * from fg_helpinfo_detailtable"); } CommonHelpSettingEntity entity = new CommonHelpSettingEntity(); entity.MasterDt = masterdt; entity.SystemFieldDt = sysdt; entity.UserFieldDt = userdt; entity.QueryProperty = queryPropDt; entity.RichQuery = richQueryDt; entity.DetailDt = detaildt; ResponseResult result = proxy.Save(masterId, entity); string response = JsonConvert.SerializeObject(result); return(response); }
public int Save() { string gridData = System.Web.HttpContext.Current.Request.Params["gridData"]; DataTable dt = DataConverterHelper.ToDataTable(gridData, "select * from fg3_app_autoauthorize"); return(proxy.Save(dt)); }
public int SaveMyMenu() { string gridData = System.Web.HttpContext.Current.Request.Params["gridData"]; DataTable masterdt = DataConverterHelper.ToDataTable(gridData, "select * from fg_myfunction"); int succCount = proxy.SaveMyMenu(masterdt); CommonUIP.RefurbishPorat(ReceiverType.Type_Ope, AppInfoBase.UserID.ToString(), PortalType.Portal_MyMenu); return(succCount); }
public string SaveShortcutMenu() { string gridData = System.Web.HttpContext.Current.Request.Params["gridData"]; DataTable dt = DataConverterHelper.ToDataTable(gridData, "select * from fg3_shortcutmenu"); DataTable dtShortcut = proxy.SaveShortcutMenu(dt); int totalRecord = dtShortcut.Rows.Count; string json = DataConverterHelper.ToJson(dtShortcut, totalRecord); return(json); }
/// <summary> /// 保存明细表信息 /// </summary> /// <returns></returns> public int SaveDetailData() { string logid = NG3.AppInfoBase.LoginID; string detailData = System.Web.HttpContext.Current.Request.Params["gridData"]; DataTable dt = DataConverterHelper.ToDataTable(detailData, "select * from fg3_option_detail"); int iret = proxy.SaveDetailData(dt, logid); return(iret); }
public string Save() { string data = System.Web.HttpContext.Current.Request.Params["data"]; string tableName = System.Web.HttpContext.Current.Request.Params["tableName"]; string count = System.Web.HttpContext.Current.Request.Params["count"]; string selected = System.Web.HttpContext.Current.Request.Params["selected"]; string message = ""; try { Dictionary <string, string> tableDic = ToDictionary(data, tableName, count); if (tableDic.Count == 0) { return("0#无数据"); //return "{\"success\":\"false\",\"message\":\"" + "无数据" + "\"}"; } DataSet ds = new DataSet(); foreach (var kv in tableDic) { string s = proxy.GetSelectSql(kv.Value, kv.Key);//模板里定义了数据不存在的列,需要合并到sql中,数据原样传给插件 DataTable dt = DataConverterHelper.ToDataTable(kv.Value, s); //DataTable dt = DataConverterHelper.ToDataTable(kv.Value, "select * from " + kv.Key); dt.TableName = kv.Key; ds.Tables.Add(dt); } bool flag = proxy.Save(ds, selected, ref message); if (false == flag) { return("0#" + message + ""); //return "{\"success\":\"false\",\"message\":\"" + message + "\"}"; } //return "{\"success\":\"true\",\"message\":\"" + message + "\"}"; return("1#" + message + ""); } catch (Exception ex) { Logger.Error(ex.StackTrace); //return "{\"success\":\"false\",\"message\":\"" + ex.Message + "\"}"; return("0#" + ex.Message + ""); } }
public string Save(string data) { try { DataTable dt = DataConverterHelper.ToDataTable(data, "select * from fg_individualinfo"); var dellist = new List <string>(); var o = JObject.Parse(data)["table"]["deletedRow"]; if (o != null) { foreach (JToken child in o.Children()) { dellist.Add(child["row"]["key"].ToString()); } } int iret = proxy.Save(dt, dellist); ResponseResult result = new ResponseResult(); if (iret > 0) { result.Status = ResponseStatus.Success; } else { result.Status = ResponseStatus.Error; } string response = JsonConvert.SerializeObject(result); return(response); } catch (Exception ex) { ResponseResult result = new ResponseResult(); result.Status = ResponseStatus.Error; result.Msg = ex.Message; string response = JsonConvert.SerializeObject(result); return(response); //return "{Status : \"error\",Msg:'" + ex.Message + "'}"; //throw ex; } }
public int SaveTaxOrg() { string detailData = System.Web.HttpContext.Current.Request.Params["gridData"]; string detailPhid = System.Web.HttpContext.Current.Request.Params["detailPhid"]; string option_type = System.Web.HttpContext.Current.Request.Params["option_type"]; DataTable dt = DataConverterHelper.ToDataTable(detailData, "select * from fg3_argument_setting"); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["detail_phid"] = Convert.ToInt64(detailPhid); dt.Rows[i]["type"] = option_type; } } int iret = proxy.SaveTaxOrg(dt); return(iret); }
/// <summary> /// 保存编码规则明细 /// </summary> /// <returns></returns> public int SaveDetails() { try { string loginid = AppInfoBase.LoginID; long orgid = AppInfoBase.OrgID; string data = System.Web.HttpContext.Current.Request.Params["griddata"]; string c_bcode = System.Web.HttpContext.Current.Request.Params["c_bcode"]; DataTable dt = DataConverterHelper.ToDataTable(data, "select * from c_pfc_billnorule_d"); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["c_bcode"] = c_bcode; if (dt.Rows[i]["codeitem"].ToString() == "systeminfo") { switch (dt.Rows[i]["codeitemcontent"].ToString()) { case "当前操作员编码": dt.Rows[i]["codeitemcontent"] = "operatorno"; break; case "当前操作员所在的部门编码": dt.Rows[i]["codeitemcontent"] = "deptno"; break; case "当前组织号": dt.Rows[i]["codeitemcontent"] = "ocode"; break; case "当前组织简码": dt.Rows[i]["codeitemcontent"] = "codevalue"; break; } } } return(facade.SaveDetails(dt, loginid, orgid)); } catch (Exception) { throw; } }
public string SavePropertyUIInfo() { string griddata = System.Web.HttpContext.Current.Request.Form["griddata"]; try { DataTable dt = DataConverterHelper.ToDataTable(griddata, "select * from fg_col_uireg"); ResponseResult result = proxy.SavePropertyUIInfo(dt); string response = JsonConvert.SerializeObject(result); return(response); } catch (Exception ex) { ResponseResult result = new ResponseResult(); result.Status = ResponseStatus.Error; result.Msg = ex.Message; string response = JsonConvert.SerializeObject(result); return(response); } }
public string SaveQueryInfo() { string helpid = System.Web.HttpContext.Current.Request.Params["helpid"]; string griddata = System.Web.HttpContext.Current.Request.Params["griddata"]; DataTable dt = DataConverterHelper.ToDataTable(griddata, "select code,definetype,tablename,field,fname_chn,operator,defaultdata,displayindex from fg_helpinfo_richquery"); int iret = proxy.SaveQueryInfo(dt, helpid, AppInfoBase.OCode, AppInfoBase.LoginID); ResponseResult result = new ResponseResult(); if (iret > 0) { result.Status = ResponseStatus.Success; } else { result.Status = ResponseStatus.Error; } string response = JsonConvert.SerializeObject(result); return(response); }
/// <summary> /// 注意,默认tab和设置是分别加载,一起保存 /// </summary> /// <returns></returns> public string SaveDefaultOpenTab() { string defaultOpenTab = System.Web.HttpContext.Current.Request.Form["defaultOpenTab"]; //string userid = System.Web.HttpContext.Current.Request.Form["userid"]; long userid = AppInfoBase.UserID; //保存默认tab页设置 DataTable defaultOpenTabTable = DataConverterHelper.ToDataTable(defaultOpenTab, "select * from fg3_defaultopen_tab"); int iret1 = proxy.SaveDefaultOpenTab(userid, defaultOpenTabTable); //保存系统设置 string individualSetting = System.Web.HttpContext.Current.Request.Form["individualSetting"]; bool iret2 = proxy.SaveSysSetting(userid, individualSetting); if (String.Compare(AppInfoBase.UserType, UserType.System, true) == 0) { //保存管理员权限下的路由设置和显示设置,注意这两个会改了数据库连接串,不再连0002 string ServerIpAndNetWorkIpConfig = System.Web.HttpContext.Current.Request.Form["ServerIpAndNetWorkIpConfig"]; string DisplaySetting = System.Web.HttpContext.Current.Request.Form["DisplaySetting"]; this.SaveServerIpAndNetWorkIpConfig(ServerIpAndNetWorkIpConfig); this.SaveDisplaySetting(DisplaySetting); } //保存小铃铛设置 string alertconfig = System.Web.HttpContext.Current.Request.Form["alertconfig"]; bool iret3 = proxy.SaveAlertItem(alertconfig); //bool iret3 = this.SaveAlertItem(alertconfig); //保存换肤设置 string uitheme = System.Web.HttpContext.Current.Request.Form["uitheme"]; int tempuitheme = 0; Int32.TryParse(uitheme.ToString(), out tempuitheme); bool iret4 = MenuConfigProxy.SaveUITheme(tempuitheme, userid); ////保存登陆单位信息 //string SSOOrgValue = System.Web.HttpContext.Current.Request.Form["SSOOrgValue"]; //proxy.SetSSOOrg(SSOOrgValue); //保存APP启动页Logo string APPlogo = System.Web.HttpContext.Current.Request.Form["APPlogo"]; string filePath = Request.PhysicalApplicationPath + "NG3Resource\\APPLogo\\" + APPlogo; bool iret5 = true; if (!string.IsNullOrEmpty(APPlogo) && System.IO.File.Exists(filePath)) { byte[] buffer; using (FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read)) { buffer = new byte[fs.Length]; fs.Read(buffer, 0, (int)fs.Length); } string attachid = proxy.GetAPPLogoAttachId(); try { if (string.IsNullOrEmpty(attachid)) { string result = NG3UploadFileService.NG3UploadEx("", buffer); JObject jo = (JObject)JsonConvert.DeserializeObject(result); if (jo["success"] != null && jo["success"].ToString() == "true") { attachid = jo["phid"].ToString(); } else { return("{status : \"error\", msg: \"APPLogo上传到附件出错\"}"); } } else { NG3UploadFileService.NG3ModifyEx("", long.Parse(attachid), buffer); } } catch { return("{status : \"error\", msg: \"APPLogo上传到附件出错\"}"); } iret5 = proxy.SaveAPPLogo(APPlogo, attachid); if (iret5) { string dirPath = Request.PhysicalApplicationPath + "NG3Resource\\APPLogo"; if (Directory.Exists(dirPath)) { Directory.Delete(dirPath, true); } } } if (iret1 >= 0 && iret2 && iret3 && iret4 && iret5) { return("{status : \"ok\"}"); } else { return("{status : \"error\"}"); } }
public string Save() { string masterId = System.Web.HttpContext.Current.Request.Form["masterid"]; string masterData = System.Web.HttpContext.Current.Request.Form["masterData"]; string detailData = System.Web.HttpContext.Current.Request.Form["detailData"]; string productData = System.Web.HttpContext.Current.Request.Form["productData"]; DataTable masterDt = new DataTable(); DataTable detailDt = new DataTable(); DataTable productDt = new DataTable(); if (!string.IsNullOrWhiteSpace(masterData)) { masterDt = DataConverterHelper.ToDataTable(masterData, "select * from fg3_qrcode_rule"); } if (!string.IsNullOrWhiteSpace(detailData)) { detailDt = DataConverterHelper.ToDataTable(detailData, "select * from fg3_qrcode_rule_detail"); } if (!string.IsNullOrWhiteSpace(productData)) { productDt = DataConverterHelper.ToDataTable(productData, "select * from fg_busiproduct"); } foreach (DataRow dr in masterDt.Rows) { if (dr.RowState == DataRowState.Deleted) { continue; } if (dr.RowState == DataRowState.Added) { dr["phid"] = masterId; productDt.Rows[0]["code"] = Guid.NewGuid().ToString(); } productDt.Rows[0]["busid"] = "fg3_qrcode_rule"; productDt.Rows[0]["busikey"] = masterId; } bool temp; long detailPhid = proxy.GetMaxID("fg3_qrcode_rule_detail", out temp); foreach (DataRow dr in detailDt.Rows) { if (dr.RowState == DataRowState.Deleted) { continue; } if (dr.RowState == DataRowState.Added) { dr["phid"] = ++detailPhid; dr["originalphid"] = masterId; } } ResponseResult result = new ResponseResult(); try { result = proxy.Save(masterId, masterDt, detailDt, productDt); } catch (Exception ex) { result.Status = "error"; result.Msg = ex.Message.ToString(); } string response = JsonConvert.SerializeObject(result); return(response); }
public string BuildQRCode() { try { string masterData = System.Web.HttpContext.Current.Request.Form["masterData"]; DataTable masterDt = new DataTable(); if (!string.IsNullOrWhiteSpace(masterData)) { masterDt = DataConverterHelper.ToDataTable(masterData, "select * from fg3_qrcode_style"); string imgName = proxy.GetImgName(); string strPath = "NG3Resource\\QRCodeLogo\\" + imgName; string dirPath = Request.PhysicalApplicationPath + strPath; int imgsize = 0; int.TryParse(masterDt.Rows[0]["imgsize"].ToString(), out imgsize); Color BackC; Color ForeC; switch (masterDt.Rows[0]["backcolor"].ToString()) { case "1": BackC = Color.White; break; case "2": BackC = Color.PowderBlue; break; case "3": BackC = Color.NavajoWhite; break; case "4": BackC = Color.LightGray; break; default: BackC = Color.White; break; } switch (masterDt.Rows[0]["frontcolor"].ToString()) { case "1": ForeC = Color.Black; break; case "2": ForeC = Color.DodgerBlue; break; case "3": ForeC = Color.Maroon; break; case "4": ForeC = Color.DarkOrange; break; default: ForeC = Color.Black; break; } Bitmap bitmap = Generate3(dirPath, masterDt.Rows[0]["content"].ToString(), imgsize, imgsize, masterDt.Rows[0]["addLogo"].ToString(), BackC, ForeC); strPath = "NG3Resource\\QRCodeLogo\\qrcode.png"; dirPath = Request.PhysicalApplicationPath + strPath; bitmap.Save(dirPath, System.Drawing.Imaging.ImageFormat.Png); return("true"); } else { return(""); } } catch (Exception ex) { throw new Exception(ex.Message); } }