public string CheckResource(string sysIdString, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
Eva.Library.Data.AccessData.IAccessData _iAccessData = Eva.Library.Data.AccessData.AccessDataFactory.CreateDataAccess(DataBaseType.oracledal, Eva.Library.Configuration.ConfigurationManager.AppSettings["DataBaseConnectionString"].ToString());
string maxSize = "500000";
string titleString = "";
string contentString = "";
string sqlString = "";
sqlString += " select wm_concat(replace(filerealname, ' ', ',')) from tbl_file_content where menuid in ";
sqlString += " (";
sqlString += " select f_titleresource from tbl_app_news where sys_id = '" + sysIdString + "'";
sqlString += " )";
sqlString += " and filesize > " + maxSize;
object o = _iAccessData.GetSingle(sqlString);
if (o != null)
{
if (o.ToString() != "")
{
titleString = o.ToString();
}
}
sqlString = "";
sqlString += " select wm_concat(replace(filerealname, ' ', ',')) from tbl_file_content where menuid in ";
sqlString += " (";
sqlString += " select f_contentresource from tbl_app_news where sys_id = '" + sysIdString + "'";
sqlString += " )";
sqlString += " and filesize > " + maxSize;
o = _iAccessData.GetSingle(sqlString);
if (o != null)
{
if (o.ToString() != "")
{
contentString = o.ToString();
}
}
string result = "{\"title\":\"" + titleString + "\",\"content\":\"" + contentString + "\"}";
resultDic["result"] = "true";
resultDic["message"] = result;
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
NewLog("查询Tags：异常信息：" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_select", clientInf);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string GetShpidString(string sysIdString, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
string shpidString = "";
string sqlString = " select distinct(m.shpid) from tbl_maintable m,up_shape_dl s";
sqlString += " where m.shpid = s.sys_shpid";
sqlString += " and m.sys_id = '" + sysIdString + "'";
Eva.Library.Data.AccessData.IAccessData _iAccessData = commonclass.commonclass.CreateIAccessData();
object o = _iAccessData.GetSingle(sqlString);
if (o != null)
{
shpidString = o.ToString();
}
resultDic["result"] = "true";
resultDic["message"] = shpidString;
NewLog("shpid查询成功，sys_id为：" + sysIdString, "sql_select", clientInf);
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
NewLog("shpid查询成功，sys_id为：" + sysIdString + "，异常信息：" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_select", clientInf);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string Export(string whereString, string orderByString, string column, string columnname, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
_iAccessData = sara.dd.ldsw.commonclass.commonclass.CreateIAccessData();
try
{
IDictionary <string, string> clientInfoDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf);
//string sql = "select " + column;
//sql += " from tbl_ld_jmb";
//sql += " where" + whereString + "";
//DataTable dt = _iAccessData.Query(sql).Tables[0];
DataTable dt = _idal_tbl_ld_jmb.GetDataTableForPC(whereString, orderByString, column, "", "", null);
string file = report.ReportExcel(dt, column, columnname);
resultDic["result"] = "true";
resultDic["message"] = file;
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string CreatExcelBySqlAppcode(string sqlStr, string appcodeStr)
{
_iAccessData = Eva.Library.Data.AccessData.AccessDataFactory.CreateDataAccess(DataBaseType.oracledal, Eva.Library.Configuration.ConfigurationManager.AppSettings["DataBaseConnectString_" + appcodeStr].ToString());
DataSet ds = _iAccessData.Query((sqlStr));
return(sara.dd.ldsw.commonclass.commonclass.CreatExcelByDataTable(ds.Tables[0]));
}
public string CheckFileSize(string menuids, string fileMaxSize)
{
_iAccessData = commonclass.commonclass.CreateIAccessData();
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
DataSet dsFile = _iAccessData.Query("select * from tbl_file_content where menuid in ('" + menuids.Replace("^", "','") + "')");
string message = "";
for (int i = 0; i < dsFile.Tables[0].Rows.Count; i++)
{
if (Eva.Library.Text.NumberTool.Parse(dsFile.Tables[0].Rows[i]["filesize"].ToString()) > Eva.Library.Text.NumberTool.Parse(fileMaxSize))
{
message += "【" + dsFile.Tables[0].Rows[i]["filerealname"].ToString() + "】文件大于" + fileMaxSize + "，请注意修改<br/>";
}
}
resultDic["result"] = "true";
resultDic["message"] = message;
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string AddListByTitleResource(string json, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
sara.dd.ldsw.model.tbl_app_news_content model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_app_news_content>(json);
Eva.Library.Data.AccessData.IAccessData iAccessData = Eva.Library.Data.AccessData.AccessDataFactory.CreateDataAccess(DataBaseType.oracledal, Eva.Library.Configuration.ConfigurationManager.AppSettings["DataBaseConnectionString"].ToString());
DataSet ds = iAccessData.Query("select * from tbl_file_content where menuid in (select f_contentresource from tbl_app_news where sys_id='" + model.fk_tbl_app_news_sys_id + "')");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model.sys_id = 0;
model.f_mediaurl = ds.Tables[0].Rows[i]["FILEUPLOADNAME"].ToString();
_idal_tbl_app_news_content.Add(model, null);
}
resultDic["result"] = "true";
resultDic["message"] = "";
NewLog("数据创建成功，创建的数据为：" + json, "sql_insert", clientInf);
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
NewLog("数据创建失败，创建的数据为：" + json + "，异常信息：" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_insert", clientInf);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string Update(string json, string columns, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
_iAccessData = sara.dd.ldsw.commonclass.commonclass.CreateIAccessData();
sara.dd.ldsw.model.tbl_ldbm_expdata model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ldbm_expdata>(json);
model.sys_lasteditdate = DateTime.Now;
columns = FormatColumns(columns).Replace("^", ",");
if (model.f_khbh != "")
{
string sql = "select wm_concat(sys_id) from tbl_ld_khb where f_khbh in (" + model.f_khbh + ")";
model.f_khbhid = _iAccessData.GetSingle(sql).ToString();
}
else
{
model.f_khbhid = "";
}
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ldbm_expdata.Update(model, columns, null);
NewLog("数据更新成功，更新的数据为：json：" + json + "，columns：" + columns, "sql_update", clientInf);
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
NewLog("数据更新失败，更新的数据为：json：" + json + "，columns：" + columns + "，异常信息：" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_update", clientInf);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string AddAndroidAppLog(string message, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
_iAccessData = commonclass.commonclass.CreateIAccessData();
if (message.Length > 2100)
{
message = message.Substring(message.Length - 2100);
}
string sqlString = "insert into TBL_ANDROIDAPP_LOG (sys_id, message, clientinfo, sys_creatdate, value1, value2, value3, value4, value5)";
sqlString += "values ((select nvl(max(sys_id),0)+1 from TBL_ANDROIDAPP_LOG), '" + message + "', '" + clientInf + "', sysdate, '', '', '', '', '')";
_iAccessData.ExecuteSql(sqlString);
resultDic["result"] = "true";
resultDic["message"] = "";
}
catch (Exception ex)
{
resultDic["result"] = "error";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string GetUserLoginNameCount(string userLoginNameString, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
IDictionary <String, String> userInfDic = commonclass.commonclass.CheckClientInf(clientInf);
if (userInfDic == null)
{
resultDic["result"] = "false";
resultDic["message"] = "客户端信息错误";
}
else
{
Eva.Library.Data.AccessData.IAccessData ia = commonclass.commonclass.CreateIAccessData();
string sql = "select count(*) from t_user where u_code = '" + userLoginNameString + "'";
string count = ia.GetSingle(sql).ToString();
resultDic["result"] = "true";
resultDic["message"] = count;
}
}
catch (Exception ex)
{
resultDic["result"] = "error";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string Export(string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
Eva.Library.Data.AccessData.IAccessData _iAccessData = sara.dd.ldsw.commonclass.commonclass.CreateIAccessData();
string sqlstr = "select f_htmlname,f_htmlversion from tbl_app_version_html order by f_htmlname";
DataTable dt = new DataTable();
StringBuilder result = new StringBuilder(@"<?xml version=#1.0# encoding=#UTF-8#?>" + System.Environment.NewLine + "<!DOCTYPE plist PUBLIC #-//Apple//DTD PLIST 1.0//EN# #http://www.apple.com/DTDs/PropertyList-1.0.dtd#>" + System.Environment.NewLine + "<plist version=#1.0#>" + System.Environment.NewLine + "<dict>" + System.Environment.NewLine);
try
{
dt = _iAccessData.Query(sqlstr).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
result.Append("<key>" + dt.Rows[i]["f_htmlname"].ToString() + "</key>" + System.Environment.NewLine + "<string>" + dt.Rows[i]["f_htmlversion"].ToString() + "</string>" + System.Environment.NewLine);
}
result.Append("</dict>" + System.Environment.NewLine + "</plist>");
result.Replace('#', '"');
string downloadPath = Eva.Library.Format.FormatTextTool.GetMapPath((Eva.Library.Configuration.ConfigurationManager.AppSettings["AppResourceRootPath"] + "html/html.plist"), HttpContext.Current.Server);
sara.dd.ldsw.commonclass.FileOperation.writeFile(downloadPath, result.ToString());
resultDic["message"] = Eva.Library.Configuration.ConfigurationManager.AppSettings["AppResourceRootPath"] + "html/html.plist";
resultDic["result"] = "true";
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string getLogListByMaintableSysId(string maintable_sys_id, string orderByString, string pageSizeString, string pageIndexString, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
try
{
resultDic["result"] = "true";
Eva.Library.Data.AccessData.IAccessData _ia = commonclass.commonclass.CreateIAccessData();
string sql = "select sys_projectclassid from tbl_maintable where sys_id='" + maintable_sys_id + "'";
string sys_projclassid = _ia.GetSingle(sql).ToString();
string selectStr = "select sys_creatdate,sys_id,sys_flag,value1,value2,value3,value4,value5,businessname,businessid,processsinsid,processdefid,workflowid,";
selectStr += " sys_creatusername,";
selectStr += " sys_creatuserid,";
selectStr += " (select value1 from t_projclass_dtl1 where projclassid='" + sys_projclassid + "' and projstate =fromstate )as fromstate,";
selectStr += " (select value1 from t_projclass_dtl1 where projclassid='" + sys_projclassid + "' and projstate =tostate )as tostate ,";
selectStr += " remark";
selectStr += " from t_projstate_log t where businessid='" + maintable_sys_id + "'";
string countSql = "select count(*) from t_projstate_log where businessid='" + maintable_sys_id + "'";
string count = _ia.GetSingle(countSql).ToString();
if (orderByString != "")
{
selectStr += " order by " + orderByString;
}
else
{
selectStr += " order by sys_creatdate asc";
}
if (pageSizeString != "" && pageIndexString != "")
{
int startindex = (int.Parse(pageIndexString) - 1) * int.Parse(pageSizeString);
int endindex = int.Parse(pageIndexString) * int.Parse(pageSizeString);
selectStr = "select * from (select rownum rn,tt.* from(" + selectStr + ") tt) where rn<=" + endindex + " and rn>" + startindex + "";
}
DataSet ds = _ia.Query(selectStr);
string rows = "";
if (ds.Tables.Count > 0)
{
rows = Eva.Library.Format.FormatEntityTool.FormatDataTableToJson(ds.Tables[0]);
}
else
{
rows = "[]";
}
string message = "{\"total\":\"" + count + "\",\"rows\":" + rows + "}";
//code-less为了程序能过，暂时处理，需要修改
message = message.Replace("\r", "").Replace("\n", "");
resultDic["message"] = message;
}
catch (Exception e)
{
resultDic["result"] = "false";
resultDic["messaget"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(e.Message);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string GetCodeResource(string appVersionString, string codeVersionString, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
IDictionary <String, String> userInfDic = commonclass.commonclass.CheckClientInf(clientInf);
if (userInfDic == null)
{
resultDic["result"] = "false";
resultDic["message"] = "客户端信息错误";
}
else
{
string currentVersion = "1.0.1";
#region 读取最新版本号
_iAccessData = commonclass.commonclass.CreateIAccessData();
string sqlString = "select f_codeversion from tbl_app_version where f_apptypeid = '" + userInfDic["devicetype"] + "' and f_appversion = '" + appVersionString + "'";
object o = _iAccessData.GetSingle(sqlString);
if (o != null)
{
currentVersion = o.ToString();
}
#endregion
if (currentVersion != codeVersionString)
{
Dictionary <string, string> htmlResourceDic = new Dictionary <string, string>();
htmlResourceDic["version"] = currentVersion;
htmlResourceDic["content"] = Eva.Library.Format.FormatEntityTool.FormatDicToJson(GetCode("sara.dd.ldsw"));
string htmlResourceString = Eva.Library.Format.FormatEntityTool.FormatDicToJson(htmlResourceDic);
resultDic["result"] = "true";
resultDic["message"] = htmlResourceString;
}
else
{
Dictionary <string, string> htmlResourceDic = new Dictionary <string, string>();
htmlResourceDic["version"] = currentVersion;
htmlResourceDic["content"] = "";
string htmlResourceString = Eva.Library.Format.FormatEntityTool.FormatDicToJson(htmlResourceDic);
resultDic["result"] = "true";
resultDic["message"] = htmlResourceString;
}
}
}
catch (Exception ex)
{
resultDic["result"] = "error";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string Delete(string whereString, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
//删除附件的功能
string fileIDs = "";
string columnsString = "";
columnsString += "f_drwj,";
columnsString += "f_bcfj,";
columnsString += "f_lcfj,";
columnsString = columnsString.TrimEnd(',');
List <sara.dd.ldsw.model.tbl_ld_xgsbds> l_tbl_ld_xgsbds = _idal_tbl_ld_xgsbds.GetList(whereString, "", columnsString, "", "", null);
foreach (sara.dd.ldsw.model.tbl_ld_xgsbds model in l_tbl_ld_xgsbds)
{
fileIDs += model.f_drwj + ",";
fileIDs += model.f_bcfj + ",";
fileIDs += model.f_lcfj + ",";
}
fileIDs = fileIDs.TrimEnd(',');
sara.dd.ldsw.commonclass.filecontrol.deleteByFileName(fileIDs, null);
//删除子表的方法
_iAccessData = sara.dd.ldsw.commonclass.commonclass.CreateIAccessData();
string sqlString = "";
sqlString = "delete from tbl_ld_xgsbdszb where fk_tbl_ld_xgsbds_sys_id in (select sys_id from tbl_ld_xgsbds where " + whereString + ")";
_iAccessData.ExecuteSql(sqlString);
//加入删除子表附件文件的方法
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ld_xgsbds.Delete(whereString, null);
NewLog("数据删除成功，删除的数据条件为：" + whereString, "sql_delete", clientInf);
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
NewLog("数据删除失败，删除的数据条件为：" + whereString + "，异常信息：" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_delete", clientInf);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string Delete(string whereString, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
_iAccessData = sara.dd.ldsw.commonclass.commonclass.CreateIAccessData();
//删除附件的功能
//删除子表的方法
//加入删除子表附件文件的方法
string sql = "select f_yslxid,f_dyid,sys_id from tbl_ldbm_jtsj where " + whereString + "";
DataTable dt = _iAccessData.Query(sql).Tables[0];
ArrayList list = new ArrayList();
for (int i = 0; i < dt.Rows.Count; i++)
{
string yslxid = dt.Rows[i]["f_yslxid"].ToString();
string dyid = dt.Rows[i]["f_dyid"].ToString();
string sys_id = dt.Rows[i]["sys_id"].ToString();
string arraySql = "select count(*) as count from tbl_ld_khb where f_yslxid =(select f_yslxid from tbl_ldbm_jtsj where sys_id =" + sys_id + ") and f_dyid =(select f_dyid from tbl_ldbm_jtsj where sys_id =" + sys_id + ") and f_ztid = '0' and sys_delflag = '0'";
string count = _iAccessData.GetSingle(arraySql).ToString();
if (count != "0")
{
//存不可以删除的sys_id
list.Add(sys_id);
}
else
{
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ldbm_jtsj.Delete(whereString, null);
NewLog("数据删除成功，删除的数据条件为：" + whereString, "sql_delete", clientInf);
}
}
if (list.Count != 0)
{
string str = string.Join(",", list.ToArray());
resultDic["result"] = "false";
resultDic["message"] = "有用户正在使用该阶梯水价，不可以删除sys_id为" + str + "的阶梯水价";
}
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
NewLog("数据删除失败，删除的数据条件为：" + whereString + "，异常信息：" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_delete", clientInf);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string GetQueryCopyResult(string whereString, string orderByString, string columnsString, string pageSizeString, string pageIndexString, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
columnsString = FormatColumns(columnsString).Replace("^", ",");
string sqlTemp = "";
DataSet ds = new DataSet();
DataSet dsTemp = new DataSet();
Eva.Library.Data.AccessData.IAccessData _ia = commonclass.commonclass.CreateIAccessData();
string sql = "";
sql = "select " + columnsString + " from (select rownum rn,a.* from (select * from tbl_maintable where ";
if (whereString.Trim() == "")
{
sql += " 1=1 ";
}
else
{
sql += whereString;
}
sql += " order by " + orderByString;
sql += ") a ) b";
sqlTemp = sql;
if (pageSizeString != "" && pageSizeString != null && pageIndexString != "" && pageIndexString != null)
{
int fromInt = int.Parse(pageSizeString) * (int.Parse(pageIndexString) - 1) + 1;
int toInt = (int.Parse(pageSizeString) * (int.Parse(pageIndexString)));
sql += " where b.rn>='" + fromInt.ToString() + "' and b.rn <='" + toInt.ToString() + "' ";
}
ds = _ia.Query(sql);
dsTemp = _ia.Query(sqlTemp);
string rows = Eva.Library.Format.FormatEntityTool.FormatDataTableToJson(ds.Tables[0]);
string message = "{\"total\":\"" + dsTemp.Tables[0].Rows.Count + "\",\"rows\":" + rows + "}";
resultDic["message"] = message;
resultDic["result"] = "true";
NewLog("数据查询成功，查询的数据条件为：whereString：" + whereString + "，orderByString：" + orderByString + "，columnsString：" + columnsString + "，pageSizeString：" + pageSizeString + "，pageIndexString：" + pageIndexString + "", "sql_select", clientInf);
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
NewLog("数据查询失败，查询的数据条件为：whereString：" + whereString + "，orderByString：" + orderByString + "，columnsString：" + columnsString + "，pageSizeString：" + pageSizeString + "，pageIndexString：" + pageIndexString + "，异常信息：" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_select", clientInf);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
protected void Application_Start(object sender, EventArgs e)
{
try
{
HttpContext HttpCurrent = HttpContext.Current;
if (HttpCurrent != null)
{
Eva.Library.Global.AppRootPath = HttpCurrent.Server.MapPath("~");
}
else
{
Eva.Library.Global.AppRootPath = AppDomain.CurrentDomain.BaseDirectory;
if (Regex.Match(Eva.Library.Global.AppRootPath, @"\\$", RegexOptions.Compiled).Success)
{
Eva.Library.Global.AppRootPath = Eva.Library.Global.AppRootPath.Substring(0, Eva.Library.Global.AppRootPath.Length - 1);
}
}
Eva.Library.Global.AppRootPath = Eva.Library.Global.AppRootPath + "\\";
Eva.Library.Global.ConfigFileName = System.Configuration.ConfigurationManager.AppSettings["ConfigFileName"].ToString();
//2016-01-15---token
_iAccessData = commonclass.commonclass.CreateIAccessData();
_dt_token_function_istoken = _iAccessData.Query("select f_function,f_service from t_token_function where sys_delflag='0' and f_istoken='false'").Tables[0];
_dt_token_function_isencrypt = _iAccessData.Query("select f_function,f_service from t_token_function where sys_delflag='0' and f_isencrypt='false'").Tables[0];
_dt_token_function_islock = _iAccessData.Query("select f_function,f_service,f_value10 from t_token_function where sys_delflag='0' and f_value10 is not null").Tables[0];
ConfigAppName = System.Configuration.ConfigurationManager.AppSettings["EasyFrameConfigName"].ToString();
ConfigAppCode = Eva.Library.Configuration.ConfigurationManager.AppSettings["AppCode"].ToString();
ConfigDefaultTokenId = Eva.Library.Configuration.ConfigurationManager.AppSettings["DefaultTokenId"].ToString();
ConfigWebServiceCollect = Eva.Library.Configuration.ConfigurationManager.AppSettings["WebServiceCollect"].ToString();
ConfigWebServiceEncrypt = Eva.Library.Configuration.ConfigurationManager.AppSettings["WebServiceEncrypt"].ToString();
ConfigWebServiceLock = Eva.Library.Configuration.ConfigurationManager.AppSettings["WebServiceLock"].ToString();
ConfigWebServiceToken = Eva.Library.Configuration.ConfigurationManager.AppSettings["WebServiceToken"].ToString();
//2016-01-15---log
if (_ilog == null)
{
_ilog = Eva.Library.Log.LogFactory.CreateLogBySchemaName(Eva.Library.Global.AppRootPath + Eva.Library.Global.ConfigFileName, "54");
}
}
catch
{
}
}
/// <summary>
/// 验证是不是能启动流程
/// </summary>
/// <param name="sys_ids"></param>
/// <param name="str_facterid"></param>
/// <param name="ds_facter"></param>
/// <param name="str_resultmessage"></param>
/// <param name="clientInf"></param>
/// <param name="userInfoJsonString"></param>
/// <returns></returns>
public string get_startworkflow(string sys_ids, string str_facterid, DataSet ds_facter, ref string str_resultmessage, string clientInf, string userInfoJsonString)
{
string result = "";
try
{
Eva.Library.ServiceAdapter.IAdapter.IWorkFlow w = Eva.Library.ServiceAdapter.AdapterFactory.WorkFlowFactory.CreateService(Eva.Library.Configuration.ConfigurationManager.AppSettings["AppCode"]);
string lcdyid = _cc.GetWorkFlowLCDYID(str_facterid, ds_facter, clientInf, userInfoJsonString);
DataSet ds;
if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll")
{
ds = sara.platform.service.workflow.Service.GetUserOperationStartByDylcid(lcdyid);
}
else
{
ds = w.GetUserOperationStartByDylcid(lcdyid);
}
#region businesscode
//businesscode
//在此处添加针对projclassid = 3的业务代码
_iAccessData = sara.dd.ldsw.commonclass.commonclass.CreateIAccessData();
string sql = "select count(*) from tbl_ld_xhhbtzb where fk_tbl_ld_xhhbt_sys_id = (select sys_id from tbl_ld_xhhbt where fk_tbl_maintable_sys_id='" + sys_ids + "') and f_khbh is null";
string count = "0";
object o = _iAccessData.GetSingle(sql);
if (o != null)
{
count = o.ToString();
}
string total = "0";
sql = "select count(*) from tbl_ld_xhhbtzb where fk_tbl_ld_xhhbt_sys_id = (select sys_id from tbl_ld_xhhbt where fk_tbl_maintable_sys_id='" + sys_ids + "')";
object res = _iAccessData.GetSingle(sql);
if (res != null)
{
total = res.ToString();
}
if (count != "0" || total == "0")
{
result = "请先选定客户在进行操作";
}
#endregion
str_resultmessage = Eva.Library.Format.FormatEntityTool.FormatDataTableToJson(ds.Tables[0]);
}
catch (Exception ex)
{
result = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(result);
}
public string GetHtmlResource(string appVersionString, string htmlVersionString, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
IDictionary <String, String> userInfDic = commonclass.commonclass.CheckClientInf(clientInf);
if (userInfDic == null)
{
resultDic["result"] = "false";
resultDic["message"] = "客户端信息错误";
}
else
{
string currentVersion = "1.0.0";
_iAccessData = commonclass.commonclass.CreateIAccessData();
string sqlString = "select f_htmlversion from tbl_app_version where f_apptypeid = '" + userInfDic["devicetype"] + "' and f_appversion = '" + appVersionString + "'";
DataSet ds = _iAccessData.Query(sqlString);
if (ds.Tables[0].Rows.Count > 0)
{
currentVersion = ds.Tables[0].Rows[0]["f_htmlversion"].ToString();
}
if (currentVersion != htmlVersionString)
{
resultDic["result"] = "true";
resultDic["message"] = currentVersion;//版本号不一致，需要客户端调用下边方法，验证是哪个文件不一致
}
else
{
resultDic["result"] = "true";
resultDic["message"] = "true";//版本号一致
}
}
}
catch (Exception ex)
{
resultDic["result"] = "error";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string QuerySqlsByAppcode(string sqlStringJson, string appcodeStr, string isShowAll)
{
_iAccessData = Eva.Library.Data.AccessData.AccessDataFactory.CreateDataAccess(DataBaseType.oracledal, Eva.Library.Configuration.ConfigurationManager.AppSettings["DataBaseConnectString_" + appcodeStr].ToString());
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
string message = "";
try
{
IDictionary <string, string> sqlStringDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(sqlStringJson);
DataSet ds = null;
foreach (string key in sqlStringDic.Keys)
{
string sql = sqlStringDic[key];
if (isShowAll != "true")
{
sql = "select * from (" + (sql) + ") where rownum<1001";
}
ds = _iAccessData.Query(Eva.Library.Format.FormatTextTool.FormatSqlStrWidthIn1000(sql));
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
message += "\"" + key + "\":" + Eva.Library.Format.FormatEntityTool.FormatDataTableToJson(ds.Tables[0]) + ",";
}
else
{
message += "\"" + key + "\":" + "[]" + ",";
}
}
resultDic["result"] = "true";
resultDic["message"] = "{" + message.TrimEnd(',') + "}";
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string AddList(string json, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
_iAccessData = commonclass.commonclass.CreateIAccessData();
try
{
//从t_user表读取f_value6(设备类型)，f_value7(推送证书)，f_value8(设备ID)
List <sara.dd.ldsw.model.tbl_app_pushnotification> modellist = Eva.Library.Format.FormatEntityTool.FormatJsonToModelList <sara.dd.ldsw.model.tbl_app_pushnotification>(json);
string useridString = "";
for (int i = 0; i < modellist.Count; i++)
{
useridString += modellist[i].f_recive_userid + ",";
}
string sqlString = "select u_id,u_name,f_value6,f_value7,f_value8 from t_user where u_state = '1' and u_id in ('" + useridString.TrimEnd(',').Replace(",", "','") + "')";
DataTable dt = _iAccessData.Query(sqlString).Tables[0];
DataRow[] dr = null;
for (int i = 0; i < modellist.Count; i++)
{
dr = dt.Select("u_id = '" + modellist[i].f_recive_userid + "'");
if (dr.Length > 0)
{
modellist[i].f_recive_devicetype = dr[0]["f_value6"].ToString();
modellist[i].f_recive_devicetypeid = dr[0]["f_value6"].ToString();
modellist[i].f_recive_deviceid = dr[0]["f_value8"].ToString();
//modellist[i].f_recive_certificate = dr[0]["f_value7"].ToString();
}
}
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_app_pushnotification.AddList(modellist, null);
NewLog("数据创建成功，创建的数据为：" + json, "sql_insert", clientInf);
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
NewLog("数据创建失败，创建的数据为：" + json + "，异常信息：" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_insert", clientInf);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string Delete(string whereString, string clientInf)
{
_iAccessData = sara.dd.ldsw.commonclass.commonclass.CreateIAccessData();
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
//删除附件的功能
//删除子表的方法
//加入删除子表附件文件的方法
string sql = "";
sql += " select count(*) from tbl_ld_yhb";
sql += " where (f_dyid is not null and f_dyid in (select sys_id from tbl_ldbm_dycq where " + whereString + "))";
sql += " or(f_scid is not null and f_scid in(select sys_id from tbl_ldbm_dycq where " + whereString + "))";
sql += " or(f_qyid is not null and f_qyid in(select sys_id from tbl_ldbm_dycq where " + whereString + "))";
sql += " or(f_pqid is not null and f_pqid in(select sys_id from tbl_ldbm_dycq where " + whereString + "))";
string count = _iAccessData.GetSingle(sql).ToString();
if (count != "0")
{
resultDic["result"] = "false";
resultDic["message"] = "您所选定的信息，在用户表中存在引用，所以不能删除。";
}
else
{
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ldbm_dycq.Delete(whereString, null);
NewLog("数据删除成功，删除的数据条件为：" + whereString, "sql_delete", clientInf);
}
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
NewLog("数据删除失败，删除的数据条件为：" + whereString + "，异常信息：" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_delete", clientInf);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string GetTags(string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
Eva.Library.Data.AccessData.IAccessData _iAccessData = Eva.Library.Data.AccessData.AccessDataFactory.CreateDataAccess(DataBaseType.oracledal, Eva.Library.Configuration.ConfigurationManager.AppSettings["DataBaseConnectionString"].ToString());
string re = _iAccessData.GetSingle("select wm_concat(replace(f_tag,' ',',')) from tbl_app_news ").ToString();
List <string> l_re = re.Split(',').ToList();
List <string> l_result = new List <string>();
string result = "";
for (int i = 0; i < l_re.Count; i++)
{
if (!l_result.Contains(l_re[i]))
{
l_result.Add(l_re[i]);
}
}
for (int i = 0; i < l_result.Count; i++)
{
result += l_result[i] + "^";
}
result = result.Trim('^');
resultDic["result"] = "true";
resultDic["message"] = result;
NewLog("查询Tags：", "sql_select", clientInf);
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
NewLog("查询Tags：异常信息：" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_select", clientInf);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string IsCanRollBack(string sys_id, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
string sql = "";
string count = "";
try
{
_iAccessData = sara.dd.ldsw.commonclass.commonclass.CreateIAccessData();
sql = "select count(*) from tbl_ld_pgb where sys_id > '" + sys_id + "' and f_value1 = (select f_value1 from tbl_ld_pgb where sys_id = '" + sys_id + "') and f_ztid='1'";
count = _iAccessData.GetSingle(sql).ToString();
if (count != "0")
{
resultDic["result"] = "true";
resultDic["message"] = "false";
}
else
{
sql = "select count(*) from tbl_ld_cbiao where f_pgbhid='" + sys_id + "'and f_ztid!='2'";
count = _iAccessData.GetSingle(sql).ToString();
if (count != "0")
{
resultDic["result"] = "true";
resultDic["message"] = "false";
}
else
{
resultDic["result"] = "true";
resultDic["message"] = "true";
}
}
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string UpdateStatus(string notificationIdsString, string userIdString, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
IDictionary <String, String> userInfDic = commonclass.commonclass.CheckClientInf(clientInf);
if (userInfDic == null)
{
resultDic["result"] = "false";
resultDic["message"] = "客户端信息错误";
}
else
{
_iAccessData = commonclass.commonclass.CreateIAccessData();
string sqlString = "";
if (notificationIdsString != "-1")
{
sqlString = "update tbl_app_pushnotification set f_statusid = '2' , f_status = '已接受' where sys_id in ('" + notificationIdsString.Replace("^", "','") + "')";
}
else
{
sqlString = "update tbl_app_pushnotification set f_statusid = '2' , f_status = '已接受' where f_recive_userid = '" + userIdString + "'";
}
_iAccessData.ExecuteSql(sqlString);
string count = _idal_tbl_app_pushnotification.GetCount(" f_recive_userid = '" + userIdString + "' and f_statusid = '1'", null);
resultDic["result"] = "true";
resultDic["message"] = count;
}
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string getXmmcByMaintableSysId(string maintable_sys_id)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
try
{
resultDic["result"] = "true";
Eva.Library.Data.AccessData.IAccessData _ia = commonclass.commonclass.CreateIAccessData();
string sql = "select xmmc from tbl_maintable where sys_id='" + maintable_sys_id + "'";
string xmmc = _ia.GetSingle(sql).ToString();
resultDic["message"] = xmmc;
}
catch (Exception e)
{
resultDic["result"] = "false";
resultDic["messaget"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(e.Message);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string QuerySqls(string sqlStringJson)
{
_iAccessData = commonclass.commonclass.CreateIAccessData();
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
string message = "";
try
{
IDictionary <string, string> sqlStringDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(sqlStringJson);
DataSet ds = null;
foreach (string key in sqlStringDic.Keys)
{
ds = _iAccessData.Query((sqlStringDic[key].ToString()));
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
message += "\"" + key + "\":" + Eva.Library.Format.FormatEntityTool.FormatDataTableToJson(ds.Tables[0]) + ",";
}
else
{
message += "\"" + key + "\":" + "[]" + ",";
}
}
resultDic["result"] = "true";
resultDic["message"] = "{" + message.TrimEnd(',') + "}";
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string UpdateUserPassword(string userLoginNameString, string newPassword, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
IDictionary <String, String> userInfDic = commonclass.commonclass.CheckClientInf(clientInf);
if (userInfDic == null)
{
resultDic["result"] = "false";
resultDic["message"] = "客户端信息错误";
}
else
{
string sql = "update t_user set u_pwd = '" + sara.platform.service.auth.Service.PassWordEncrypt(newPassword) + "' where u_code = '" + userLoginNameString + "'";
_iAccessData = commonclass.commonclass.CreateIAccessData();
if (_iAccessData.ExecuteSql(sql) > 0)
{
resultDic["result"] = "true";
resultDic["message"] = "密码修改成功";
}
else
{
resultDic["result"] = "false";
resultDic["message"] = "密码修改失败";
}
}
}
catch (Exception ex)
{
resultDic["result"] = "error";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string GetSingleSqls(string sqlStringJson)
{
_iAccessData = commonclass.commonclass.CreateIAccessData();
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
string message = "";
try
{
IDictionary <string, string> sqlStringDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(sqlStringJson);
foreach (string key in sqlStringDic.Keys)
{
object o = _iAccessData.GetSingle((sqlStringDic[key].ToString()));
if (o != null)
{
//发现少引号，怀疑是bug--sk
message += "\"" + key + "\":\"" + o.ToString() + "\",";
}
else
{
//发现少引号，怀疑是bug--sk
message += "\"" + key + "\":\"" + "" + "\",";
}
}
resultDic["result"] = "true";
resultDic["message"] = "{" + message.TrimEnd(',') + "}";
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string GetAppStatus(string appVersionString, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
IDictionary <String, String> userInfDic = commonclass.commonclass.CheckClientInf(clientInf);
if (userInfDic == null)
{
resultDic["result"] = "false";
resultDic["message"] = "客户端信息错误";
}
else
{
string currentVersion = "-1";
_iAccessData = commonclass.commonclass.CreateIAccessData();
string sqlString = "select f_appstatusid from tbl_app_version where f_apptypeid = '" + userInfDic["devicetype"] + "' and f_appversion = '" + appVersionString + "'";
object o = _iAccessData.GetSingle(sqlString);
if (o != null)
{
currentVersion = o.ToString();
}
resultDic["result"] = "true";
resultDic["message"] = currentVersion;
}
}
catch (Exception ex)
{
resultDic["result"] = "error";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public static string GetFilesJsonArrayByFileId(string fileID)
{
Eva.Library.Data.AccessData.IAccessData _iAccessData = commonclass.CreateIAccessData();
string sqlString = "select * from tbl_file_content where menuid = '" + fileID + "'";
string ShpFileUpLoadRootPath = Eva.Library.Configuration.ConfigurationManager.AppSettings["ShpFileUpLoadRootPath"].ToString().Replace("http://", "");
DataSet ds = _iAccessData.Query(sqlString);
IList <IDictionary <string, string> > resultDicList = new List <IDictionary <string, string> >();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Dictionary <string, string> a = new Dictionary <string, string>();
a["filerealname"] = ds.Tables[0].Rows[i]["filerealname"].ToString();
a["fileuploadname"] = ShpFileUpLoadRootPath + ds.Tables[0].Rows[i]["fileuploadname"].ToString();
resultDicList.Add(a);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicListToJson(resultDicList));
}
