/// <summary>
/// 得到最大ID
/// </summary>
public string GetMaxId(Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
string sqlString = "update tbl_num set f_tablesys_id = ";
sqlString += " (select to_number(f_tablesys_id)+1 from tbl_num where f_tablename = 'tbl_ld_cben')";
sqlString += " where f_tablename = 'tbl_ld_cben'";
if (t == null)
{
_iAccessData.ExecuteSql(sqlString);
}
else
{
t.ExecuteSql(sqlString);
}
sqlString = "select f_tablesys_id from tbl_num where f_tablename = 'tbl_ld_cben'";
if (t == null)
{
return(_iAccessData.GetSingle(sqlString).ToString());
}
else
{
return(t.GetSingle(sqlString).ToString());
}
}
public string ExecuteSqls(string sqlStringJson)
{
Eva.Library.Data.AccessDataTrans.IAccessDataTrans iAccessDataTrans = commonclass.commonclass.CreateIAccessDataTrans();
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
string message = "";
try
{
iAccessDataTrans.getTrans().begin();
IDictionary <string, string> sqlStringDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(sqlStringJson);
foreach (string key in sqlStringDic.Keys)
{
int resultNum = iAccessDataTrans.ExecuteSql((sqlStringDic[key].ToString()));
message += "\"" + key + "\":" + resultNum.ToString() + ",";
}
iAccessDataTrans.getTrans().commit();
resultDic["result"] = "true";
resultDic["message"] = "{" + message.TrimEnd(',') + "}";
}
catch (Exception ex)
{
iAccessDataTrans.getTrans().rollback();
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string CountRollback(string pgId, string clientInf)
{
Eva.Library.Data.AccessDataTrans.IAccessDataTrans t = null;
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
t = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans();
t.getTrans().begin();
CountRollBackJS(pgId, clientInf, t);
t.getTrans().commit();
resultDic["result"] = "true";
resultDic["message"] = "";
}
catch (Exception ex)
{
if (t != null)
{
t.getTrans().rollback();
}
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
/// <summary>
/// projclassstate向前流转
/// </summary>
/// <param name="sys_ids"></param>
/// <param name="str_facterid"></param>
/// <param name="ds_facter"></param>
/// <param name="str_txt_bak_message"></param>
/// <param name="clientInf"></param>
/// <returns></returns>
public string set_sendbak(string sys_ids, string str_facterid, DataSet ds_facter, string str_txt_bak_message, string clientInf)
{
string result = "";
string all_result = "";
string[] sys_idss = sys_ids.Split(',');
for (int i = 0; i < sys_idss.Length; i++)
{
try
{
_t = commonclass.CreateIAccessDataTrans();
_t.getTrans().begin();
NameValueCollection nvc_maintableparameters = new NameValueCollection();
nvc_maintableparameters.Add("sys_processnextuser", "^nextuser");
nvc_maintableparameters.Add("fk_tbl_maintable_sys_id", "^null");
nvc_maintableparameters.Add("sys_processinsid", "^null");
result = _hic.NextStateItemNew(sys_idss[i].ToString(), nvc_maintableparameters, str_facterid, ds_facter, str_txt_bak_message, "", "", clientInf, _t);
if (result == "")
{
_t.getTrans().commit();
}
else
{
_t.getTrans().rollback();
all_result += result;
}
}
catch (Exception ex)
{
_t.getTrans().rollback();
result = ex.ToString();
all_result += result;
}
}
return all_result;
}
/// <summary>
/// 获取新的FILEID
/// </summary>
/// <returns></returns>
public static string GetNewFileId(Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
string sql = "select max(id) from tbl_file_menu ";
object o;
string fileid = "";
if (t == null)
{
fileid = ((o = _iAccessData.GetSingle(sql)) == null ? "0" : o.ToString());
}
else
{
fileid = ((o = t.GetSingle(sql)) == null ? "0" : o.ToString());
}
if (fileid == "")
{
fileid = "0";
}
fileid = (int.Parse(fileid) + 1).ToString();
sql = "insert into tbl_file_menu(id,hascontent) values('" + fileid + "','1')";
if (t == null)
{
_iAccessData.ExecuteSql(sql);
}
else
{
t.ExecuteSql(sql);
}
return(fileid);
}
public string Scanhtml(string htmlIds, string clientInf)
{
Eva.Library.Data.AccessDataTrans.IAccessDataTrans t = null;
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
string rootpath = Eva.Library.Format.FormatTextTool.GetMapPath(Eva.Library.Configuration.ConfigurationManager.AppSettings["AppResourceRootPath"].ToString() + "html/", Server);
sara.dd.ldsw.dal.tbl_app_version_html dal = new sara.dd.ldsw.dal.tbl_app_version_html();
t = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans();
t.getTrans().begin();
System.Data.DataTable dt = dal.GetDataTableForPC(" sys_id in ('" + htmlIds.Replace("^", "','") + "') ", "", "sys_id,f_htmlname,f_htmlversion,f_htmlcontent", "", "", t);
foreach (System.Data.DataRow item in dt.Rows)
{
sara.dd.ldsw.model.tbl_app_version_html model = new sara.dd.ldsw.model.tbl_app_version_html();
//item["f_htmlname"].ToString();
//item["f_htmlversion"];
//item["f_htmlcontent"]
//读取文件
string htmlName = (rootpath + item["f_htmlname"].ToString()).Replace("/", "\\");
string htmlContent = "";
if (htmlName.IndexOf(".html") > -1 || htmlName.IndexOf(".js") > -1 || htmlName.IndexOf(".css") > -1)
{
htmlContent = FileOperation.ReadFile(htmlName);
}
//比较是否相同
if (htmlContent != item["f_htmlcontent"].ToString())
{
model.sys_id = int.Parse(item["sys_id"].ToString());
model.f_htmlversion = GetVersion(item["f_htmlversion"].ToString());
model.f_htmlcontent = htmlContent;
model.sys_lasteditdate = System.DateTime.Now;
dal.Update(model, "sys_id,f_htmlversion,f_htmlcontent,sys_lasteditdate", t);
}
}
t.getTrans().commit();
resultDic["result"] = "true";
resultDic["message"] = "";
}
catch (Exception ex)
{
if (t != null)
{
t.getTrans().rollback();
}
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
/// <summary>
/// 得到最大ID
/// </summary>
public string GetMaxId(Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
string sqlString = "select TBL_CLOB_SEQUENCE.Nextval from dual";
return(_iAccessData.GetSingle(sqlString).ToString());
}
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_khjsonid,";
columnsString += "f_fj,";
columnsString = columnsString.TrimEnd(',');
List <sara.dd.ldsw.model.tbl_ld_xhhbtzb> l_tbl_ld_xhhbtzb = _idal_tbl_ld_xhhbtzb.GetList(whereString, "", columnsString, "", "", null);
foreach (sara.dd.ldsw.model.tbl_ld_xhhbtzb model in l_tbl_ld_xhhbtzb)
{
fileIDs += model.f_khjsonid + ",";
fileIDs += model.f_fj + ",";
}
fileIDs = fileIDs.TrimEnd(',');
_iAccessDataTrans = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans();
_iAccessDataTrans.getTrans().begin();
sara.dd.ldsw.model.tbl_ld_xhhbtzb model_tbl_ld_xhhbtzb = new sara.dd.ldsw.model.tbl_ld_xhhbtzb();
model_tbl_ld_xhhbtzb = _idal_tbl_ld_xhhbtzb.GetList(whereString, "", "*", "", "", null)[0];
if (model_tbl_ld_xhhbtzb.f_khbhid != "" && model_tbl_ld_xhhbtzb.f_khbhid != null)
{
string sql = " update tbl_ld_khb set f_value1 ='',f_value2 ='' where sys_id = '" + model_tbl_ld_xhhbtzb.f_khbhid + "'";
_iAccessDataTrans.ExecuteSql(sql);
}
sara.dd.ldsw.commonclass.filecontrol.deleteByFileName(fileIDs, null);
//删除子表的方法
//加入删除子表附件文件的方法
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ld_xhhbtzb.Delete(whereString, null);
_iAccessDataTrans.getTrans().commit();
NewLog("数据删除成功，删除的数据条件为：" + whereString, "sql_delete", clientInf);
}
catch (Exception ex)
{
if (_iAccessDataTrans != null)
{
_iAccessDataTrans.getTrans().rollback();
}
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));
}
/// <summary>
/// 删除附件
/// </summary>
/// <param name="fileID">附件ID</param>
/// <param name="delmod">1：物理删除，2：逻辑删除</param>
/// <param name="isfilelog">1：记录日志，2：不记录日志</param>
/// <param name="clientInf">用户信息</param>
/// <returns></returns>
public static void deleteByFileName(string fileIDs, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
//删除物理文件
string fileuploadname = "";
string query_sql = "select * from tbl_file_content where menuid in ('" + fileIDs.Replace(",", "','") + "')";
DataSet ds = null;
if (t == null)
{
ds = _iAccessData.Query(query_sql);
}
else
{
ds = t.Query(query_sql);
}
if (ds != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
fileuploadname += ds.Tables[0].Rows[i]["fileuploadname"].ToString() + "^";
}
}
fileuploadname = fileuploadname.TrimEnd('^');
if (fileuploadname != "")
{
string methordName = "deleteByFileUploadName";
object[] args = { _fileUpLoadRootPath, fileuploadname };
string rr = sara.dd.ldsw.commonclass.webserviceadapter.DoWebService(_serviceFile_url, methordName, args).ToString();
IDictionary <string, string> re = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(rr);
if (re["result"] == "true")
{
}
else
{
throw new Exception(re["message"]);
}
}
string sql_tbl_file_content = " delete from tbl_file_content where menuid in ('" + fileIDs.Replace(",", "','") + "')";
string sql_tbl_file_menu = " delete from tbl_file_menu where id in ('" + fileIDs.Replace(",", "','") + "')";
if (t == null)
{
_iAccessData.ExecuteSql(sql_tbl_file_content);
_iAccessData.ExecuteSql(sql_tbl_file_menu);
}
else
{
t.ExecuteSql(sql_tbl_file_content);
t.ExecuteSql(sql_tbl_file_menu);
}
}
/// <summary>
/// 得到最大ID
/// </summary>
public string GetMaxId(Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
string sqlString = "select SEQ_TBL_LD_YCBGLZB.Nextval from DUAL";
if (t == null)
{
return(_iAccessData.GetSingle(sqlString).ToString());
}
else
{
return(t.GetSingle(sqlString).ToString());
}
}
public string CountCbiao(string cbiaoIds, string pgId, string clientInf)
{
Eva.Library.Data.AccessDataTrans.IAccessDataTrans t = null;
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
t = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans();
t.getTrans().begin();
string sql = "";
sql = "select * from tbl_ld_pgb where sys_id = '" + pgId + "'";
DataSet ds = t.Query(sql);
if (ds.Tables[0].Rows.Count > 0)
{
//f_zt,f_ztid
sql = " update tbl_ld_cbiao set ";
sql += " f_pgbh ='" + ds.Tables[0].Rows[0]["f_pgbh"] + "',f_pgbhid = '" + pgId + "',";
sql += " f_pgpcmc = '" + ds.Tables[0].Rows[0]["f_pgpcmc"] + "',f_pgsj = to_date('" + (ds.Tables[0].Rows[0]["f_pgsj"]) + "','yyyy-MM-dd hh24:mi:ss'),";
sql += " f_pgr = '" + ds.Tables[0].Rows[0]["f_pgr"] + "',f_pgrid ='" + ds.Tables[0].Rows[0]["f_pgrid"] + "',";
sql += " f_zt = '算费',f_ztid = '1'";
sql += " where sys_id in ('" + cbiaoIds.Replace("^", "','") + "')";
t.ExecuteSql(sql);
t.getTrans().commit();
resultDic["result"] = "true";
resultDic["message"] = "";
}
else
{
resultDic["result"] = "false";
resultDic["message"] = "算费失败";
t.getTrans().rollback();
}
}
catch (Exception ex)
{
if (t != null)
{
t.getTrans().rollback();
}
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
/// <summary>
/// 重写updatelist
/// </summary>
/// <param name="json"></param>
/// <param name="columns"></param>
/// <param name="clientInf"></param>
/// <returns></returns>
public string UpdateList(List <sara.dd.ldsw.model.tbl_ld_cben> modelList, string columns, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
int column = 0;
try
{
if (t == null)
{
_iAccessDataTrans = Eva.Library.Data.AccessDataTrans.AccessDataTransFactory.CreateDataAccess(DataBaseType.oracledal, Eva.Library.Configuration.ConfigurationManager.AppSettings["DataBaseConnectionString"].ToString());
_iAccessDataTrans.getTrans().begin();
}
foreach (sara.dd.ldsw.model.tbl_ld_cben model in modelList)
{
if (t == null)
{
if (Update(model, columns, _iAccessDataTrans) == "1")
{
column++;
}
}
else
{
if (Update(model, columns, t) == "1")
{
column++;
}
}
}
if (t == null)
{
_iAccessDataTrans.getTrans().commit();
}
}
catch (Exception ex)
{
if (t == null)
{
_iAccessDataTrans.getTrans().rollback();
}
throw ex;
}
return(column.ToString());
}
public string unCountCbiao(string pgId, string clientInf)
{
Eva.Library.Data.AccessDataTrans.IAccessDataTrans t = null;
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
t = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans();
t.getTrans().begin();
string sql = "";
sql = "select * from tbl_ld_pgb where sys_id = '" + pgId + "'";
DataSet ds = t.Query(sql);
if (ds.Tables[0].Rows.Count > 0)
{
sql = " update tbl_ld_cbiao set ";
sql += " f_pgbh = '',f_pgbhid = '',";
sql += " f_pgpcmc = '',f_pgsj = '',";
sql += " f_pgr = '',f_pgrid ='',";
sql += " f_zt = '抄表',f_ztid = '0'";
sql += " where f_pgbhid= '" + pgId + "'";
t.ExecuteSql(sql);
t.getTrans().commit();
resultDic["result"] = "true";
resultDic["message"] = "";
}
else
{
resultDic["result"] = "false";
resultDic["message"] = "解除算费失败";
t.getTrans().rollback();
}
}
catch (Exception ex)
{
if (t != null)
{
t.getTrans().rollback();
}
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
/// <summary>
/// 重写deleteshape
/// </summary>
/// <param name="whereString"></param>
/// <param name="clientInf"></param>
/// <returns></returns>
public string Delete(string whereString, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete tbl_ld_cben where ");
strSql.Append(whereString);
int executecount = 0;
if (t == null)
{
executecount = _iAccessData.ExecuteSql(strSql.ToString());
}
else
{
executecount = t.ExecuteSql(strSql.ToString());
}
return(executecount.ToString());
}
/// <summary>
/// 执行删除
/// </summary>
/// <param name="sys_ids"></param>
/// <param name="str_name"></param>
/// <returns></returns>
public string set_del(string sys_ids, string str_name)
{
string[] sys_idss = System.Text.RegularExpressions.Regex.Split(sys_ids, ",");
string str_result_all = "";
for (int i = 0; i < sys_idss.Length; i++)
{
string result = "";
try
{
_model_tbl_maintable = _idal_itbl_maintable.GetList("sys_id='" + sys_idss[i] + "'", "", "*", "", "", null)[0];
_t = commonclass.CreateIAccessDataTrans();
_t.getTrans().begin();
#region businesscode
//businesscode
//在此处添加针对projclassid = 3的业务代码
#endregion
if (result == "")
{
result = _hic.DelItem(sys_idss[i].ToString(), str_name, _t);
}
if (result == "")
{
_t.getTrans().commit();
}
else
{
_t.getTrans().rollback();
str_result_all += result;
}
}
catch (Exception ex)
{
_t.getTrans().rollback();
result = ex.ToString();
str_result_all += result;
}
}
return(str_result_all);
}
/// <summary>
/// 重写获取count
/// </summary>
/// <param name="whereString"></param>
/// <param name="clientInf"></param>
/// <returns></returns>
public string GetCount(string whereString, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from tbl_ld_cben");
if (whereString.Trim() != "")
{
strSql.Append(" where " + whereString);
}
string count = "0";
if (t == null)
{
count = int.Parse(_iAccessData.GetSingle(strSql.ToString()).ToString()).ToString();
}
else
{
count = int.Parse(t.GetSingle(strSql.ToString()).ToString()).ToString();
}
return(count);
}
public string Delete(string whereString, string clientInf)
{
Eva.Library.Data.AccessDataTrans.IAccessDataTrans t = commonclass.commonclass.CreateIAccessDataTrans();
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
t.getTrans().begin();
resultDic["result"] = "true";
//删除附件
string sqlString = " select f_file from tbl_task where " + whereString + "";
DataTable dt = t.Query(sqlString).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
commonclass.filecontrol.deleteByFileName(dt.Rows[i]["f_file"].ToString(), t);
}
resultDic["message"] = _idal_tbl_task.Delete(whereString, t);
t.getTrans().commit();
NewLog("数据删除成功，删除的数据条件为：" + whereString, "sql_delete", clientInf);
}
catch (Exception ex)
{
t.getTrans().rollback();
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 Add(string json, string clientInf)
{
Eva.Library.Data.AccessDataTrans.IAccessDataTrans t = null;
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
t = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans();
t.getTrans().begin();
sara.dd.ldsw.model.tbl_ld_jmb model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_jmb>(json);
model.sys_lasteditdate = DateTime.Now;
model.sys_creatdate = DateTime.Now;
model.f_czsj = DateTime.Now;
if (model.f_jmbh == "")
{
model.f_jmbh = sara.dd.ldsw.commonclass.commonclass.getBusinessNum("jm", "", t);
}
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ld_jmb.Add(model, t);
t.getTrans().commit();
NewLog("数据创建成功，创建的数据为：" + json, "sql_insert", clientInf);
}
catch (Exception ex)
{
if (t != null)
{
t.getTrans().rollback();
}
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));
}
/// <summary>
/// 重写添加addlist
/// </summary>
/// <param name="json"></param>
/// <param name="clientInf"></param>
/// <returns></returns>
public string AddList(List <sara.dd.ldsw.model.tbl_ld_cben> modelList, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
string Newids = "";
try
{
if (t == null)
{
_iAccessDataTrans = Eva.Library.Data.AccessDataTrans.AccessDataTransFactory.CreateDataAccess(DataBaseType.oracledal, Eva.Library.Configuration.ConfigurationManager.AppSettings["DataBaseConnectionString"].ToString());
_iAccessDataTrans.getTrans().begin();
}
foreach (sara.dd.ldsw.model.tbl_ld_cben model in modelList)
{
if (t == null)
{
Newids += Add(model, _iAccessDataTrans) + "^";
}
else
{
Newids += Add(model, t) + "^";
}
}
if (t == null)
{
_iAccessDataTrans.getTrans().commit();
}
return(Newids.TrimEnd('^'));
}
catch (Exception ex)
{
if (t == null)
{
_iAccessDataTrans.getTrans().rollback();
}
throw ex;
}
}
/// <summary>
/// 重写logicdelete
/// </summary>
/// <param name="delUserId"></param>
/// <param name="delUserName"></param>
/// <param name="delDate"></param>
/// <param name="whereString"></param>
/// <param name="clientInf"></param>
/// <returns></returns>
public string LogicDelete(string delUserId, string delUserName, string delDate, string whereString, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbl_ld_cben set ");
strSql.Append("sys_deluserid='" + delUserId + "',");
strSql.Append("sys_delusername='******',");
strSql.Append("sys_deldate=to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),");
strSql.Append("sys_delflag='1',");
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where " + whereString + " ");
int executecount = 0;
if (t == null)
{
executecount = _iAccessData.ExecuteSql(strSql.ToString());
}
else
{
executecount = t.ExecuteSql(strSql.ToString());
}
return(executecount.ToString());
}
/// <summary>
/// 重写更新updatepaper
/// </summary>
/// <param name="json"></param>
/// <param name="columns"></param>
/// <param name="clientInf"></param>
/// <returns></returns>
public string Update(sara.dd.ldsw.model.tbl_ld_cben model, string columns, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
String[] columnsArray = columns.Split(',');
List <string> columsList = new List <string>(columnsArray);
List <OracleParameter> parameterList = new List <OracleParameter>();
OracleParameter parameter = null;
#region sqlString
StringBuilder strSql = new StringBuilder();
StringBuilder strSql_use = new StringBuilder();
strSql.Append("update tbl_ld_cben set ");
strSql_use.Append("update tbl_ld_cben set ");
if (Eva.Library.Configuration.ConfigurationManager.AppSettings["SqlEditMode"].ToString() == "parameter")
{
}
else //如果是sql形式的话，则进行textReturn
{
model = Eva.Library.Format.FormatTextTool.ModelFormat(model);
}
if (model.sys_orderid != null && columsList.Contains("sys_orderid"))
{
strSql.Append("sys_orderid='" + (model.sys_orderid) + "',");
strSql_use.Append("sys_orderid=:sys_orderid,");
parameter = new OracleParameter(":sys_orderid", OracleType.VarChar);
parameter.Value = model.sys_orderid;
parameterList.Add(parameter);
}
if (model.sys_creatuserid != null && columsList.Contains("sys_creatuserid"))
{
strSql.Append("sys_creatuserid='" + (model.sys_creatuserid) + "',");
strSql_use.Append("sys_creatuserid=:sys_creatuserid,");
parameter = new OracleParameter(":sys_creatuserid", OracleType.VarChar);
parameter.Value = model.sys_creatuserid;
parameterList.Add(parameter);
}
if (model.sys_creatusername != null && columsList.Contains("sys_creatusername"))
{
strSql.Append("sys_creatusername='******',");
strSql_use.Append("sys_creatusername=:sys_creatusername,");
parameter = new OracleParameter(":sys_creatusername", OracleType.VarChar);
parameter.Value = model.sys_creatusername;
parameterList.Add(parameter);
}
if (model.sys_creatdate != null && columsList.Contains("sys_creatdate"))
{
strSql.Append("sys_creatdate=to_date('" + model.sys_creatdate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),");
strSql_use.Append("sys_creatdate=:sys_creatdate,");
parameter = new OracleParameter(":sys_creatdate", OracleType.DateTime);
parameter.Value = model.sys_creatdate;
parameterList.Add(parameter);
}
if (model.sys_lastedituserid != null && columsList.Contains("sys_lastedituserid"))
{
strSql.Append("sys_lastedituserid='" + (model.sys_lastedituserid) + "',");
strSql_use.Append("sys_lastedituserid=:sys_lastedituserid,");
parameter = new OracleParameter(":sys_lastedituserid", OracleType.VarChar);
parameter.Value = model.sys_lastedituserid;
parameterList.Add(parameter);
}
if (model.sys_lasteditusername != null && columsList.Contains("sys_lasteditusername"))
{
strSql.Append("sys_lasteditusername='******',");
strSql_use.Append("sys_lasteditusername=:sys_lasteditusername,");
parameter = new OracleParameter(":sys_lasteditusername", OracleType.VarChar);
parameter.Value = model.sys_lasteditusername;
parameterList.Add(parameter);
}
if (model.sys_lasteditdate != null && columsList.Contains("sys_lasteditdate"))
{
strSql.Append("sys_lasteditdate=to_date('" + model.sys_lasteditdate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),");
strSql_use.Append("sys_lasteditdate=:sys_lasteditdate,");
parameter = new OracleParameter(":sys_lasteditdate", OracleType.DateTime);
parameter.Value = model.sys_lasteditdate;
parameterList.Add(parameter);
}
if (model.sys_deluserid != null && columsList.Contains("sys_deluserid"))
{
strSql.Append("sys_deluserid='" + (model.sys_deluserid) + "',");
strSql_use.Append("sys_deluserid=:sys_deluserid,");
parameter = new OracleParameter(":sys_deluserid", OracleType.VarChar);
parameter.Value = model.sys_deluserid;
parameterList.Add(parameter);
}
if (model.sys_delusername != null && columsList.Contains("sys_delusername"))
{
strSql.Append("sys_delusername='******',");
strSql_use.Append("sys_delusername=:sys_delusername,");
parameter = new OracleParameter(":sys_delusername", OracleType.VarChar);
parameter.Value = model.sys_delusername;
parameterList.Add(parameter);
}
if (model.sys_deldate != null && columsList.Contains("sys_deldate"))
{
strSql.Append("sys_deldate=to_date('" + model.sys_deldate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),");
strSql_use.Append("sys_deldate=:sys_deldate,");
parameter = new OracleParameter(":sys_deldate", OracleType.DateTime);
parameter.Value = model.sys_deldate;
parameterList.Add(parameter);
}
if (model.sys_delflag != null && columsList.Contains("sys_delflag"))
{
strSql.Append("sys_delflag='" + (model.sys_delflag) + "',");
strSql_use.Append("sys_delflag=:sys_delflag,");
parameter = new OracleParameter(":sys_delflag", OracleType.VarChar);
parameter.Value = model.sys_delflag;
parameterList.Add(parameter);
}
if (model.f_value1 != null && columsList.Contains("f_value1"))
{
strSql.Append("f_value1='" + (model.f_value1) + "',");
strSql_use.Append("f_value1=:f_value1,");
parameter = new OracleParameter(":f_value1", OracleType.VarChar);
parameter.Value = model.f_value1;
parameterList.Add(parameter);
}
if (model.f_value2 != null && columsList.Contains("f_value2"))
{
strSql.Append("f_value2='" + (model.f_value2) + "',");
strSql_use.Append("f_value2=:f_value2,");
parameter = new OracleParameter(":f_value2", OracleType.VarChar);
parameter.Value = model.f_value2;
parameterList.Add(parameter);
}
if (model.f_value3 != null && columsList.Contains("f_value3"))
{
strSql.Append("f_value3='" + (model.f_value3) + "',");
strSql_use.Append("f_value3=:f_value3,");
parameter = new OracleParameter(":f_value3", OracleType.VarChar);
parameter.Value = model.f_value3;
parameterList.Add(parameter);
}
if (model.f_value4 != null && columsList.Contains("f_value4"))
{
strSql.Append("f_value4='" + (model.f_value4) + "',");
strSql_use.Append("f_value4=:f_value4,");
parameter = new OracleParameter(":f_value4", OracleType.VarChar);
parameter.Value = model.f_value4;
parameterList.Add(parameter);
}
if (model.f_value5 != null && columsList.Contains("f_value5"))
{
strSql.Append("f_value5='" + (model.f_value5) + "',");
strSql_use.Append("f_value5=:f_value5,");
parameter = new OracleParameter(":f_value5", OracleType.VarChar);
parameter.Value = model.f_value5;
parameterList.Add(parameter);
}
if (model.f_value6 != null && columsList.Contains("f_value6"))
{
strSql.Append("f_value6='" + (model.f_value6) + "',");
strSql_use.Append("f_value6=:f_value6,");
parameter = new OracleParameter(":f_value6", OracleType.VarChar);
parameter.Value = model.f_value6;
parameterList.Add(parameter);
}
if (model.f_value7 != null && columsList.Contains("f_value7"))
{
strSql.Append("f_value7='" + (model.f_value7) + "',");
strSql_use.Append("f_value7=:f_value7,");
parameter = new OracleParameter(":f_value7", OracleType.VarChar);
parameter.Value = model.f_value7;
parameterList.Add(parameter);
}
if (model.f_value8 != null && columsList.Contains("f_value8"))
{
strSql.Append("f_value8='" + (model.f_value8) + "',");
strSql_use.Append("f_value8=:f_value8,");
parameter = new OracleParameter(":f_value8", OracleType.VarChar);
parameter.Value = model.f_value8;
parameterList.Add(parameter);
}
if (model.f_value9 != null && columsList.Contains("f_value9"))
{
strSql.Append("f_value9='" + (model.f_value9) + "',");
strSql_use.Append("f_value9=:f_value9,");
parameter = new OracleParameter(":f_value9", OracleType.VarChar);
parameter.Value = model.f_value9;
parameterList.Add(parameter);
}
if (model.f_value10 != null && columsList.Contains("f_value10"))
{
strSql.Append("f_value10='" + (model.f_value10) + "',");
strSql_use.Append("f_value10=:f_value10,");
parameter = new OracleParameter(":f_value10", OracleType.VarChar);
parameter.Value = model.f_value10;
parameterList.Add(parameter);
}
if (model.f_cbbh != null && columsList.Contains("f_cbbh"))
{
strSql.Append("f_cbbh='" + (model.f_cbbh) + "',");
strSql_use.Append("f_cbbh=:f_cbbh,");
parameter = new OracleParameter(":f_cbbh", OracleType.VarChar);
parameter.Value = model.f_cbbh;
parameterList.Add(parameter);
}
if (model.f_cbmc != null && columsList.Contains("f_cbmc"))
{
strSql.Append("f_cbmc='" + (model.f_cbmc) + "',");
strSql_use.Append("f_cbmc=:f_cbmc,");
parameter = new OracleParameter(":f_cbmc", OracleType.VarChar);
parameter.Value = model.f_cbmc;
parameterList.Add(parameter);
}
if (model.f_cbzq != null && columsList.Contains("f_cbzq"))
{
strSql.Append("f_cbzq='" + (model.f_cbzq) + "',");
strSql_use.Append("f_cbzq=:f_cbzq,");
parameter = new OracleParameter(":f_cbzq", OracleType.VarChar);
parameter.Value = model.f_cbzq;
parameterList.Add(parameter);
}
if (model.f_ksyf != null && columsList.Contains("f_ksyf"))
{
strSql.Append("f_ksyf='" + (model.f_ksyf) + "',");
strSql_use.Append("f_ksyf=:f_ksyf,");
parameter = new OracleParameter(":f_ksyf", OracleType.VarChar);
parameter.Value = model.f_ksyf;
parameterList.Add(parameter);
}
if (model.f_cbymc != null && columsList.Contains("f_cbymc"))
{
strSql.Append("f_cbymc='" + (model.f_cbymc) + "',");
strSql_use.Append("f_cbymc=:f_cbymc,");
parameter = new OracleParameter(":f_cbymc", OracleType.VarChar);
parameter.Value = model.f_cbymc;
parameterList.Add(parameter);
}
if (model.f_cbyid != null && columsList.Contains("f_cbyid"))
{
strSql.Append("f_cbyid='" + (model.f_cbyid) + "',");
strSql_use.Append("f_cbyid=:f_cbyid,");
parameter = new OracleParameter(":f_cbyid", OracleType.VarChar);
parameter.Value = model.f_cbyid;
parameterList.Add(parameter);
}
if (model.f_cbyphoto != null && columsList.Contains("f_cbyphoto"))
{
strSql.Append("f_cbyphoto='" + (model.f_cbyphoto) + "',");
strSql_use.Append("f_cbyphoto=:f_cbyphoto,");
parameter = new OracleParameter(":f_cbyphoto", OracleType.VarChar);
parameter.Value = model.f_cbyphoto;
parameterList.Add(parameter);
}
if (model.f_zt != null && columsList.Contains("f_zt"))
{
strSql.Append("f_zt='" + (model.f_zt) + "',");
strSql_use.Append("f_zt=:f_zt,");
parameter = new OracleParameter(":f_zt", OracleType.VarChar);
parameter.Value = model.f_zt;
parameterList.Add(parameter);
}
if (model.f_ztid != null && columsList.Contains("f_ztid"))
{
strSql.Append("f_ztid='" + (model.f_ztid) + "',");
strSql_use.Append("f_ztid=:f_ztid,");
parameter = new OracleParameter(":f_ztid", OracleType.VarChar);
parameter.Value = model.f_ztid;
parameterList.Add(parameter);
}
if (model.f_bz != null && columsList.Contains("f_bz"))
{
strSql.Append("f_bz='" + (model.f_bz) + "',");
strSql_use.Append("f_bz=:f_bz,");
parameter = new OracleParameter(":f_bz", OracleType.VarChar);
parameter.Value = model.f_bz;
parameterList.Add(parameter);
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where sys_id='" + model.sys_id + "'");
n = strSql_use.ToString().LastIndexOf(",");
strSql_use.Remove(n, 1);
strSql_use.Append(" where sys_id='" + model.sys_id + "'");
#endregion
int columscount = 0;
if (Eva.Library.Configuration.ConfigurationManager.AppSettings["SqlEditMode"].ToString() == "parameter")
{
#region parameter
if (parameterList.Count > 0)
{
if (t == null)
{
columscount = _iAccessData.ExecuteSql(strSql_use.ToString(), parameterList.ToArray());
}
else
{
columscount = t.ExecuteSql(strSql_use.ToString(), parameterList.ToArray());
}
}
#endregion
}
else
{
#region sql
if (t == null)
{
columscount = _iAccessData.ExecuteSql(strSql.ToString());
}
else
{
columscount = t.ExecuteSql(strSql.ToString());
}
#endregion
}
return(columscount.ToString());
}
/// <summary>
/// 重写添加addlayerconfig
/// </summary>
/// <param name="json"></param>
/// <param name="clientInf"></param>
/// <returns></returns>
public string Add(sara.dd.ldsw.model.tbl_ld_cben model, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql_use = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
StringBuilder strSql3 = new StringBuilder();
if (Eva.Library.Configuration.ConfigurationManager.AppSettings["SqlEditMode"].ToString() == "parameter")
{
}
else //如果是sql形式的话，则进行textFormat
{
model = Eva.Library.Format.FormatTextTool.ModelFormat(model);
}
List <OracleParameter> parameterList = new List <OracleParameter>();
OracleParameter parameter = null;
string sid = "";
if (model.sys_id <= 0)
{
if (t == null)
{
sid = GetMaxId(null).ToString();
}
else
{
sid = GetMaxId(t).ToString();
}
model.sys_id = int.Parse(sid);
}
else
{
sid = model.sys_id.ToString();
}
#region sqlString
strSql1.Append("sys_id,");
strSql2.Append("'" + sid + "',");
strSql3.Append(":sys_id,");
parameter = new OracleParameter(":sys_id", OracleType.Number);
parameter.Value = sid;
parameterList.Add(parameter);
if (model.sys_orderid != null)
{
strSql1.Append("sys_orderid,");
strSql2.Append("'" + (model.sys_orderid) + "',");
strSql3.Append(":sys_orderid,");
parameter = new OracleParameter(":sys_orderid", OracleType.VarChar);
parameter.Value = model.sys_orderid;
parameterList.Add(parameter);
}
if (model.sys_creatuserid != null)
{
strSql1.Append("sys_creatuserid,");
strSql2.Append("'" + (model.sys_creatuserid) + "',");
strSql3.Append(":sys_creatuserid,");
parameter = new OracleParameter(":sys_creatuserid", OracleType.VarChar);
parameter.Value = model.sys_creatuserid;
parameterList.Add(parameter);
}
if (model.sys_creatusername != null)
{
strSql1.Append("sys_creatusername,");
strSql2.Append("'" + (model.sys_creatusername) + "',");
strSql3.Append(":sys_creatusername,");
parameter = new OracleParameter(":sys_creatusername", OracleType.VarChar);
parameter.Value = model.sys_creatusername;
parameterList.Add(parameter);
}
if (model.sys_creatdate != null)
{
strSql1.Append("sys_creatdate,");
strSql2.Append("to_date('" + model.sys_creatdate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),");
strSql3.Append(":sys_creatdate,");
parameter = new OracleParameter(":sys_creatdate", OracleType.DateTime);
parameter.Value = model.sys_creatdate;
parameterList.Add(parameter);
}
if (model.sys_lastedituserid != null)
{
strSql1.Append("sys_lastedituserid,");
strSql2.Append("'" + (model.sys_lastedituserid) + "',");
strSql3.Append(":sys_lastedituserid,");
parameter = new OracleParameter(":sys_lastedituserid", OracleType.VarChar);
parameter.Value = model.sys_lastedituserid;
parameterList.Add(parameter);
}
if (model.sys_lasteditusername != null)
{
strSql1.Append("sys_lasteditusername,");
strSql2.Append("'" + (model.sys_lasteditusername) + "',");
strSql3.Append(":sys_lasteditusername,");
parameter = new OracleParameter(":sys_lasteditusername", OracleType.VarChar);
parameter.Value = model.sys_lasteditusername;
parameterList.Add(parameter);
}
if (model.sys_lasteditdate != null)
{
strSql1.Append("sys_lasteditdate,");
strSql2.Append("to_date('" + model.sys_lasteditdate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),");
strSql3.Append(":sys_lasteditdate,");
parameter = new OracleParameter(":sys_lasteditdate", OracleType.DateTime);
parameter.Value = model.sys_lasteditdate;
parameterList.Add(parameter);
}
if (model.sys_deluserid != null)
{
strSql1.Append("sys_deluserid,");
strSql2.Append("'" + (model.sys_deluserid) + "',");
strSql3.Append(":sys_deluserid,");
parameter = new OracleParameter(":sys_deluserid", OracleType.VarChar);
parameter.Value = model.sys_deluserid;
parameterList.Add(parameter);
}
if (model.sys_delusername != null)
{
strSql1.Append("sys_delusername,");
strSql2.Append("'" + (model.sys_delusername) + "',");
strSql3.Append(":sys_delusername,");
parameter = new OracleParameter(":sys_delusername", OracleType.VarChar);
parameter.Value = model.sys_delusername;
parameterList.Add(parameter);
}
if (model.sys_deldate != null)
{
strSql1.Append("sys_deldate,");
strSql2.Append("to_date('" + model.sys_deldate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),");
strSql3.Append(":sys_deldate,");
parameter = new OracleParameter(":sys_deldate", OracleType.DateTime);
parameter.Value = model.sys_deldate;
parameterList.Add(parameter);
}
if (model.sys_delflag != null)
{
strSql1.Append("sys_delflag,");
strSql2.Append("'" + (model.sys_delflag) + "',");
strSql3.Append(":sys_delflag,");
parameter = new OracleParameter(":sys_delflag", OracleType.VarChar);
parameter.Value = model.sys_delflag;
parameterList.Add(parameter);
}
if (model.f_value1 != null)
{
strSql1.Append("f_value1,");
strSql2.Append("'" + (model.f_value1) + "',");
strSql3.Append(":f_value1,");
parameter = new OracleParameter(":f_value1", OracleType.VarChar);
parameter.Value = model.f_value1;
parameterList.Add(parameter);
}
if (model.f_value2 != null)
{
strSql1.Append("f_value2,");
strSql2.Append("'" + (model.f_value2) + "',");
strSql3.Append(":f_value2,");
parameter = new OracleParameter(":f_value2", OracleType.VarChar);
parameter.Value = model.f_value2;
parameterList.Add(parameter);
}
if (model.f_value3 != null)
{
strSql1.Append("f_value3,");
strSql2.Append("'" + (model.f_value3) + "',");
strSql3.Append(":f_value3,");
parameter = new OracleParameter(":f_value3", OracleType.VarChar);
parameter.Value = model.f_value3;
parameterList.Add(parameter);
}
if (model.f_value4 != null)
{
strSql1.Append("f_value4,");
strSql2.Append("'" + (model.f_value4) + "',");
strSql3.Append(":f_value4,");
parameter = new OracleParameter(":f_value4", OracleType.VarChar);
parameter.Value = model.f_value4;
parameterList.Add(parameter);
}
if (model.f_value5 != null)
{
strSql1.Append("f_value5,");
strSql2.Append("'" + (model.f_value5) + "',");
strSql3.Append(":f_value5,");
parameter = new OracleParameter(":f_value5", OracleType.VarChar);
parameter.Value = model.f_value5;
parameterList.Add(parameter);
}
if (model.f_value6 != null)
{
strSql1.Append("f_value6,");
strSql2.Append("'" + (model.f_value6) + "',");
strSql3.Append(":f_value6,");
parameter = new OracleParameter(":f_value6", OracleType.VarChar);
parameter.Value = model.f_value6;
parameterList.Add(parameter);
}
if (model.f_value7 != null)
{
strSql1.Append("f_value7,");
strSql2.Append("'" + (model.f_value7) + "',");
strSql3.Append(":f_value7,");
parameter = new OracleParameter(":f_value7", OracleType.VarChar);
parameter.Value = model.f_value7;
parameterList.Add(parameter);
}
if (model.f_value8 != null)
{
strSql1.Append("f_value8,");
strSql2.Append("'" + (model.f_value8) + "',");
strSql3.Append(":f_value8,");
parameter = new OracleParameter(":f_value8", OracleType.VarChar);
parameter.Value = model.f_value8;
parameterList.Add(parameter);
}
if (model.f_value9 != null)
{
strSql1.Append("f_value9,");
strSql2.Append("'" + (model.f_value9) + "',");
strSql3.Append(":f_value9,");
parameter = new OracleParameter(":f_value9", OracleType.VarChar);
parameter.Value = model.f_value9;
parameterList.Add(parameter);
}
if (model.f_value10 != null)
{
strSql1.Append("f_value10,");
strSql2.Append("'" + (model.f_value10) + "',");
strSql3.Append(":f_value10,");
parameter = new OracleParameter(":f_value10", OracleType.VarChar);
parameter.Value = model.f_value10;
parameterList.Add(parameter);
}
if (model.f_cbbh != null)
{
strSql1.Append("f_cbbh,");
strSql2.Append("'" + (model.f_cbbh) + "',");
strSql3.Append(":f_cbbh,");
parameter = new OracleParameter(":f_cbbh", OracleType.VarChar);
parameter.Value = model.f_cbbh;
parameterList.Add(parameter);
}
if (model.f_cbmc != null)
{
strSql1.Append("f_cbmc,");
strSql2.Append("'" + (model.f_cbmc) + "',");
strSql3.Append(":f_cbmc,");
parameter = new OracleParameter(":f_cbmc", OracleType.VarChar);
parameter.Value = model.f_cbmc;
parameterList.Add(parameter);
}
if (model.f_cbzq != null)
{
strSql1.Append("f_cbzq,");
strSql2.Append("'" + (model.f_cbzq) + "',");
strSql3.Append(":f_cbzq,");
parameter = new OracleParameter(":f_cbzq", OracleType.VarChar);
parameter.Value = model.f_cbzq;
parameterList.Add(parameter);
}
if (model.f_ksyf != null)
{
strSql1.Append("f_ksyf,");
strSql2.Append("'" + (model.f_ksyf) + "',");
strSql3.Append(":f_ksyf,");
parameter = new OracleParameter(":f_ksyf", OracleType.VarChar);
parameter.Value = model.f_ksyf;
parameterList.Add(parameter);
}
if (model.f_cbymc != null)
{
strSql1.Append("f_cbymc,");
strSql2.Append("'" + (model.f_cbymc) + "',");
strSql3.Append(":f_cbymc,");
parameter = new OracleParameter(":f_cbymc", OracleType.VarChar);
parameter.Value = model.f_cbymc;
parameterList.Add(parameter);
}
if (model.f_cbyid != null)
{
strSql1.Append("f_cbyid,");
strSql2.Append("'" + (model.f_cbyid) + "',");
strSql3.Append(":f_cbyid,");
parameter = new OracleParameter(":f_cbyid", OracleType.VarChar);
parameter.Value = model.f_cbyid;
parameterList.Add(parameter);
}
if (model.f_cbyphoto != null)
{
strSql1.Append("f_cbyphoto,");
strSql2.Append("'" + (model.f_cbyphoto) + "',");
strSql3.Append(":f_cbyphoto,");
parameter = new OracleParameter(":f_cbyphoto", OracleType.VarChar);
parameter.Value = model.f_cbyphoto;
parameterList.Add(parameter);
}
if (model.f_zt != null)
{
strSql1.Append("f_zt,");
strSql2.Append("'" + (model.f_zt) + "',");
strSql3.Append(":f_zt,");
parameter = new OracleParameter(":f_zt", OracleType.VarChar);
parameter.Value = model.f_zt;
parameterList.Add(parameter);
}
if (model.f_ztid != null)
{
strSql1.Append("f_ztid,");
strSql2.Append("'" + (model.f_ztid) + "',");
strSql3.Append(":f_ztid,");
parameter = new OracleParameter(":f_ztid", OracleType.VarChar);
parameter.Value = model.f_ztid;
parameterList.Add(parameter);
}
if (model.f_bz != null)
{
strSql1.Append("f_bz,");
strSql2.Append("'" + (model.f_bz) + "',");
strSql3.Append(":f_bz,");
parameter = new OracleParameter(":f_bz", OracleType.VarChar);
parameter.Value = model.f_bz;
parameterList.Add(parameter);
}
strSql.Append("insert into tbl_ld_cben(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql_use.Append("insert into tbl_ld_cben(");
strSql_use.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql_use.Append(")");
strSql_use.Append(" values (");
strSql_use.Append(strSql3.ToString().Remove(strSql3.Length - 1));
strSql_use.Append(")");
#endregion
if (Eva.Library.Configuration.ConfigurationManager.AppSettings["SqlEditMode"].ToString() == "parameter")
{
#region parameter
if (parameterList.Count > 0)
{
if (t == null)
{
_iAccessData.ExecuteSql(strSql_use.ToString(), parameterList.ToArray());
}
else
{
t.ExecuteSql(strSql_use.ToString(), parameterList.ToArray());
}
}
#endregion
}
else
{
#region sql
if (t == null)
{
_iAccessData.ExecuteSql(strSql.ToString());
}
else
{
t.ExecuteSql(strSql.ToString());
}
List <string> paraStrList = new List <string>();
List <OracleParameter> pList = new List <OracleParameter>();
OracleParameter p = null;
if (paraStrList.Count > 0)
{
string updateSqlString = " update tbl_ld_cben set " + string.Join(" , ", paraStrList.ToArray()) + " where sys_id = '" + sid + "' ";
if (pList.Count > 0)
{
if (t == null)
{
_iAccessData.ExecuteSql(updateSqlString, pList.ToArray());
}
else
{
t.ExecuteSql(updateSqlString, pList.ToArray());
}
}
}
#endregion
}
return(sid);
}
public string GetKhJsonAndUpdate(string json, string khidString, string clearKhbhString, string czlxString, string czidString, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
IDictionary <string, string> clientInfoDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf);
Dictionary <string, string> khxxJsonDic = new Dictionary <string, string>();
DataTable dt = new DataTable();
_iAccessDataTrans = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans();
_iAccessDataTrans.getTrans().begin();
sara.dd.ldsw.idal.Itbl_ld_ghsb idal_tbl_ld_ghsb = new sara.dd.ldsw.dal.tbl_ld_ghsb();
sara.dd.ldsw.model.tbl_ld_ghsb model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_ghsb>(json);
//调用commonclass的方法 拿到客户json
List <DataTable> lt = new List <DataTable>();
lt = sara.dd.ldsw.commonclass.commonclass.GetKhxxJsonAndSetCzlx(khidString, czlxString, czidString, _iAccessDataTrans);
DataTable khxx = lt[0];
DataTable yhxx = lt[1];
DataTable sbxx = lt[2];
if (khxx.Rows.Count > 0)
{
}
DataRow dr = khxx.Rows[0];//这是拿到第一行数据
string khbh = dr["f_khbh"].ToString();
string khbhid = dr["sys_id"].ToString();
string yhm = dr["f_yhm"].ToString();
string dz = dr["f_dz"].ToString();
string dh = dr["f_dh"].ToString();
string khxx_yhm_dz = yhm + "," + dz + "," + dh;
khxxJsonDic["khxx"] = Eva.Library.Format.FormatEntityTool.FormatDataTableToJson(khxx);;
khxxJsonDic["yhxx"] = Eva.Library.Format.FormatEntityTool.FormatDataTableToJson(yhxx);
khxxJsonDic["sbxx"] = Eva.Library.Format.FormatEntityTool.FormatDataTableToJson(sbxx);
string khxxJson = Eva.Library.Format.FormatEntityTool.FormatDicToJson(khxxJsonDic);
//2.取出用户民、地址 逗号分隔，放到数据库f_khxx
//3.更新f_khbh,f_khbhid
model.f_khbh = khbh;
model.f_khbhid = khbhid;
model.f_khxx = khxx_yhm_dz;
model.f_khjson = khxxJson;
//4.clearCzlxKhbh不等于json中的客户编号 那么清空上一个客户编号的f_value1和f_value2
#region clearCzlx
if (clearKhbhString != khbh)
{
string sql = "update tbl_ld_khb set f_value1='" + "" + "',f_value2 = '" + "" + "' where f_khbh = '" + clearKhbhString + "'";
_iAccessDataTrans.ExecuteSql(sql);
}
#endregion
idal_tbl_ld_ghsb.Update(model, "f_khjson,f_khxx,f_khbh,f_khbhid", _iAccessDataTrans);
_iAccessDataTrans.getTrans().commit();
resultDic["result"] = "true";
resultDic["message"] = khxxJson;
}
catch (Exception ex)
{
if (_iAccessDataTrans != null)
{
_iAccessDataTrans.getTrans().rollback();
_iAccessDataTrans = null;
}
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public DataTable GetDataTableForApp(string whereString, string orderByString, string columnsString, string countString, string stepString, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select " + columnsString + " from (");
strSql.Append(" select rownum rn,a.* from (");
strSql.Append(" select * from tbl_ld_cben t where");
if (whereString.Trim() == "")
{
strSql.Append(" 1=1 ");
}
else
{
strSql.Append(" " + whereString);
}
if (orderByString.Trim() == "")
{
strSql.Append(" order by sys_creatdate desc ");
}
else
{
strSql.Append(" order by " + orderByString);
}
strSql.Append(" ) a ");
strSql.Append(" ) b ");
if (countString != "" && countString != null && stepString != "" && stepString != null)
{
strSql.Append(" where b.rn>'" + countString + "' and b.rn <='" + (int.Parse(countString) + int.Parse(stepString)).ToString() + "' ");
}
DataTable resultDataTable = null;
if (t == null)
{
resultDataTable = _iAccessData.Query(strSql.ToString()).Tables[0];
}
else
{
resultDataTable = t.Query(strSql.ToString()).Tables[0];
}
return(resultDataTable);
}
public DataTable GetDataTableForPC(string whereString, string orderByString, string columnsString, string pageSizeString, string pageIndexString, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select " + columnsString + " from (");
strSql.Append(" select rownum rn,a.* from (");
strSql.Append(" select * from tbl_ld_cben t where");
if (whereString.Trim() == "")
{
strSql.Append(" 1=1 ");
}
else
{
strSql.Append(" " + whereString);
}
if (orderByString.Trim() == "")
{
strSql.Append(" order by sys_creatdate desc ");
}
else
{
strSql.Append(" order by " + orderByString);
}
strSql.Append(" ) a ");
strSql.Append(" ) b ");
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)));
strSql.Append(" where b.rn>='" + fromInt.ToString() + "' and b.rn <='" + toInt.ToString() + "' ");
}
DataTable resultDataTable = null;
if (t == null)
{
resultDataTable = _iAccessData.Query(strSql.ToString()).Tables[0];
}
else
{
resultDataTable = t.Query(strSql.ToString()).Tables[0];
}
return(resultDataTable);
}
//[sys_id]$[facterid]$[ds_facter]$[str_shyj]$[processinsid]$[fk_workflow_sys_id]$[businessclass]$[businessstate]$[processdefid]$[processactivedefid]$[trans]
public string set_doworkflow(string sys_id, string facterid, DataSet ds_facter, string str_shyj, string processinsid, string businessclass, string businessstate, string processdefid, string processactivedefid, string clientInf, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
string result = "";
NameValueCollection nvc_maintableparameters = new NameValueCollection();
nvc_maintableparameters.Add("sys_processnextuser", "^nextuser");
nvc_maintableparameters.Add("sys_processinsid", processinsid);
nvc_maintableparameters.Add("fk_tbl_maintable_sys_id", "^null");
result = _hic.NextStateItemNew(sys_id, nvc_maintableparameters, facterid, ds_facter, str_shyj, processinsid, processactivedefid, clientInf, t);
#region businesscode
//switch (_pr_businessclass + "_" + _pr_businessstate)
//{
// default:
// break;
//}
#endregion
return(result);
}
//public string get_resultonlyonesysid(string sys_ids)
//{
// string str_result = "";
// if (sys_ids.Length > 0 && sys_ids.Split('^').Length == 1)
// {
// }
// else
// {
// str_result = "请选择一条数据。";
// }
// return str_result;
//}
//public string get_resultmorethanonesysid(string sys_ids)
//{
// string str_result = "";
// if (sys_ids.Length > 0)
// {
// }
// else
// {
// str_result = "请选择要操作的条目。";
// }
// return str_result;
//}
//public string set_send(string sys_ids, string str_facterid, DataSet ds_facter, string str_txt_bak_message, string clientInf)
//{
// string result = "";
// string all_result = "";
// string[] sys_idss = sys_ids.Split(',');
// for (int i = 0; i < sys_idss.Length; i++)
// {
// try
// {
// _t = commonclass.CreateIAccessDataTrans();
// _t.getTrans().begin();
// NameValueCollection nvc_maintableparameters = new NameValueCollection();
// nvc_maintableparameters.Add("sys_processnextuser", "^nextuser");
// nvc_maintableparameters.Add("fk_tbl_maintable_sys_id", "^null");
// nvc_maintableparameters.Add("sys_processinsid", "^null");
// result = _hic.NextStateItemNew(sys_idss[i].ToString(), nvc_maintableparameters, str_facterid, ds_facter, str_txt_bak_message, "", "", clientInf, _t);
// if (result == "")
// {
// _t.getTrans().commit();
// }
// else
// {
// _t.getTrans().rollback();
// all_result += result;
// }
// }
// catch (Exception ex)
// {
// _t.getTrans().rollback();
// result = ex.ToString();
// all_result += result;
// }
// }
// return all_result;
//}
//public string set_sendbak(string sys_ids, string str_facterid, DataSet ds_facter, string str_txt_bak_message, string clientInf)
//{
// string result = "";
// string all_result = "";
// string[] sys_idss = sys_ids.Split(',');
// for (int i = 0; i < sys_idss.Length; i++)
// {
// try
// {
// _t = commonclass.CreateIAccessDataTrans();
// _t.getTrans().begin();
// NameValueCollection nvc_maintableparameters = new NameValueCollection();
// nvc_maintableparameters.Add("sys_processnextuser", "^nextuser");
// nvc_maintableparameters.Add("fk_tbl_maintable_sys_id", "^null");
// nvc_maintableparameters.Add("sys_processinsid", "^null");
// result = _hic.NextStateItemNew(sys_idss[i].ToString(), nvc_maintableparameters, str_facterid, ds_facter, str_txt_bak_message, "", "", clientInf, _t);
// if (result == "")
// {
// _t.getTrans().commit();
// }
// else
// {
// _t.getTrans().rollback();
// all_result += result;
// }
// }
// catch (Exception ex)
// {
// _t.getTrans().rollback();
// result = ex.ToString();
// all_result += result;
// }
// }
// return all_result;
//}
//public string set_del(string sys_ids, string str_name)
//{
// string[] sys_idss = System.Text.RegularExpressions.Regex.Split(sys_ids, ",");
// string str_result_all = "";
// for (int i = 0; i < sys_idss.Length; i++)
// {
// string result = "";
// try
// {
// _model_tbl_maintable = _idal_itbl_maintable.GetList("sys_id='" + sys_idss[i] + "'", "", "*", "", "", null)[0];
// _t = commonclass.CreateIAccessDataTrans();
// _t.getTrans().begin();
// //2018-09-07-sk-??!!-businesscode
// switch (_model_tbl_maintable.sys_projectclassid)
// {
// case "1":
// break;
// default:
// break;
// }
// if (result == "")
// {
// result = _hic.DelItem(sys_idss[i].ToString(), str_name, _t);
// }
// if (result == "")
// {
// _t.getTrans().commit();
// }
// else
// {
// _t.getTrans().rollback();
// str_result_all += result;
// }
// }
// catch (Exception ex)
// {
// _t.getTrans().rollback();
// result = ex.ToString();
// str_result_all += result;
// }
// }
// return str_result_all;
//}
//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
// #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;
//}
////[sys_id]$[fk_workflow_sys_id]$[selectusernames]$[ds_facter]$[str_shyj]$[processinsid]$[businessparm]$[processdefid]$[facterid]$[trans]
//public string get_sendworkflow(string workitemid, ref string str_resultmessage, string clientInf)
//{
// string result = "";
// try
// {
// IDictionary<string, string> clientInfoDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf);
// string userid = clientInfoDic["userid"];
// string username = clientInfoDic["username"];
// Eva.Library.ServiceAdapter.IAdapter.IWorkFlow w = Eva.Library.ServiceAdapter.AdapterFactory.WorkFlowFactory.CreateService(Eva.Library.Configuration.ConfigurationManager.AppSettings["AppCode"]);
// DataSet useroperation = null;
// string shyj = "";
// if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll")
// {
// shyj = sara.platform.service.workflow.Service.GetUserOperationSHYJ(workitemid);
// }
// else
// {
// shyj = w.GetUserOperationSHYJ(workitemid);
// }
// if (shyj == "-1")
// {
// if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll")
// {
// useroperation = sara.platform.service.workflow.Service.GetUserOperation(workitemid, userid, username, DateTime.Now);
// }
// else
// {
// useroperation = w.GetUserOperation(workitemid, userid, username, DateTime.Now);
// }
// }
// else
// {
// DataSet ds_old;
// if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll")
// {
// ds_old = sara.platform.service.workflow.Service.GetUserOperationCZNR(workitemid);
// }
// else
// {
// ds_old = w.GetUserOperationCZNR(workitemid);
// }
// if (ds_old == null || ds_old.Tables.Count == 0)
// {
// if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll")
// {
// useroperation = sara.platform.service.workflow.Service.GetUserOperation(workitemid, userid, username, DateTime.Now);
// }
// else
// {
// useroperation = w.GetUserOperation(workitemid, userid, username, DateTime.Now);
// }
// }
// else
// {
// useroperation = ds_old;
// }
// }
// #region businesscode
// //在此处添加业务代码，可以控制默认选中哪个tab页，那条连接线，哪个用户
// //具体规则如下：
// //1、在datarow["Iselected"]中，设置0表示连接线被选中，设置-1表示连接线没有被选中
// //2、在datarow["userids"]\datarow["usernames"]中存放着备选用户的id和name，以小写逗号分割，例如：
// //datarow["userids"] = "1,2";datarow["usernames"] = "张三,李四"
// //此时程序会自动选中这2个用户，在id和names前边加“-”，则不会被选中，例如：
// //datarow["userids"] = "-1,2";datarow["usernames"] = "-张三,李四"
// //则李四默认会被选中，张三默认不会被选中
// //3、可以调整1，2的顺序，实现对审核顺序的调整，（如果当前节点的jdnyh!=1,并且节点类型是串行的话）
// //4、在1个useroperation中会存在多个连接线（多个datarow），当某个datarow的iselected=+0时，该连接线所在的页会默认被打开
// //如果不设置+号的话，则默认打开第一个0的连接线所在的页。
// //一个useroperation中只能有一个+0，否则按照最先一个+0计算。
// //传过来的数据里边，默认用户都是被选中的，连接线也是被选中的。
// for (int i = 0; i < useroperation.Tables[0].Rows.Count; i++)
// {
// //新增水表_居民//业务代码，转给经办人时，默认转给发起的经办人
// if (useroperation.Tables[0].Rows[i]["fk_dy_jd_sys_id_to"].ToString() == "540003020")
// {
// string lcslid = useroperation.Tables[0].Rows[i]["fk_sl_lc_sys_id"].ToString();
// string sql = "select czrid,czrname from t_workitem where fk_sl_lc_sys_id = '" + lcslid + "' and fk_dy_jd_sys_id = '540003000'";
// DataSet dsczr = _iAccessData.Query(sql);
// if (dsczr.Tables[0].Rows.Count > 0)
// {
// string czrid = dsczr.Tables[0].Rows[0]["czrid"].ToString();
// string czrname = dsczr.Tables[0].Rows[0]["czrname"].ToString();
// string[] oldUserIdArray = useroperation.Tables[0].Rows[i]["userids"].ToString().Split(',');
// string[] oldUserNameArray = useroperation.Tables[0].Rows[i]["usernames"].ToString().Split(',');
// string newUserIds = "";
// string newUserNames = "";
// for (int ii = 0; ii < oldUserIdArray.Length; ii++)
// {
// if (oldUserIdArray[ii] == czrid)
// {
// newUserIds += oldUserIdArray[ii] + ",";
// newUserNames += oldUserNameArray[ii] + ",";
// }
// else
// {
// newUserIds += "-" + oldUserIdArray[ii] + ",";
// newUserNames += "-" + oldUserNameArray[ii] + ",";
// }
// }
// useroperation.Tables[0].Rows[i]["userids"] = newUserIds.TrimEnd(',');
// useroperation.Tables[0].Rows[i]["usernames"] = newUserNames.TrimEnd(',');
// }
// }
// }
// #endregion
// str_resultmessage = Eva.Library.Format.FormatEntityTool.FormatDataTableToJson(useroperation.Tables[0]);
// }
// catch (Exception ex)
// {
// result = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
// }
// return result;
//}
///// <summary>
///// 转件落地
///// </summary>
///// <param name="sys_ids"></param>
///// <param name="str_facterid"></param>
///// <param name="ds_facter"></param>
///// <param name="p"></param>
///// <param name="str_txt_bak_message"></param>
///// <returns></returns>
//public string set_send_ld(string sys_ids, string str_facterid, DataSet ds_facter, string str_txt_bak_message, string clientInf)
//{
// /*
// all_result返回参数的整理：
// * 1、"{\"result\":\"true\",\"message\":\"\"}"----》第二次点击落地按钮，（理论上不应该出现这个情况，有可能是第一次操作时整个操作流程没有完成，所以造成用户可以点击这个按钮，所以此处的操作仅实现状态修改，返回值为true）
// * 2、"{\"result\":\"submit\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串，shpid|path
// * 3、"{\"result\":\"false\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串，异常信息。
// * 4、"{\"result\":\"submitqueue\",\"message\":\"\"}"----》成功加入队列
// */
// string all_result = "";
// string[] sys_idss = sys_ids.Split(',');
// for (int i = 0; i < sys_idss.Length; i++)
// {
// try
// {
// _model_tbl_maintable = _idal_itbl_maintable.GetList(" sys_id='" + sys_idss[i].ToString() + "'", "", "*", "", "", null)[0];
// if (all_result == "")
// {
// string result = "";
// _t = commonclass.CreateIAccessDataTrans();
// _t.getTrans().begin();
// //调整数据状态
// NameValueCollection nvc_maintableparameters = new NameValueCollection();
// nvc_maintableparameters.Add("sys_processnextuser", "^nextuser");
// nvc_maintableparameters.Add("fk_tbl_maintable_sys_id", "^null");
// nvc_maintableparameters.Add("fk_workflow_sys_id", "^null");
// result = _hic.NextStateItemNew(sys_idss[i].ToString(), nvc_maintableparameters, str_facterid, ds_facter, str_txt_bak_message, "", "", clientInf, _t);
// if (result == "")
// {
// _t.getTrans().commit();
// }
// else
// {
// _t.getTrans().rollback();
// all_result = "{\"result\":\"false\",\"message\":\"" + result + "\"}";
// }
// }
// }
// catch (Exception ex)
// {
// all_result = "{\"result\":\"false\",\"message\":\"" + ex.Message + "\"}";
// }
// }
// if (all_result == "")
// {
// all_result = "{\"result\":\"true\",\"message\":\"\"}";
// }
// return all_result;
//}
///// <summary>
///// //projclass = 3时进行的归档操作，执行落数程序
///// </summary>
///// <param name="sys_ids"></param>
///// <param name="str_facterid"></param>
///// <param name="ds_facter"></param>
///// <param name="str_txt_bak_message"></param>
///// <param name="clientInf"></param>
///// <returns></returns>
//public string set_complete_3(string sys_ids, string str_facterid, DataSet ds_facter, string str_txt_bak_message, string clientInf)
//{
// /*
// all_result返回参数的整理：
// * 1、"{\"result\":\"true\",\"message\":\"\"}"----》第二次点击落地按钮，（理论上不应该出现这个情况，有可能是第一次操作时整个操作流程没有完成，所以造成用户可以点击这个按钮，所以此处的操作仅实现状态修改，返回值为true）
// * 2、"{\"result\":\"submit\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串，shpid|path
// * 3、"{\"result\":\"false\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串，异常信息。
// * 4、"{\"result\":\"submitqueue\",\"message\":\"\"}"----》成功加入队列
// */
// string all_result = "";
// string[] sys_idss = sys_ids.Split(',');
// for (int i = 0; i < sys_idss.Length; i++)
// {
// try
// {
// _model_tbl_maintable = _idal_itbl_maintable.GetList(" sys_id='" + sys_idss[i].ToString() + "'", "", "*", "", "", null)[0];
// if (all_result == "")
// {
// string result = "";
// _t = commonclass.CreateIAccessDataTrans();
// _t.getTrans().begin();
// //2018-09-07-sk-??!!-businesscode
// //调整数据状态
// NameValueCollection nvc_maintableparameters = new NameValueCollection();
// nvc_maintableparameters.Add("sys_processnextuser", "^nextuser");
// nvc_maintableparameters.Add("fk_tbl_maintable_sys_id", "^null");
// nvc_maintableparameters.Add("fk_workflow_sys_id", "^null");
// result = _hic.NextStateItemNew(sys_idss[i].ToString(), nvc_maintableparameters, str_facterid, ds_facter, str_txt_bak_message, "", "", clientInf, _t);
// if (result == "")
// {
// _t.getTrans().commit();
// }
// else
// {
// _t.getTrans().rollback();
// all_result = "{\"result\":\"false\",\"message\":\"" + result + "\"}";
// }
// }
// }
// catch (Exception ex)
// {
// all_result = "{\"result\":\"false\",\"message\":\"" + ex.Message + "\"}";
// }
// }
// if (all_result == "")
// {
// // all_result = "{\"result\":\"true\",\"message\":\"\"}";
// }
// return all_result;
//}
///// <summary>
///// 删除时验证
///// </summary>
///// <param name="sys_ids"></param>
///// <returns></returns>
//public string get_resultdel(string sys_ids)
//{
// string str_result = "";
// str_result = get_resultonlyonesysid(sys_ids);
// //2018-09-07-sk-??!!-businesscode
// if (str_result != "")
// {
// return str_result;
// }
// return str_result;
//}
///// <summary>
///// 验证上图后才能转件
///// </summary>
///// <param name="sys_ids"></param>
///// <returns></returns>
//public string get_result_1_1(string sys_ids)
//{
// string str_result = "";
// str_result = get_resultmorethanonesysid(sys_ids);
// if (str_result != "")
// {
// return str_result;
// }
// return str_result;
//}
#endregion
public string set_startworkflow(string sys_id, string sys_processinsid, string selectusernames, DataSet _ds_facter, string str_shyj, string processdefid, string facterid, string clientInf, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
string result = "";
NameValueCollection nvc_maintableparameters = new NameValueCollection();
nvc_maintableparameters.Add("sys_processnextuser", selectusernames);
nvc_maintableparameters.Add("sys_processinsid", sys_processinsid);
nvc_maintableparameters.Add("processdefid", processdefid);
nvc_maintableparameters.Add("fk_tbl_maintable_sys_id", "^null");
result = _hic.NextStateItemNew(sys_id, nvc_maintableparameters, facterid, _ds_facter, str_shyj, sys_processinsid, "", clientInf, t);
#region
//改流程状态为审核中
string sql = "";
switch (processdefid)
{
case "540003": //新增水表居民
sql = " update tbl_ld_xzsb set f_zt = '审核中' , f_ztid ='1' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540004": //大用户立户
sql = " update tbl_ld_dyhlh set f_zt = '审核中' , f_ztid ='1' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540006": //大用户销户
sql = " update tbl_ld_xhhbt set f_zt = '审核中' , f_ztid ='1' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540007": //大用户报停
sql = " update tbl_ld_xhhbt set f_zt = '审核中' , f_ztid ='1' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540008": //新增水表大客户
sql = " update tbl_ld_xzsb set f_zt = '审核中' , f_ztid ='1' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540009": //更换水表居民
sql = " update tbl_ld_ghsb set f_zt = '审核中' , f_ztid ='1' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540010": //更换水表大客户
sql = " update tbl_ld_ghsb set f_zt = '审核中' , f_ztid ='1' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540011": //修改水表底数居民
sql = " update tbl_ld_xgsbds set f_zt = '审核中' , f_ztid ='1' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540012": //修改水表底数大客户
sql = " update tbl_ld_xgsbds set f_zt = '审核中' , f_ztid ='1' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540013": //申请疫情减免
sql = " update tbl_ld_yqjm set f_zt = '审核中' , f_ztid ='1' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
//asdfasd
}
#endregion
return(result);
//if (result == "")
//{
// #region businesscode
// //根据WorkFlowUserControl1.WF_ProcessDefid可以识别业务程序进行业务代码编写
// #endregion
//}
}
public string Update(string json, string columns, string type, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
_iAccessDataTrans = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans();
_iAccessDataTrans.getTrans().begin();
sara.dd.ldsw.model.tbl_ld_ickxj model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_ickxj>(json);
columns = FormatColumns(columns).Replace("^", ",");
switch (type)
{
case "xk":
{
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ld_ickxj.Update(model, columns, _iAccessDataTrans);
IList <sara.dd.ldsw.model.tbl_ld_khb> model_khb_list = _idal_tbl_ld_khb.GetList(" sys_id='" + model.f_khbhid.ToString() + "'", "", "*", "", "", _iAccessDataTrans);
if (model_khb_list.Count > 0)
{
sara.dd.ldsw.model.tbl_ld_khb model_khb = model_khb_list[0];
//判断操作类型属于新建还是补卡
if (model.f_czlxid == "08150001")
{
//新建，客户表的IC卡累积购量清0
List <IDictionary <string, string> > array = new List <IDictionary <string, string> >();
IDictionary <string, string> temp = new Dictionary <string, string>();
temp.Add("key", "f_ickljgl");
temp.Add("oldvalue", model_khb.f_ickljgl);
temp.Add("newvalue", "0");
temp.Add("name", "IC卡累积购量");
array.Add(temp);
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", model.f_khbhid.ToString(), "tbl_ld_ickxj_detail", "IC卡新建补卡", array, clientInf, _iAccessDataTrans);
model_khb.f_ickljgl = "0";
model_khb.f_value9 = "1";
}
else
{
//补卡，不需要清0IC卡累积购量
model_khb.f_value9 = "2";
}
//更新客户表
_idal_tbl_ld_khb.Update(model_khb, "f_ickljgl,f_value9", _iAccessDataTrans);
_iAccessDataTrans.getTrans().commit();
}
else
{
string errormessage = "";
if (model_khb_list.Count <= 0)
{
errormessage += "没有查询到客户信息;";
}
resultDic["result"] = "false";
resultDic["message"] = errormessage;
_iAccessDataTrans.getTrans().rollback();
}
}
break;
case "pt":
default:
{
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ld_ickxj.Update(model, columns, null);
_iAccessDataTrans.getTrans().commit();
}
break;
}
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));
}
//[sys_id]$[facterid]$[ds_facter]$[str_shyj]$[processinsid]$[fk_workflow_sys_id]$[businessclass]$[businessstate]$[processdefid]$[processactivedefid]$[trans]
public string set_doworkflowbak(string sys_id, string facterid, DataSet ds_facter, string str_shyj, string processinsid, string businessclass, string businessstate, string processdefid, string processactivedefid, string clientInf, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
string result = "";
NameValueCollection nvc_maintableparameters = new NameValueCollection();
nvc_maintableparameters.Add("sys_processnextuser", "^nextuser");
nvc_maintableparameters.Add("sys_processinsid", processinsid);
nvc_maintableparameters.Add("fk_tbl_maintable_sys_id", "^null");
result = _hic.NextStateItemNew(sys_id, nvc_maintableparameters, facterid, ds_facter, str_shyj, processinsid, processactivedefid, clientInf, t);
#region businesscode
//switch (_pr_businessclass + "_" + _pr_businessstate)
//{
// default:
// break;
//}
#region
//改流程状态为新建
string sql = "";
switch (processdefid)
{
case "540003": //新增水表居民
sql = " update tbl_ld_xzsb set f_zt = '新建' , f_ztid ='0' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540004": //大用户立户
sql = " update tbl_ld_dyhlh set f_zt = '新建' , f_ztid ='0' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540006": //大用户销户
sql = " update tbl_ld_xhhbt set f_zt = '新建' , f_ztid ='0' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540007": //大用户报停
sql = " update tbl_ld_xhhbt set f_zt = '新建' , f_ztid ='0' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540008": //新增水表大客户
sql = " update tbl_ld_xzsb set f_zt = '新建' , f_ztid ='0' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540009": //更换水表居民
sql = " update tbl_ld_ghsb set f_zt = '新建' , f_ztid ='0' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540010": //更换水表大客户
sql = " update tbl_ld_ghsb set f_zt = '新建' , f_ztid ='0' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540011": //修改水表底数居民
sql = " update tbl_ld_xgsbds set f_zt = '新建' , f_ztid ='0' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540012": //修改水表底数大客户
sql = " update tbl_ld_xgsbds set f_zt = '新建' , f_ztid ='0' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
case "540013": //申请疫情减免
sql = " update tbl_ld_yqjm set f_zt = '新建' , f_ztid ='0' where fk_tbl_maintable_sys_id ='" + sys_id + "'";
_iAccessData.ExecuteSql(sql);
break;
}
#endregion
#endregion
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="whereString"></param>
/// <param name="orderByString">sys_creatdate desc,sys_id desc</param>
/// <param name="columnsString">where、orderby条件可以在columns之外</param>
/// <param name="pageSizeString">如果为null则获取全部数据</param>
/// <param name="pageIndexString">如果为null则获取全部数据</param>
/// <returns></returns>
public List <sara.dd.ldsw.model.tbl_ld_cben> GetList(string whereString, string orderByString, string columnsString, string pageSizeString, string pageIndexString, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select " + columnsString + " from (");
strSql.Append(" select rownum rn,a.* from (");
strSql.Append(" select * from tbl_ld_cben t where");
if (whereString.Trim() == "")
{
strSql.Append(" 1=1 ");
}
else
{
strSql.Append(" " + whereString);
}
if (orderByString.Trim() == "")
{
strSql.Append(" order by sys_creatdate desc ");
}
else
{
strSql.Append(" order by " + orderByString);
}
strSql.Append(" ) a ");
strSql.Append(" ) b ");
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)));
strSql.Append(" where b.rn>='" + fromInt.ToString() + "' and b.rn <='" + toInt.ToString() + "' ");
}
DataTable resultDataTable = null;
if (t == null)
{
resultDataTable = _iAccessData.Query(strSql.ToString()).Tables[0];
}
else
{
resultDataTable = t.Query(strSql.ToString()).Tables[0];
}
List <sara.dd.ldsw.model.tbl_ld_cben> modelList = Eva.Library.Format.FormatEntityTool.FormatDataTableToModelList <sara.dd.ldsw.model.tbl_ld_cben>(resultDataTable);
if (Eva.Library.Configuration.ConfigurationManager.AppSettings["SqlEditMode"].ToString() == "parameter")
{
}
else //如果是sql形式的话，则进行textReturn
{
modelList = Eva.Library.Format.FormatTextTool.ModelListReturn(modelList);
}
return(modelList);
}