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