/// <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 = "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());
}
}
/// <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);
}
/// <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());
}
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 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));
}
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));
}
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>
/// 重写添加addlayerconfig
/// </summary>
/// <param name="json"></param>
/// <param name="clientInf"></param>
/// <returns></returns>
public string Add(sara.dd.ldsw.model.tbl_app_index 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_title != null)
{
strSql1.Append("f_title,");
strSql2.Append("'" + (model.f_title) + "',");
strSql3.Append(":f_title,");
parameter = new OracleParameter(":f_title", OracleType.VarChar);
parameter.Value = model.f_title;
parameterList.Add(parameter);
}
if (model.f_titleresource != null)
{
strSql1.Append("f_titleresource,");
strSql2.Append("'" + (model.f_titleresource) + "',");
strSql3.Append(":f_titleresource,");
parameter = new OracleParameter(":f_titleresource", OracleType.VarChar);
parameter.Value = model.f_titleresource;
parameterList.Add(parameter);
}
if (model.f_titletype != null)
{
strSql1.Append("f_titletype,");
strSql2.Append("'" + (model.f_titletype) + "',");
strSql3.Append(":f_titletype,");
parameter = new OracleParameter(":f_titletype", OracleType.VarChar);
parameter.Value = model.f_titletype;
parameterList.Add(parameter);
}
if (model.f_titletypeid != null)
{
strSql1.Append("f_titletypeid,");
strSql2.Append("'" + (model.f_titletypeid) + "',");
strSql3.Append(":f_titletypeid,");
parameter = new OracleParameter(":f_titletypeid", OracleType.VarChar);
parameter.Value = model.f_titletypeid;
parameterList.Add(parameter);
}
if (model.f_isrelease != null)
{
strSql1.Append("f_isrelease,");
strSql2.Append("'" + (model.f_isrelease) + "',");
strSql3.Append(":f_isrelease,");
parameter = new OracleParameter(":f_isrelease", OracleType.VarChar);
parameter.Value = model.f_isrelease;
parameterList.Add(parameter);
}
if (model.f_releasedate != null)
{
strSql1.Append("f_releasedate,");
strSql2.Append("to_date('" + model.f_releasedate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),");
strSql3.Append(":f_releasedate,");
parameter = new OracleParameter(":f_releasedate", OracleType.DateTime);
parameter.Value = model.f_releasedate;
parameterList.Add(parameter);
}
if (model.f_indextype != null)
{
strSql1.Append("f_indextype,");
strSql2.Append("'" + (model.f_indextype) + "',");
strSql3.Append(":f_indextype,");
parameter = new OracleParameter(":f_indextype", OracleType.VarChar);
parameter.Value = model.f_indextype;
parameterList.Add(parameter);
}
if (model.f_indextypeid != null)
{
strSql1.Append("f_indextypeid,");
strSql2.Append("'" + (model.f_indextypeid) + "',");
strSql3.Append(":f_indextypeid,");
parameter = new OracleParameter(":f_indextypeid", OracleType.VarChar);
parameter.Value = model.f_indextypeid;
parameterList.Add(parameter);
}
if (model.f_tag != null)
{
strSql1.Append("f_tag,");
strSql2.Append("'" + (model.f_tag) + "',");
strSql3.Append(":f_tag,");
parameter = new OracleParameter(":f_tag", OracleType.VarChar);
parameter.Value = model.f_tag;
parameterList.Add(parameter);
}
if (model.f_resume != null)
{
strSql1.Append("f_resume,");
strSql2.Append("'" + (model.f_resume) + "',");
strSql3.Append(":f_resume,");
parameter = new OracleParameter(":f_resume", OracleType.VarChar);
parameter.Value = model.f_resume;
parameterList.Add(parameter);
}
strSql.Append("insert into tbl_app_index(");
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_app_index(");
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());
}
#endregion
}
return(sid);
}
/// <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(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\":\"\"}"----》成功加入队列
*
*/
IDictionary <string, string> clientInfoDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf);
string userid = clientInfoDic["userid"];
string username = clientInfoDic["username"];
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();
#region businesscode
//businesscode
//businesscode
//注意此处时多个客户
//更新水表表，客户表的本期止码
//把客户表的f_value1,f_value2置空
//更新修改水表底数表的状态，操作人，操作时间等字段
//增加日志
string sql = "";
sql = "select f_khbh,f_sbbh,f_xsbds,f_ysbds from tbl_ld_xgsbdszb where fk_tbl_ld_xgsbds_sys_id= (select sys_id from tbl_ld_xgsbds where fk_tbl_maintable_sys_id='" + sys_idss[i].ToString() + "') ";
DataTable dt = _t.Query(sql).Tables[0];
for (int j = 0; j < dt.Rows.Count; j++)
{
DataRow dr = dt.Rows[j];
model_tbl_ld_khb = idal_tbl_ld_khb.GetList("f_khbh='" + dr["f_khbh"].ToString() + "'", "", "*", "", "", null)[0];
sql = "update tbl_ld_khb set f_bqzm='" + dr["f_xsbds"].ToString() + "',f_value1='',f_value2='' where f_khbh='" + dr["f_khbh"].ToString() + "' ";
_t.ExecuteSql(sql);
List <IDictionary <string, string> > array = new List <IDictionary <string, string> >();
IDictionary <string, string> temp = new Dictionary <string, string>();
temp.Add("key", "f_bqzm");
temp.Add("oldvalue", dr["f_ysbds"].ToString());
temp.Add("newvalue", dr["f_xsbds"].ToString());
temp.Add("name", "本期止码");
array.Add(temp);
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", model_tbl_ld_khb.sys_id.ToString(), "tbl_ld_xgsbds_detail", "修改水表底数", array, clientInf, _t);
sql = "update tbl_ld_sbb set f_bqzm='" + dr["f_xsbds"].ToString() + "' where f_khbh='" + dr["f_khbh"].ToString() + "' ";
_t.ExecuteSql(sql);
List <IDictionary <string, string> > array1 = new List <IDictionary <string, string> >();
IDictionary <string, string> temp1 = new Dictionary <string, string>();
temp1.Add("key", "f_bqzm");
temp1.Add("oldvalue", dr["f_ysbds"].ToString());
temp1.Add("newvalue", dr["f_xsbds"].ToString());
temp1.Add("name", "本期止码");
array1.Add(temp1);
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_sbb", model_tbl_ld_khb.f_sbbhid.ToString(), "tbl_ld_xgsbds_detail", "修改水表底数", array1, clientInf, _t);
}
sql = " update tbl_ld_xgsbds set f_zt = '归档' , f_ztid ='2',f_czr='" + username + "',f_czrid='" + userid + "',f_czsj=to_date('" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss') ";
sql += ",f_drr='" + username + "',f_drrid='" + userid + "',f_drsj=to_date('" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss') ";
sql += " where fk_tbl_maintable_sys_id ='" + sys_idss[i].ToString() + "'";
_t.ExecuteSql(sql);
#endregion
//调整数据状态
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>
/// 重写添加addlayerconfig
/// </summary>
/// <param name="json"></param>
/// <param name="clientInf"></param>
/// <returns></returns>
public string Add(sara.dd.ldsw.model.tbl_clob model, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
string sid = "";
if (model.sys_id <= 0)
{
if (t == null)
{
sid = GetMaxId(null).ToString();
}
else
{
sid = GetMaxId(t).ToString();
}
}
else
{
sid = model.sys_id.ToString();
}
#region sqlString
strSql1.Append("sys_id,");
strSql2.Append("'" + sid + "',");
strSql1.Append("sys_orderid,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.sys_orderid) + "',");
strSql1.Append("sys_creatuserid,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.sys_creatuserid) + "',");
strSql1.Append("sys_creatusername,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.sys_creatusername) + "',");
strSql1.Append("sys_creatdate,");
strSql2.Append("to_date('" + model.sys_creatdate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),");
strSql1.Append("sys_lastedituserid,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.sys_lastedituserid) + "',");
strSql1.Append("sys_lasteditusername,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.sys_lasteditusername) + "',");
strSql1.Append("sys_lasteditdate,");
strSql2.Append("to_date('" + model.sys_lasteditdate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),");
strSql1.Append("sys_deluserid,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.sys_deluserid) + "',");
strSql1.Append("sys_delusername,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.sys_delusername) + "',");
strSql1.Append("sys_deldate,");
strSql2.Append("to_date('" + model.sys_deldate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),");
strSql1.Append("sys_delflag,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.sys_delflag) + "',");
strSql1.Append("f_value1,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value1) + "',");
strSql1.Append("f_value2,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value2) + "',");
strSql1.Append("f_value3,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value3) + "',");
strSql1.Append("f_value4,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value4) + "',");
strSql1.Append("f_value5,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value5) + "',");
strSql1.Append("f_value6,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value6) + "',");
strSql1.Append("f_value7,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value7) + "',");
strSql1.Append("f_value8,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value8) + "',");
strSql1.Append("f_value9,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value9) + "',");
strSql1.Append("f_value10,");
strSql2.Append("'" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value10) + "',");
strSql.Append("insert into tbl_clob(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
#endregion
if (t == null)
{
_iAccessData.ExecuteSql(strSql.ToString());
}
else
{
t.ExecuteSql(strSql.ToString());
}
List <OracleParameter> parameters = new List <OracleParameter>();
List <string> paraStr = new List <string>();
if (model.f_clob != null && model.f_clob.Length > 0)
{
OracleParameter p = new OracleParameter(":f_clob", OracleType.Clob);
p.Value = Eva.Library.Format.FormatTextTool.TextFormat(model.f_clob);
parameters.Add(p);
paraStr.Add(" f_clob = :f_clob ");
}
else
{
paraStr.Add(" f_clob = null ");
}
if (paraStr.Count > 0)
{
string str = " update tbl_clob set " + string.Join(" , ", paraStr.ToArray()) + " where sys_id = '" + sid + "' ";
if (parameters.Count > 0)
{
if (t == null)
{
_iAccessData.ExecuteSql(str, parameters.ToArray());
}
else
{
t.ExecuteSql(str, parameters.ToArray());
}
}
else
{
if (t == null)
{
_iAccessData.ExecuteSql(str);
}
else
{
t.ExecuteSql(str);
}
}
}
return(sid);
}
public string dojf(string khbh, string payAmount, string czje, string shddh)
{
sara.dd.ldsw.idal.Itbl_ld_khb idal_tbl_ld_khb = new sara.dd.ldsw.dal.tbl_ld_khb();
sara.dd.ldsw.idal.Itbl_ld_jfb idal_tbl_ld_jfb = new sara.dd.ldsw.dal.tbl_ld_jfb();
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
_iAccessDataTrans = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans();
_iAccessDataTrans.getTrans().begin();
if (khbh.Length == 10)
{
//判断是否已经存在缴费记录
string count = idal_tbl_ld_jfb.GetCount("f_value2='" + shddh + "'", "false", _iAccessDataTrans);
if (Eva.Library.Text.NumberTool.Parse(count) > 0)
{
resultDic["result"] = "false";
resultDic["message"] = "该条缴费记录" + shddh + "重复付款";
_iAccessDataTrans.getTrans().rollback();
}
else
{
//无欠费充值情况
if (Eva.Library.Text.NumberTool.Parse(payAmount) == 0)
{
//客户信息
sara.dd.ldsw.model.tbl_ld_khb model_tbl_ld_khb = idal_tbl_ld_khb.GetList("f_khbh='" + khbh + "'", "", "*", "", "", _iAccessDataTrans)[0];
#region 创建缴费记录
sara.dd.ldsw.model.tbl_ld_jfb jfmodel = new model.tbl_ld_jfb();
DateTime currentTime = System.DateTime.Now;
jfmodel.sys_creatuserid = "1563";
jfmodel.sys_creatusername = "******";
jfmodel.sys_creatdate = currentTime;
jfmodel.sys_lastedituserid = "1563";
jfmodel.sys_lasteditusername = "******";
jfmodel.sys_lasteditdate = currentTime;
jfmodel.sys_deldate = DateTime.Parse("1900-01-01");
jfmodel.sys_delflag = "0";
jfmodel.f_jfbh = commonclass.commonclass.getBusinessNum("JF", "", null);
jfmodel.f_jfrq = currentTime;
jfmodel.f_jffs = "e水生活缴费";
jfmodel.f_jffsid = "05740015";
jfmodel.f_jcfs = "全额找零";
jfmodel.f_jcfsid = "05750001";
jfmodel.f_yyy = "e水生活自助缴费";
jfmodel.f_yyyid = "1563";
jfmodel.f_czsj = currentTime;
jfmodel.f_sfykfp = "false";
jfmodel.f_zt = "已提交";
jfmodel.f_ztid = "2";
jfmodel.f_khbh = model_tbl_ld_khb.f_khbh;
jfmodel.f_khbhid = model_tbl_ld_khb.sys_id.ToString();
jfmodel.f_yhbh = model_tbl_ld_khb.f_yhbh;
jfmodel.f_yhbhid = model_tbl_ld_khb.f_yhbhid;
jfmodel.f_yhm = model_tbl_ld_khb.f_yhm;
jfmodel.f_jfm = model_tbl_ld_khb.f_jfm;
jfmodel.f_dh = model_tbl_ld_khb.f_dh;
jfmodel.f_dz = model_tbl_ld_khb.f_dz;
jfmodel.f_dy = model_tbl_ld_khb.f_dy;
jfmodel.f_dyid = model_tbl_ld_khb.f_dyid;
jfmodel.f_sc = model_tbl_ld_khb.f_sc;
jfmodel.f_scid = model_tbl_ld_khb.f_scid;
jfmodel.f_qy = model_tbl_ld_khb.f_qy;
jfmodel.f_qyid = model_tbl_ld_khb.f_qyid;
jfmodel.f_pq = model_tbl_ld_khb.f_pq;
jfmodel.f_pqid = model_tbl_ld_khb.f_pqid;
jfmodel.f_sbbh = model_tbl_ld_khb.f_sbbh;
jfmodel.f_sbbhid = model_tbl_ld_khb.f_sbbhid;
jfmodel.f_sblx = model_tbl_ld_khb.f_sblx;
jfmodel.f_sblxid = model_tbl_ld_khb.f_sblxid;
jfmodel.f_yslx = model_tbl_ld_khb.f_yslx;
jfmodel.f_yslxid = model_tbl_ld_khb.f_yslxid;
jfmodel.f_lxtkhh = model_tbl_ld_khb.f_lxth;
jfmodel.f_rs = model_tbl_ld_khb.f_rs;
//增加交行待对账标志
jfmodel.f_value1 = "1";
//增加交行商户订单号
jfmodel.f_value2 = shddh;
jfmodel.f_cbbh = "";
jfmodel.f_cbbhid = "";
jfmodel.f_cbyslj = "0";
jfmodel.f_sllj = "0";
jfmodel.f_sflj = "0";
jfmodel.f_pwflj = "0";
jfmodel.f_dj = "0";
jfmodel.f_jmhyslj = "0";
jfmodel.f_khytjjzsf = model_tbl_ld_khb.f_tjjzsf;
jfmodel.f_khytjjzpwf = model_tbl_ld_khb.f_tjjzpwf;
jfmodel.f_sfsytjjz = "false";
jfmodel.f_sytjjzsf = "0";
jfmodel.f_sytjjzpwf = "0";
jfmodel.f_syhtjjzsf = model_tbl_ld_khb.f_tjjzsf;
jfmodel.f_syhtjjzpwf = model_tbl_ld_khb.f_tjjzpwf;
jfmodel.f_khyye = model_tbl_ld_khb.f_ycje;
jfmodel.f_sfsyye = "false";
jfmodel.f_syye = "0";
jfmodel.f_yhye = model_tbl_ld_khb.f_ycje;
//余额部分
jfmodel.f_khyycje = model_tbl_ld_khb.f_ye;
if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) >= Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj))
{
jfmodel.f_syycje = jfmodel.f_cbyslj;
}
else
{
jfmodel.f_syycje = jfmodel.f_khyycje;
}
//是否使用预存金额
if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) > 0)
{
jfmodel.f_sfsyycje = "true";
}
else
{
jfmodel.f_sfsyycje = "false";
}
jfmodel.f_shys = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje)), 2);
jfmodel.f_shss = Eva.Library.Text.NumberTool.GetNumberByLength(czje, 2);
//多收转预存金额
jfmodel.f_dszycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_shys)), 2);
//用后预存金额
jfmodel.f_yhycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) + Eva.Library.Text.NumberTool.Parse(jfmodel.f_dszycje)), 2);
jfmodel.f_hszl = "0";
jfmodel.f_shssdx = sara.dd.ldsw.commonclass.commonclass.num2String((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss)));
jfmodel.f_khfz = model_tbl_ld_khb.f_khfz;
jfmodel.f_khfzid = model_tbl_ld_khb.f_khfzid;
jfmodel.f_cbenbh = model_tbl_ld_khb.f_cbbh;
jfmodel.f_cbenbhid = model_tbl_ld_khb.f_cbbhid;
jfmodel.f_ljqf = model_tbl_ld_khb.f_ljqf;
jfmodel.f_jmjelj = "0";
jfmodel.f_ly = "e水生活";
jfmodel.f_lyid = "08080007";
jfmodel.f_sfjl = "";
jfmodel.f_dyjtsl = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2);
jfmodel.f_dyjtsf = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2);
jfmodel.f_dejtsl = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2);
jfmodel.f_dejtsf = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2);
jfmodel.f_dsjtsl = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2);
jfmodel.f_dsjtsf = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2);
string jfbhid = idal_tbl_ld_jfb.Add(jfmodel, _iAccessDataTrans);
#endregion
//更新客户表
string updatekh = "update TBL_LD_KHB set F_YCJE='" + jfmodel.f_yhye + "',F_TJJZSF='" + jfmodel.f_syhtjjzsf + "',F_TJJZPWF='" + jfmodel.f_syhtjjzpwf + "',F_LJQF=nvl(F_LJQF,'0')-" + jfmodel.f_cbyslj + ",f_ye = '" + jfmodel.f_yhycje + "' where sys_id='" + jfmodel.f_khbhid + "'";
int flag_kh = _iAccessDataTrans.ExecuteSql(updatekh);
//写入客户表日志
#region 写入日志
List <IDictionary <string, string> > array = new List <IDictionary <string, string> >();
IDictionary <string, string> temp = null;
#region 对比各个业务子段，将不同的写入array
if (jfmodel.f_yhye != jfmodel.f_khyye)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_ycje");
temp.Add("oldvalue", jfmodel.f_khyye);
temp.Add("newvalue", jfmodel.f_yhye);
temp.Add("name", "绿化表押金");
array.Add(temp);
}
if (jfmodel.f_yhycje != jfmodel.f_khyycje)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_ye");
temp.Add("oldvalue", jfmodel.f_khyycje);
temp.Add("newvalue", jfmodel.f_yhycje);
temp.Add("name", "余额");
array.Add(temp);
}
if (jfmodel.f_syhtjjzsf != jfmodel.f_khytjjzsf)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_tjjzsf");
temp.Add("oldvalue", jfmodel.f_khytjjzsf);
temp.Add("newvalue", jfmodel.f_syhtjjzsf);
temp.Add("name", "调价结转水费");
array.Add(temp);
}
if (jfmodel.f_syhtjjzpwf != jfmodel.f_khytjjzpwf)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_tjjzpwf");
temp.Add("oldvalue", jfmodel.f_khytjjzpwf);
temp.Add("newvalue", jfmodel.f_syhtjjzpwf);
temp.Add("name", "调价结转污水处理费");
array.Add(temp);
}
if (jfmodel.f_cbyslj == null || jfmodel.f_cbyslj == "")
{
jfmodel.f_cbyslj = "0";
}
if (model_tbl_ld_khb.f_ljqf == null || model_tbl_ld_khb.f_ljqf == "")
{
model_tbl_ld_khb.f_ljqf = "0";
}
if (double.Parse(jfmodel.f_cbyslj) > 0)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_ljqf");
temp.Add("oldvalue", model_tbl_ld_khb.f_ljqf);
temp.Add("newvalue", (double.Parse(model_tbl_ld_khb.f_ljqf) - double.Parse(jfmodel.f_cbyslj)).ToString());
temp.Add("name", "累计欠费");
array.Add(temp);
}
#endregion
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", jfmodel.f_khbhid.ToString(), "tbl_ld_jfb_detail", "缴费表", array, "", _iAccessDataTrans);
#endregion
//缴费成功
resultDic["result"] = "true";
//resultDic["message"] = jfbhid;
resultDic["message"] = jfmodel.f_yhycje;
resultDic["jfbh"] = jfmodel.f_jfbh;
_iAccessDataTrans.getTrans().commit();
}
//核实缴费信息正确性
else if (Eva.Library.Text.NumberTool.Parse(payAmount) > 0)
{
//查询该用户未缴费的抄表记录
string add_sqlStr = "sum(f_dyjtsl) as f_dyjtsl ,sum(f_dyjtsf) as f_dyjtsf ,sum(f_dejtsl) as f_dejtsl ,sum(f_dejtsf) as f_dejtsf ,sum(f_dsjtsl) as f_dsjtsl ,sum(f_dsjtsf) as f_dsjtsf ";
DataTable dt = _iAccessDataTrans.Query("select wm_concat(sys_id) as sys_id,wm_concat(f_cb_cbbh) as f_cbbh,sum(f_bqje) as f_bqje,sum(f_bqsl) as f_bqsl,sum(f_sf) as f_sf,sum(f_pwf) as f_pwf,f_yhm,REPLACE(wm_concat(f_sfjl),',','|') as f_sfjl ," + add_sqlStr + " from TBL_LD_CBIAO where f_khbh='" + khbh + "' and f_ztid='2' group by f_yhm").Tables[0];
//DataTable ye_dt = _iAccessDataTrans.Query("select NVL(f_ye,0) as f_ye from TBL_LD_KHB where f_khbh='" + khbh + "'").Tables[0];
//double ye = Eva.Library.Text.NumberTool.Parse(ye_dt.Rows[0]["f_ye"].ToString());
double bqje = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_bqje"].ToString());
double bqsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_bqsl"].ToString());
double sf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_sf"].ToString());
double pwf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_pwf"].ToString());
double f_dyjtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dyjtsl"].ToString());
double f_dyjtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dyjtsf"].ToString());
double f_dejtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dejtsl"].ToString());
double f_dejtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dejtsf"].ToString());
double f_dsjtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dsjtsl"].ToString());
double f_dsjtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dsjtsf"].ToString());
if (bqje == Eva.Library.Text.NumberTool.Parse(payAmount))
{
//客户信息
sara.dd.ldsw.model.tbl_ld_khb model_tbl_ld_khb = idal_tbl_ld_khb.GetList("f_khbh='" + khbh + "'", "", "*", "", "", _iAccessDataTrans)[0];
#region 创建缴费记录
sara.dd.ldsw.model.tbl_ld_jfb jfmodel = new model.tbl_ld_jfb();
DateTime currentTime = System.DateTime.Now;
jfmodel.sys_creatuserid = "1563";
jfmodel.sys_creatusername = "******";
jfmodel.sys_creatdate = currentTime;
jfmodel.sys_lastedituserid = "1563";
jfmodel.sys_lasteditusername = "******";
jfmodel.sys_lasteditdate = currentTime;
jfmodel.sys_deldate = DateTime.Parse("1900-01-01");
jfmodel.sys_delflag = "0";
jfmodel.f_jfbh = commonclass.commonclass.getBusinessNum("JF", "", null);
jfmodel.f_jfrq = currentTime;
jfmodel.f_jffs = "e水生活缴费";
jfmodel.f_jffsid = "05740015";
jfmodel.f_jcfs = "全额找零";
jfmodel.f_jcfsid = "05750001";
jfmodel.f_yyy = "e水生活自助缴费";
jfmodel.f_yyyid = "1563";
jfmodel.f_czsj = currentTime;
jfmodel.f_sfykfp = "false";
jfmodel.f_zt = "已提交";
jfmodel.f_ztid = "2";
jfmodel.f_khbh = model_tbl_ld_khb.f_khbh;
jfmodel.f_khbhid = model_tbl_ld_khb.sys_id.ToString();
jfmodel.f_yhbh = model_tbl_ld_khb.f_yhbh;
jfmodel.f_yhbhid = model_tbl_ld_khb.f_yhbhid;
jfmodel.f_yhm = model_tbl_ld_khb.f_yhm;
jfmodel.f_jfm = model_tbl_ld_khb.f_jfm;
jfmodel.f_dh = model_tbl_ld_khb.f_dh;
jfmodel.f_dz = model_tbl_ld_khb.f_dz;
jfmodel.f_dy = model_tbl_ld_khb.f_dy;
jfmodel.f_dyid = model_tbl_ld_khb.f_dyid;
jfmodel.f_sc = model_tbl_ld_khb.f_sc;
jfmodel.f_scid = model_tbl_ld_khb.f_scid;
jfmodel.f_qy = model_tbl_ld_khb.f_qy;
jfmodel.f_qyid = model_tbl_ld_khb.f_qyid;
jfmodel.f_pq = model_tbl_ld_khb.f_pq;
jfmodel.f_pqid = model_tbl_ld_khb.f_pqid;
jfmodel.f_sbbh = model_tbl_ld_khb.f_sbbh;
jfmodel.f_sbbhid = model_tbl_ld_khb.f_sbbhid;
jfmodel.f_sblx = model_tbl_ld_khb.f_sblx;
jfmodel.f_sblxid = model_tbl_ld_khb.f_sblxid;
jfmodel.f_yslx = model_tbl_ld_khb.f_yslx;
jfmodel.f_yslxid = model_tbl_ld_khb.f_yslxid;
jfmodel.f_lxtkhh = model_tbl_ld_khb.f_lxth;
jfmodel.f_rs = model_tbl_ld_khb.f_rs;
//增加交行待对账标志
jfmodel.f_value1 = "1";
//增加交行商户订单号
jfmodel.f_value2 = shddh;
jfmodel.f_cbbh = dt.Rows[0]["f_cbbh"].ToString();
jfmodel.f_cbbhid = dt.Rows[0]["sys_id"].ToString();
jfmodel.f_cbyslj = Eva.Library.Text.NumberTool.GetNumberByLength(bqje, 2);
jfmodel.f_sllj = Eva.Library.Text.NumberTool.GetNumberByLength(bqsl, 0);
jfmodel.f_sflj = Eva.Library.Text.NumberTool.GetNumberByLength(sf, 2);
jfmodel.f_pwflj = Eva.Library.Text.NumberTool.GetNumberByLength(pwf, 2);
jfmodel.f_dj = Eva.Library.Text.NumberTool.GetNumberByLength(Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) / Eva.Library.Text.NumberTool.Parse(jfmodel.f_sllj), 2);
jfmodel.f_jmhyslj = Eva.Library.Text.NumberTool.GetNumberByLength(bqje, 2);
jfmodel.f_khytjjzsf = model_tbl_ld_khb.f_tjjzsf;
jfmodel.f_khytjjzpwf = model_tbl_ld_khb.f_tjjzpwf;
jfmodel.f_sfsytjjz = "false";
jfmodel.f_sytjjzsf = "0";
jfmodel.f_sytjjzpwf = "0";
jfmodel.f_syhtjjzsf = model_tbl_ld_khb.f_tjjzsf;
jfmodel.f_syhtjjzpwf = model_tbl_ld_khb.f_tjjzpwf;
jfmodel.f_khyye = model_tbl_ld_khb.f_ycje;
jfmodel.f_sfsyye = "false";
jfmodel.f_syye = "0";
jfmodel.f_yhye = model_tbl_ld_khb.f_ycje;
//余额部分
jfmodel.f_khyycje = model_tbl_ld_khb.f_ye;
if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) >= Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj))
{
jfmodel.f_syycje = jfmodel.f_cbyslj;
}
else
{
jfmodel.f_syycje = jfmodel.f_khyycje;
}
//是否使用预存金额
if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) > 0)
{
jfmodel.f_sfsyycje = "true";
}
else
{
jfmodel.f_sfsyycje = "false";
}
jfmodel.f_shys = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje)), 2);
jfmodel.f_shss = Eva.Library.Text.NumberTool.GetNumberByLength(czje, 2);
//多收转预存金额
jfmodel.f_dszycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_shys)), 2);
//用后预存金额
jfmodel.f_yhycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) + Eva.Library.Text.NumberTool.Parse(jfmodel.f_dszycje)), 2);
jfmodel.f_hszl = "0";
jfmodel.f_shssdx = sara.dd.ldsw.commonclass.commonclass.num2String((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss)));
jfmodel.f_khfz = model_tbl_ld_khb.f_khfz;
jfmodel.f_khfzid = model_tbl_ld_khb.f_khfzid;
jfmodel.f_cbenbh = model_tbl_ld_khb.f_cbbh;
jfmodel.f_cbenbhid = model_tbl_ld_khb.f_cbbhid;
jfmodel.f_ljqf = model_tbl_ld_khb.f_ljqf;
jfmodel.f_jmjelj = "0";
jfmodel.f_ly = "e水生活";
jfmodel.f_lyid = "08080007";
jfmodel.f_sfjl = dt.Rows[0]["f_sfjl"].ToString();
jfmodel.f_dyjtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dyjtsl, 2);
jfmodel.f_dyjtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dyjtsf, 2);
jfmodel.f_dejtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dejtsl, 2);
jfmodel.f_dejtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dejtsf, 2);
jfmodel.f_dsjtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dsjtsl, 2);
jfmodel.f_dsjtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dsjtsf, 2);
string jfbhid = idal_tbl_ld_jfb.Add(jfmodel, _iAccessDataTrans);
#endregion
//更新抄表表
string updatecb = "update TBL_LD_CBIAO set F_ZT='已缴费',F_ZTID='3',F_JFBH='" + jfmodel.f_jfbh + "',F_JFBHID='" + jfbhid + "',F_JFSJ=to_date('" + jfmodel.f_jfrq + "','yyyy-MM-dd hh24:mi:ss') where SYS_ID in (" + dt.Rows[0]["sys_id"].ToString() + ")";
//更新客户表
string updatekh = "update TBL_LD_KHB set F_YCJE='" + jfmodel.f_yhye + "',F_TJJZSF='" + jfmodel.f_syhtjjzsf + "',F_TJJZPWF='" + jfmodel.f_syhtjjzpwf + "',F_LJQF=nvl(F_LJQF,'0')-" + jfmodel.f_cbyslj + ",f_ye = '" + jfmodel.f_yhycje + "' where sys_id='" + jfmodel.f_khbhid + "'";
int flag_cb = _iAccessDataTrans.ExecuteSql(updatecb);
int flag_kh = _iAccessDataTrans.ExecuteSql(updatekh);
//写入客户表日志
#region 写入日志
List <IDictionary <string, string> > array = new List <IDictionary <string, string> >();
IDictionary <string, string> temp = null;
#region 对比各个业务子段，将不同的写入array
if (jfmodel.f_yhye != jfmodel.f_khyye)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_ycje");
temp.Add("oldvalue", jfmodel.f_khyye);
temp.Add("newvalue", jfmodel.f_yhye);
temp.Add("name", "绿化表押金");
array.Add(temp);
}
if (jfmodel.f_yhycje != jfmodel.f_khyycje)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_ye");
temp.Add("oldvalue", jfmodel.f_khyycje);
temp.Add("newvalue", jfmodel.f_yhycje);
temp.Add("name", "余额");
array.Add(temp);
}
if (jfmodel.f_syhtjjzsf != jfmodel.f_khytjjzsf)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_tjjzsf");
temp.Add("oldvalue", jfmodel.f_khytjjzsf);
temp.Add("newvalue", jfmodel.f_syhtjjzsf);
temp.Add("name", "调价结转水费");
array.Add(temp);
}
if (jfmodel.f_syhtjjzpwf != jfmodel.f_khytjjzpwf)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_tjjzpwf");
temp.Add("oldvalue", jfmodel.f_khytjjzpwf);
temp.Add("newvalue", jfmodel.f_syhtjjzpwf);
temp.Add("name", "调价结转污水处理费");
array.Add(temp);
}
if (jfmodel.f_cbyslj == null || jfmodel.f_cbyslj == "")
{
jfmodel.f_cbyslj = "0";
}
if (model_tbl_ld_khb.f_ljqf == null || model_tbl_ld_khb.f_ljqf == "")
{
model_tbl_ld_khb.f_ljqf = "0";
}
if (double.Parse(jfmodel.f_cbyslj) > 0)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_ljqf");
temp.Add("oldvalue", model_tbl_ld_khb.f_ljqf);
temp.Add("newvalue", (double.Parse(model_tbl_ld_khb.f_ljqf) - double.Parse(jfmodel.f_cbyslj)).ToString());
temp.Add("name", "累计欠费");
array.Add(temp);
}
#endregion
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", jfmodel.f_khbhid.ToString(), "tbl_ld_jfb_detail", "缴费表", array, "", _iAccessDataTrans);
#endregion
//缴费成功
resultDic["result"] = "true";
//resultDic["message"] = jfbhid;
resultDic["message"] = jfmodel.f_yhycje;
resultDic["jfbh"] = jfmodel.f_jfbh;
_iAccessDataTrans.getTrans().commit();
}
else
{
_iAccessDataTrans.getTrans().rollback();
resultDic["result"] = "false";
resultDic["message"] = "传入缴费金额" + payAmount + "与该用户实际欠费金额" + bqje + "不符";
}
}
}
}
else
{
_iAccessDataTrans.getTrans().rollback();
resultDic["result"] = "false";
resultDic["message"] = "传入错误的客户编号" + khbh;
}
}
catch (System.Exception ex)
{
if (_iAccessDataTrans != null)
{
_iAccessDataTrans.getTrans().rollback();
}
resultDic["result"] = "false";
resultDic["message"] = "程序异常" + ex.ToString();
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public void ProcessRequest(HttpContext context)
{
try
{
Stream s = System.Web.HttpContext.Current.Request.InputStream;
byte[] b = new byte[s.Length];
s.Read(b, 0, (int)s.Length);
string message = UTF8Encoding.UTF8.GetString(b);
message = message.Replace(" ", "").Replace("\n", "").Replace("\r", "").Replace(" ", "");
message = System.Web.HttpUtility.UrlDecode(message, System.Text.Encoding.UTF8);
message = message.Replace("RSASignData=", "");
com.bocom.pay.BocomClient client = new com.bocom.pay.BocomClient();
client.initialize(Eva.Library.Global.AppRootPath + "bocommjava/ini/BocompayMerchant.xml");
string xmlstr = client.AttachedVerify(message);
string MerTranNo = "";
string khbh = "";
string amount = "";
string result = "";
if (xmlstr != null && xmlstr != "")
{
xmlstr = xmlstr.TrimEnd('0');
XmlDocument document = new XmlDocument();
document.LoadXml(xmlstr);
khbh = document.GetElementsByTagName("TranContent")[0].InnerText;
MerTranNo = document.GetElementsByTagName("MerTranNo")[0].InnerText;
amount = document.GetElementsByTagName("Amount")[0].InnerText;
result = document.GetElementsByTagName("TranState")[0].InnerText;
if (result == "SUCCESS")
{
sara.dd.ldsw.idal.Itbl_ld_khb idal_tbl_ld_khb = new sara.dd.ldsw.dal.tbl_ld_khb();
sara.dd.ldsw.idal.Itbl_ld_jfb idal_tbl_ld_jfb = new sara.dd.ldsw.dal.tbl_ld_jfb();
_iAccessDataTrans = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans();
_iAccessDataTrans.getTrans().begin();
//获取客户model
List <sara.dd.ldsw.model.tbl_ld_khb> khmodellist = idal_tbl_ld_khb.GetList(" f_khbh='" + khbh + "'", " sys_id desc", "*", "", "", _iAccessDataTrans);
if (khmodellist.Count == 1)
{
sara.dd.ldsw.model.tbl_ld_khb model_tbl_ld_khb = khmodellist[0];
//累计欠费
double ljqf = 0;
if (model_tbl_ld_khb.f_ljqf != null && model_tbl_ld_khb.f_ljqf != "")
{
ljqf = Eva.Library.Text.NumberTool.Parse(model_tbl_ld_khb.f_ljqf);
}
else
{
ljqf = 0;
}
//判断客户是否存在欠费
if (ljqf > 0)
{
//存在欠费
//查询该用户未缴费的抄表记录
string add_sqlStr = "sum(f_dyjtsl) as f_dyjtsl ,sum(f_dyjtsf) as f_dyjtsf ,sum(f_dejtsl) as f_dejtsl ,sum(f_dejtsf) as f_dejtsf ,sum(f_dsjtsl) as f_dsjtsl ,sum(f_dsjtsf) as f_dsjtsf ";
DataTable dt = _iAccessDataTrans.Query("select wm_concat(sys_id) as sys_id,wm_concat(f_cb_cbbh) as f_cbbh,sum(f_bqje) as f_bqje,sum(f_bqsl) as f_bqsl,sum(f_sf) as f_sf,sum(f_pwf) as f_pwf,f_yhm,REPLACE(wm_concat(f_sfjl),',','|') as f_sfjl ," + add_sqlStr + " from TBL_LD_CBIAO where f_khbh='" + khbh + "' and f_ztid='2' group by f_yhm").Tables[0];
//DataTable ye_dt = _iAccessDataTrans.Query("select NVL(f_ye,0) as f_ye from TBL_LD_KHB where f_khbh='" + khbh + "'").Tables[0];
//double ye = Eva.Library.Text.NumberTool.Parse(ye_dt.Rows[0]["f_ye"].ToString());
double bqje = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_bqje"].ToString());
double bqsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_bqsl"].ToString());
double sf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_sf"].ToString());
double pwf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_pwf"].ToString());
double f_dyjtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dyjtsl"].ToString());
double f_dyjtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dyjtsf"].ToString());
double f_dejtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dejtsl"].ToString());
double f_dejtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dejtsf"].ToString());
double f_dsjtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dsjtsl"].ToString());
double f_dsjtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dsjtsf"].ToString());
if (bqje == Eva.Library.Text.NumberTool.Parse(model_tbl_ld_khb.f_ljqf))
{
#region 创建缴费记录
sara.dd.ldsw.model.tbl_ld_jfb jfmodel = new model.tbl_ld_jfb();
DateTime currentTime = System.DateTime.Now;
jfmodel.sys_creatuserid = "1571";
jfmodel.sys_creatusername = "******";
jfmodel.sys_creatdate = currentTime;
jfmodel.sys_lastedituserid = "1571";
jfmodel.sys_lasteditusername = "******";
jfmodel.sys_lasteditdate = currentTime;
jfmodel.sys_deldate = DateTime.Parse("1900-01-01");
jfmodel.sys_delflag = "0";
jfmodel.f_jfbh = commonclass.commonclass.getBusinessNum("JF", "", null);
jfmodel.f_jfrq = currentTime;
jfmodel.f_jffs = "缴费机自助缴费";
jfmodel.f_jffsid = "05740017";
jfmodel.f_jcfs = "全额找零";
jfmodel.f_jcfsid = "05750001";
jfmodel.f_yyy = "营业厅缴费机";
jfmodel.f_yyyid = "1571";
jfmodel.f_czsj = currentTime;
jfmodel.f_sfykfp = "false";
jfmodel.f_zt = "已提交";
jfmodel.f_ztid = "2";
jfmodel.f_khbh = model_tbl_ld_khb.f_khbh;
jfmodel.f_khbhid = model_tbl_ld_khb.sys_id.ToString();
jfmodel.f_yhbh = model_tbl_ld_khb.f_yhbh;
jfmodel.f_yhbhid = model_tbl_ld_khb.f_yhbhid;
jfmodel.f_yhm = model_tbl_ld_khb.f_yhm;
jfmodel.f_jfm = model_tbl_ld_khb.f_jfm;
jfmodel.f_dh = model_tbl_ld_khb.f_dh;
jfmodel.f_dz = model_tbl_ld_khb.f_dz;
jfmodel.f_dy = model_tbl_ld_khb.f_dy;
jfmodel.f_dyid = model_tbl_ld_khb.f_dyid;
jfmodel.f_sc = model_tbl_ld_khb.f_sc;
jfmodel.f_scid = model_tbl_ld_khb.f_scid;
jfmodel.f_qy = model_tbl_ld_khb.f_qy;
jfmodel.f_qyid = model_tbl_ld_khb.f_qyid;
jfmodel.f_pq = model_tbl_ld_khb.f_pq;
jfmodel.f_pqid = model_tbl_ld_khb.f_pqid;
jfmodel.f_sbbh = model_tbl_ld_khb.f_sbbh;
jfmodel.f_sbbhid = model_tbl_ld_khb.f_sbbhid;
jfmodel.f_sblx = model_tbl_ld_khb.f_sblx;
jfmodel.f_sblxid = model_tbl_ld_khb.f_sblxid;
jfmodel.f_yslx = model_tbl_ld_khb.f_yslx;
jfmodel.f_yslxid = model_tbl_ld_khb.f_yslxid;
jfmodel.f_lxtkhh = model_tbl_ld_khb.f_lxth;
jfmodel.f_rs = model_tbl_ld_khb.f_rs;
//增加交行待对账标志
jfmodel.f_value1 = "1";
//增加交行商户订单号
jfmodel.f_value2 = MerTranNo;
jfmodel.f_cbbh = dt.Rows[0]["f_cbbh"].ToString();
jfmodel.f_cbbhid = dt.Rows[0]["sys_id"].ToString();
jfmodel.f_cbyslj = Eva.Library.Text.NumberTool.GetNumberByLength(bqje, 2);
jfmodel.f_sllj = Eva.Library.Text.NumberTool.GetNumberByLength(bqsl, 0);
jfmodel.f_sflj = Eva.Library.Text.NumberTool.GetNumberByLength(sf, 2);
jfmodel.f_pwflj = Eva.Library.Text.NumberTool.GetNumberByLength(pwf, 2);
jfmodel.f_dj = Eva.Library.Text.NumberTool.GetNumberByLength(Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) / Eva.Library.Text.NumberTool.Parse(jfmodel.f_sllj), 2);
jfmodel.f_jmhyslj = Eva.Library.Text.NumberTool.GetNumberByLength(bqje, 2);
jfmodel.f_khytjjzsf = model_tbl_ld_khb.f_tjjzsf;
jfmodel.f_khytjjzpwf = model_tbl_ld_khb.f_tjjzpwf;
jfmodel.f_sfsytjjz = "false";
jfmodel.f_sytjjzsf = "0";
jfmodel.f_sytjjzpwf = "0";
jfmodel.f_syhtjjzsf = model_tbl_ld_khb.f_tjjzsf;
jfmodel.f_syhtjjzpwf = model_tbl_ld_khb.f_tjjzpwf;
jfmodel.f_khyye = model_tbl_ld_khb.f_ycje;
jfmodel.f_sfsyye = "false";
jfmodel.f_syye = "0";
jfmodel.f_yhye = model_tbl_ld_khb.f_ycje;
//余额部分
jfmodel.f_khyycje = model_tbl_ld_khb.f_ye;
if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) >= Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj))
{
jfmodel.f_syycje = jfmodel.f_cbyslj;
}
else
{
jfmodel.f_syycje = jfmodel.f_khyycje;
}
//是否使用预存金额
if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) > 0)
{
jfmodel.f_sfsyycje = "true";
}
else
{
jfmodel.f_sfsyycje = "false";
}
jfmodel.f_shys = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje)), 2);
jfmodel.f_shss = Eva.Library.Text.NumberTool.GetNumberByLength(amount, 2);
//多收转预存金额
jfmodel.f_dszycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_shys)), 2);
//用后预存金额
jfmodel.f_yhycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) + Eva.Library.Text.NumberTool.Parse(jfmodel.f_dszycje)), 2);
jfmodel.f_hszl = "0";
jfmodel.f_shssdx = sara.dd.ldsw.commonclass.commonclass.num2String((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss)));
jfmodel.f_khfz = model_tbl_ld_khb.f_khfz;
jfmodel.f_khfzid = model_tbl_ld_khb.f_khfzid;
jfmodel.f_cbenbh = model_tbl_ld_khb.f_cbbh;
jfmodel.f_cbenbhid = model_tbl_ld_khb.f_cbbhid;
jfmodel.f_ljqf = model_tbl_ld_khb.f_ljqf;
jfmodel.f_jmjelj = "0";
jfmodel.f_ly = "缴费机";
jfmodel.f_lyid = "08080010";
jfmodel.f_sfjl = dt.Rows[0]["f_sfjl"].ToString();
jfmodel.f_dyjtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dyjtsl, 2);
jfmodel.f_dyjtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dyjtsf, 2);
jfmodel.f_dejtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dejtsl, 2);
jfmodel.f_dejtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dejtsf, 2);
jfmodel.f_dsjtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dsjtsl, 2);
jfmodel.f_dsjtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dsjtsf, 2);
string jfbhid = idal_tbl_ld_jfb.Add(jfmodel, _iAccessDataTrans);
#endregion
//更新抄表表
string updatecb = "update TBL_LD_CBIAO set F_ZT='已缴费',F_ZTID='3',F_JFBH='" + jfmodel.f_jfbh + "',F_JFBHID='" + jfbhid + "',F_JFSJ=to_date('" + jfmodel.f_jfrq + "','yyyy-MM-dd hh24:mi:ss') where SYS_ID in (" + dt.Rows[0]["sys_id"].ToString() + ")";
//更新客户表
string updatekh = "update TBL_LD_KHB set F_YCJE='" + jfmodel.f_yhye + "',F_TJJZSF='" + jfmodel.f_syhtjjzsf + "',F_TJJZPWF='" + jfmodel.f_syhtjjzpwf + "',F_LJQF=nvl(F_LJQF,'0')-" + jfmodel.f_cbyslj + ",f_ye = '" + jfmodel.f_yhycje + "' where sys_id='" + jfmodel.f_khbhid + "'";
int flag_cb = _iAccessDataTrans.ExecuteSql(updatecb);
int flag_kh = _iAccessDataTrans.ExecuteSql(updatekh);
//写入客户表日志
#region 写入日志
List <IDictionary <string, string> > array = new List <IDictionary <string, string> >();
IDictionary <string, string> temp = null;
#region 对比各个业务子段，将不同的写入array
if (jfmodel.f_yhye != jfmodel.f_khyye)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_ycje");
temp.Add("oldvalue", jfmodel.f_khyye);
temp.Add("newvalue", jfmodel.f_yhye);
temp.Add("name", "绿化表押金");
array.Add(temp);
}
if (jfmodel.f_yhycje != jfmodel.f_khyycje)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_ye");
temp.Add("oldvalue", jfmodel.f_khyycje);
temp.Add("newvalue", jfmodel.f_yhycje);
temp.Add("name", "余额");
array.Add(temp);
}
if (jfmodel.f_syhtjjzsf != jfmodel.f_khytjjzsf)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_tjjzsf");
temp.Add("oldvalue", jfmodel.f_khytjjzsf);
temp.Add("newvalue", jfmodel.f_syhtjjzsf);
temp.Add("name", "调价结转水费");
array.Add(temp);
}
if (jfmodel.f_syhtjjzpwf != jfmodel.f_khytjjzpwf)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_tjjzpwf");
temp.Add("oldvalue", jfmodel.f_khytjjzpwf);
temp.Add("newvalue", jfmodel.f_syhtjjzpwf);
temp.Add("name", "调价结转污水处理费");
array.Add(temp);
}
if (jfmodel.f_cbyslj == null || jfmodel.f_cbyslj == "")
{
jfmodel.f_cbyslj = "0";
}
if (model_tbl_ld_khb.f_ljqf == null || model_tbl_ld_khb.f_ljqf == "")
{
model_tbl_ld_khb.f_ljqf = "0";
}
if (double.Parse(jfmodel.f_cbyslj) > 0)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_ljqf");
temp.Add("oldvalue", model_tbl_ld_khb.f_ljqf);
temp.Add("newvalue", (double.Parse(model_tbl_ld_khb.f_ljqf) - double.Parse(jfmodel.f_cbyslj)).ToString());
temp.Add("name", "累计欠费");
array.Add(temp);
}
#endregion
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", jfmodel.f_khbhid.ToString(), "tbl_ld_jfb_detail", "缴费表", array, "", _iAccessDataTrans);
#endregion
_iAccessDataTrans.getTrans().commit();
}
else
{
_iAccessDataTrans.getTrans().rollback();
}
}
else
{
//不存在欠费
#region 创建缴费记录
sara.dd.ldsw.model.tbl_ld_jfb jfmodel = new model.tbl_ld_jfb();
DateTime currentTime = System.DateTime.Now;
jfmodel.sys_creatuserid = "1571";
jfmodel.sys_creatusername = "******";
jfmodel.sys_creatdate = currentTime;
jfmodel.sys_lastedituserid = "1571";
jfmodel.sys_lasteditusername = "******";
jfmodel.sys_lasteditdate = currentTime;
jfmodel.sys_deldate = DateTime.Parse("1900-01-01");
jfmodel.sys_delflag = "0";
jfmodel.f_jfbh = commonclass.commonclass.getBusinessNum("JF", "", null);
jfmodel.f_jfrq = currentTime;
jfmodel.f_jffs = "缴费机自助缴费";
jfmodel.f_jffsid = "05740017";
jfmodel.f_jcfs = "全额找零";
jfmodel.f_jcfsid = "05750001";
jfmodel.f_yyy = "营业厅缴费机";
jfmodel.f_yyyid = "1571";
jfmodel.f_czsj = currentTime;
jfmodel.f_sfykfp = "false";
jfmodel.f_zt = "已提交";
jfmodel.f_ztid = "2";
jfmodel.f_khbh = model_tbl_ld_khb.f_khbh;
jfmodel.f_khbhid = model_tbl_ld_khb.sys_id.ToString();
jfmodel.f_yhbh = model_tbl_ld_khb.f_yhbh;
jfmodel.f_yhbhid = model_tbl_ld_khb.f_yhbhid;
jfmodel.f_yhm = model_tbl_ld_khb.f_yhm;
jfmodel.f_jfm = model_tbl_ld_khb.f_jfm;
jfmodel.f_dh = model_tbl_ld_khb.f_dh;
jfmodel.f_dz = model_tbl_ld_khb.f_dz;
jfmodel.f_dy = model_tbl_ld_khb.f_dy;
jfmodel.f_dyid = model_tbl_ld_khb.f_dyid;
jfmodel.f_sc = model_tbl_ld_khb.f_sc;
jfmodel.f_scid = model_tbl_ld_khb.f_scid;
jfmodel.f_qy = model_tbl_ld_khb.f_qy;
jfmodel.f_qyid = model_tbl_ld_khb.f_qyid;
jfmodel.f_pq = model_tbl_ld_khb.f_pq;
jfmodel.f_pqid = model_tbl_ld_khb.f_pqid;
jfmodel.f_sbbh = model_tbl_ld_khb.f_sbbh;
jfmodel.f_sbbhid = model_tbl_ld_khb.f_sbbhid;
jfmodel.f_sblx = model_tbl_ld_khb.f_sblx;
jfmodel.f_sblxid = model_tbl_ld_khb.f_sblxid;
jfmodel.f_yslx = model_tbl_ld_khb.f_yslx;
jfmodel.f_yslxid = model_tbl_ld_khb.f_yslxid;
jfmodel.f_lxtkhh = model_tbl_ld_khb.f_lxth;
jfmodel.f_rs = model_tbl_ld_khb.f_rs;
//增加交行待对账标志
jfmodel.f_value1 = "1";
//增加交行商户订单号
jfmodel.f_value2 = MerTranNo;
jfmodel.f_cbbh = "";
jfmodel.f_cbbhid = "";
jfmodel.f_cbyslj = "0";
jfmodel.f_sllj = "0";
jfmodel.f_sflj = "0";
jfmodel.f_pwflj = "0";
jfmodel.f_dj = "0";
jfmodel.f_jmhyslj = "0";
jfmodel.f_khytjjzsf = model_tbl_ld_khb.f_tjjzsf;
jfmodel.f_khytjjzpwf = model_tbl_ld_khb.f_tjjzpwf;
jfmodel.f_sfsytjjz = "false";
jfmodel.f_sytjjzsf = "0";
jfmodel.f_sytjjzpwf = "0";
jfmodel.f_syhtjjzsf = model_tbl_ld_khb.f_tjjzsf;
jfmodel.f_syhtjjzpwf = model_tbl_ld_khb.f_tjjzpwf;
jfmodel.f_khyye = model_tbl_ld_khb.f_ycje;
jfmodel.f_sfsyye = "false";
jfmodel.f_syye = "0";
jfmodel.f_yhye = model_tbl_ld_khb.f_ycje;
//余额部分
jfmodel.f_khyycje = model_tbl_ld_khb.f_ye;
if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) >= Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj))
{
jfmodel.f_syycje = jfmodel.f_cbyslj;
}
else
{
jfmodel.f_syycje = jfmodel.f_khyycje;
}
//是否使用预存金额
if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) > 0)
{
jfmodel.f_sfsyycje = "true";
}
else
{
jfmodel.f_sfsyycje = "false";
}
jfmodel.f_shys = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje)), 2);
jfmodel.f_shss = Eva.Library.Text.NumberTool.GetNumberByLength(amount, 2);
//多收转预存金额
jfmodel.f_dszycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_shys)), 2);
//用后预存金额
jfmodel.f_yhycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) + Eva.Library.Text.NumberTool.Parse(jfmodel.f_dszycje)), 2);
jfmodel.f_hszl = "0";
jfmodel.f_shssdx = sara.dd.ldsw.commonclass.commonclass.num2String((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss)));
jfmodel.f_khfz = model_tbl_ld_khb.f_khfz;
jfmodel.f_khfzid = model_tbl_ld_khb.f_khfzid;
jfmodel.f_cbenbh = model_tbl_ld_khb.f_cbbh;
jfmodel.f_cbenbhid = model_tbl_ld_khb.f_cbbhid;
jfmodel.f_ljqf = model_tbl_ld_khb.f_ljqf;
jfmodel.f_jmjelj = "0";
jfmodel.f_ly = "缴费机";
jfmodel.f_lyid = "08080010";
jfmodel.f_sfjl = "";
jfmodel.f_dyjtsl = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2);
jfmodel.f_dyjtsf = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2);
jfmodel.f_dejtsl = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2);
jfmodel.f_dejtsf = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2);
jfmodel.f_dsjtsl = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2);
jfmodel.f_dsjtsf = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2);
string jfbhid = idal_tbl_ld_jfb.Add(jfmodel, _iAccessDataTrans);
#endregion
//更新客户表
string updatekh = "update TBL_LD_KHB set F_YCJE='" + jfmodel.f_yhye + "',F_TJJZSF='" + jfmodel.f_syhtjjzsf + "',F_TJJZPWF='" + jfmodel.f_syhtjjzpwf + "',F_LJQF=nvl(F_LJQF,'0')-" + jfmodel.f_cbyslj + ",f_ye = '" + jfmodel.f_yhycje + "' where sys_id='" + jfmodel.f_khbhid + "'";
int flag_kh = _iAccessDataTrans.ExecuteSql(updatekh);
//写入客户表日志
#region 写入日志
List <IDictionary <string, string> > array = new List <IDictionary <string, string> >();
IDictionary <string, string> temp = null;
#region 对比各个业务子段，将不同的写入array
if (jfmodel.f_yhye != jfmodel.f_khyye)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_ycje");
temp.Add("oldvalue", jfmodel.f_khyye);
temp.Add("newvalue", jfmodel.f_yhye);
temp.Add("name", "绿化表押金");
array.Add(temp);
}
if (jfmodel.f_yhycje != jfmodel.f_khyycje)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_ye");
temp.Add("oldvalue", jfmodel.f_khyycje);
temp.Add("newvalue", jfmodel.f_yhycje);
temp.Add("name", "余额");
array.Add(temp);
}
if (jfmodel.f_syhtjjzsf != jfmodel.f_khytjjzsf)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_tjjzsf");
temp.Add("oldvalue", jfmodel.f_khytjjzsf);
temp.Add("newvalue", jfmodel.f_syhtjjzsf);
temp.Add("name", "调价结转水费");
array.Add(temp);
}
if (jfmodel.f_syhtjjzpwf != jfmodel.f_khytjjzpwf)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_tjjzpwf");
temp.Add("oldvalue", jfmodel.f_khytjjzpwf);
temp.Add("newvalue", jfmodel.f_syhtjjzpwf);
temp.Add("name", "调价结转污水处理费");
array.Add(temp);
}
if (jfmodel.f_cbyslj == null || jfmodel.f_cbyslj == "")
{
jfmodel.f_cbyslj = "0";
}
if (model_tbl_ld_khb.f_ljqf == null || model_tbl_ld_khb.f_ljqf == "")
{
model_tbl_ld_khb.f_ljqf = "0";
}
if (double.Parse(jfmodel.f_cbyslj) > 0)
{
temp = new Dictionary <string, string>();
temp.Add("key", "f_ljqf");
temp.Add("oldvalue", model_tbl_ld_khb.f_ljqf);
temp.Add("newvalue", (double.Parse(model_tbl_ld_khb.f_ljqf) - double.Parse(jfmodel.f_cbyslj)).ToString());
temp.Add("name", "累计欠费");
array.Add(temp);
}
#endregion
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", jfmodel.f_khbhid.ToString(), "tbl_ld_jfb_detail", "缴费表", array, "", _iAccessDataTrans);
#endregion
//缴费成功
_iAccessDataTrans.getTrans().commit();
}
}
}
}
DateTime now = DateTime.Now;
//证书号
string certid = Eva.Library.Configuration.ConfigurationManager.AppSettings["certid"].ToString();
string rsptime = now.ToString("yyyyMMddHHmmss");
string responsestr = "<?xml version='1.0' encoding='UTF-8'?><Document><Head><RspType>NORMAL</RspType><RspCode>MAPIPY0000</RspCode><RspMsg>交易成功</RspMsg><RspTime>" + rsptime + "</RspTime></Head><Body><MerTranNo>" + MerTranNo + "</MerTranNo></Body></Document>";
string rsasign = client.AttachedSign(certid, responsestr);
//rsasign = System.Web.HttpUtility.UrlEncode(rsasign, System.Text.Encoding.UTF8);
//StringBuilder builder = new StringBuilder();
//builder.AppendFormat("{0}={1}", "RSASignData", rsasign.Replace("\n", "").Replace("\r", ""));
context.Response.ContentType = "text/plain";
//context.Response.ContentType = "text/xml";
context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
context.Response.Charset = "UTF-8";
context.Response.Write(rsasign);
}
catch (System.Exception ex)
{
if (_iAccessDataTrans != null)
{
_iAccessDataTrans.getTrans().rollback();
}
}
}
/// <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_clob model, string columns, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
String[] columnsArray = columns.Split(',');
List <string> columsList = new List <string>(columnsArray);
#region sqlString
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbl_clob set ");
if (model.sys_orderid != null && columsList.Contains("sys_orderid"))
{
strSql.Append("sys_orderid='" + Eva.Library.Format.FormatTextTool.TextFormat(model.sys_orderid) + "',");
}
if (model.sys_creatuserid != null && columsList.Contains("sys_creatuserid"))
{
strSql.Append("sys_creatuserid='" + Eva.Library.Format.FormatTextTool.TextFormat(model.sys_creatuserid) + "',");
}
if (model.sys_creatusername != null && columsList.Contains("sys_creatusername"))
{
strSql.Append("sys_creatusername='******',");
}
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'),");
}
if (model.sys_lastedituserid != null && columsList.Contains("sys_lastedituserid"))
{
strSql.Append("sys_lastedituserid='" + Eva.Library.Format.FormatTextTool.TextFormat(model.sys_lastedituserid) + "',");
}
if (model.sys_lasteditusername != null && columsList.Contains("sys_lasteditusername"))
{
strSql.Append("sys_lasteditusername='******',");
}
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'),");
}
if (model.sys_deluserid != null && columsList.Contains("sys_deluserid"))
{
strSql.Append("sys_deluserid='" + Eva.Library.Format.FormatTextTool.TextFormat(model.sys_deluserid) + "',");
}
if (model.sys_delusername != null && columsList.Contains("sys_delusername"))
{
strSql.Append("sys_delusername='******',");
}
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'),");
}
if (model.sys_delflag != null && columsList.Contains("sys_delflag"))
{
strSql.Append("sys_delflag='" + Eva.Library.Format.FormatTextTool.TextFormat(model.sys_delflag) + "',");
}
if (model.f_value1 != null && columsList.Contains("f_value1"))
{
strSql.Append("f_value1='" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value1) + "',");
}
if (model.f_value2 != null && columsList.Contains("f_value2"))
{
strSql.Append("f_value2='" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value2) + "',");
}
if (model.f_value3 != null && columsList.Contains("f_value3"))
{
strSql.Append("f_value3='" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value3) + "',");
}
if (model.f_value4 != null && columsList.Contains("f_value4"))
{
strSql.Append("f_value4='" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value4) + "',");
}
if (model.f_value5 != null && columsList.Contains("f_value5"))
{
strSql.Append("f_value5='" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value5) + "',");
}
if (model.f_value6 != null && columsList.Contains("f_value6"))
{
strSql.Append("f_value6='" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value6) + "',");
}
if (model.f_value7 != null && columsList.Contains("f_value7"))
{
strSql.Append("f_value7='" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value7) + "',");
}
if (model.f_value8 != null && columsList.Contains("f_value8"))
{
strSql.Append("f_value8='" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value8) + "',");
}
if (model.f_value9 != null && columsList.Contains("f_value9"))
{
strSql.Append("f_value9='" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value9) + "',");
}
if (model.f_value10 != null && columsList.Contains("f_value10"))
{
strSql.Append("f_value10='" + Eva.Library.Format.FormatTextTool.TextFormat(model.f_value10) + "',");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where sys_id='" + model.sys_id + "'");
#endregion
int columscount = 0;
if (t == null)
{
columscount += _iAccessData.ExecuteSql(strSql.ToString());
}
else
{
columscount += t.ExecuteSql(strSql.ToString());
}
List <OracleParameter> parameters = new List <OracleParameter>();
List <string> paraStr = new List <string>();
if (columsList.Contains("f_clob"))
{
if (model.f_clob != null && model.f_clob.Length > 0)
{
OracleParameter p = new OracleParameter(":f_clob", OracleType.Clob);
p.Value = Eva.Library.Format.FormatTextTool.TextFormat(model.f_clob);
parameters.Add(p);
paraStr.Add(" f_clob = :f_clob ");
}
else
{
paraStr.Add(" f_clob = null ");
}
}
if (paraStr.Count > 0)
{
string str = " update tbl_clob set " + string.Join(" , ", paraStr.ToArray()) + " where sys_id = '" + model.sys_id + "' ";
if (parameters.Count > 0)
{
if (t == null)
{
columscount = _iAccessData.ExecuteSql(str, parameters.ToArray());
}
else
{
columscount = t.ExecuteSql(str, parameters.ToArray());
}
}
else
{
if (t == null)
{
columscount = _iAccessData.ExecuteSql(str);
}
else
{
columscount = t.ExecuteSql(str);
}
}
}
return(columscount.ToString());
}
public string Update(string json, string type, string columns, 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;
if (type == "jm")
{
#region 减免并更新数据
string updatesql = "update TBL_LD_CBIAO set F_JMBH='" + model.f_jmbh + "',F_JMBHID='" + model.sys_id + "',F_JMJE='" + model.f_jmje + "' where SYS_ID='" + model.f_cbbhid + "'";
int flag = t.ExecuteSql(updatesql);
if (flag < 0)
{
resultDic["result"] = "false";
resultDic["message"] = "错误，更新抄表表时出现错误。";
t.getTrans().rollback();
}
else
{
columns = FormatColumns(columns).Replace("^", ",");
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ld_jmb.Update(model, columns, t);
t.getTrans().commit();
NewLog("数据更新成功，更新的数据为：json：" + json + "，columns：" + columns, "sql_update", clientInf);
}
#endregion
}
else if (type == "hg")
{
#region 回滚
//关于读取tbl_ld_cbiao表的数据--只查询运行库中的抄表记录，前端程序控制，历史库中的抄表的减免数据不能回滚
//所以两个时间都传空，实现只查询本表
//判断对应的缴费记录是否已经缴费
IList <sara.dd.ldsw.model.tbl_ld_cbiao> model_cbiao_list = _idal_tbl_ld_cbiao.GetList(" sys_id='" + model.f_cbbhid.ToString() + "'", "", "", "*", "", "", t);
if (model_cbiao_list.Count > 0)
{
sara.dd.ldsw.model.tbl_ld_cbiao model_cbiao = model_cbiao_list[0];
if (model_cbiao.f_ztid == "2")
{
string updatesql = "update TBL_LD_CBIAO set F_JMBH='',F_JMBHID='',F_JMJE='0' where SYS_ID='" + model.f_cbbhid + "'";
int flag = t.ExecuteSql(updatesql);
if (flag < 0)
{
resultDic["result"] = "false";
resultDic["message"] = "错误，更新抄表表时出现错误。";
t.getTrans().rollback();
}
else
{
columns = FormatColumns(columns).Replace("^", ",");
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ld_jmb.Update(model, columns, t);
#region 减免回滚日志
List <IDictionary <string, string> > array1 = new List <IDictionary <string, string> >();
IDictionary <string, string> temp1 = null;
temp1 = new Dictionary <string, string>();
temp1.Add("key", "rollback");
temp1.Add("oldvalue", "客户编号： " + model_cbiao.f_khbh + " 抄表编号：" + model_cbiao.f_cb_cbbh + " 减免编号： " + model.f_jmbh);
temp1.Add("newvalue", "");
temp1.Add("name", "减免回滚");
array1.Add(temp1);
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_jmb", model.sys_id.ToString(), "tbl_ld_jmb_detail", "减免回滚", array1, clientInf, t);
#endregion
t.getTrans().commit();
NewLog("数据更新成功，更新的数据为：json：" + json + "，columns：" + columns, "sql_update", clientInf);
}
}
else
{
//回滚数据已经改变状态
resultDic["result"] = "false";
resultDic["message"] = "错误，选择的减免信息所对应的抄表记录状态不为已算费。";
t.getTrans().rollback();
}
}
else
{
//回滚数据已经改变状态
resultDic["result"] = "false";
resultDic["message"] = "错误，选择的减免信息所对应的抄表记录不存在于运行库中。";
t.getTrans().rollback();
}
#endregion
}
else if (type == "pt")
{
columns = FormatColumns(columns).Replace("^", ",");
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ld_jmb.Update(model, columns, t);
t.getTrans().commit();
NewLog("数据更新成功，更新的数据为：json：" + json + "，columns：" + columns, "sql_update", clientInf);
}
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);
NewLog("数据更新失败，更新的数据为：json：" + json + "，columns：" + columns + "，异常信息：" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_update", clientInf);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
/// <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_app_version 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_app_version set ");
strSql_use.Append("update tbl_app_version 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_appversion != null && columsList.Contains("f_appversion"))
{
strSql.Append("f_appversion='" + (model.f_appversion) + "',");
strSql_use.Append("f_appversion=:f_appversion,");
parameter = new OracleParameter(":f_appversion", OracleType.VarChar);
parameter.Value = model.f_appversion;
parameterList.Add(parameter);
}
if (model.f_htmlversion != null && columsList.Contains("f_htmlversion"))
{
strSql.Append("f_htmlversion='" + (model.f_htmlversion) + "',");
strSql_use.Append("f_htmlversion=:f_htmlversion,");
parameter = new OracleParameter(":f_htmlversion", OracleType.VarChar);
parameter.Value = model.f_htmlversion;
parameterList.Add(parameter);
}
if (model.f_codeversion != null && columsList.Contains("f_codeversion"))
{
strSql.Append("f_codeversion='" + (model.f_codeversion) + "',");
strSql_use.Append("f_codeversion=:f_codeversion,");
parameter = new OracleParameter(":f_codeversion", OracleType.VarChar);
parameter.Value = model.f_codeversion;
parameterList.Add(parameter);
}
if (model.f_colorversion != null && columsList.Contains("f_colorversion"))
{
strSql.Append("f_colorversion='" + (model.f_colorversion) + "',");
strSql_use.Append("f_colorversion=:f_colorversion,");
parameter = new OracleParameter(":f_colorversion", OracleType.VarChar);
parameter.Value = model.f_colorversion;
parameterList.Add(parameter);
}
if (model.f_comment != null && columsList.Contains("f_comment"))
{
strSql.Append("f_comment='" + (model.f_comment) + "',");
strSql_use.Append("f_comment=:f_comment,");
parameter = new OracleParameter(":f_comment", OracleType.Clob);
if (model.f_comment == "")
{
parameter.Value = " ";
}
else
{
parameter.Value = model.f_comment;
}
parameterList.Add(parameter);
}
if (model.f_status != null && columsList.Contains("f_status"))
{
strSql.Append("f_status='" + (model.f_status) + "',");
strSql_use.Append("f_status=:f_status,");
parameter = new OracleParameter(":f_status", OracleType.VarChar);
parameter.Value = model.f_status;
parameterList.Add(parameter);
}
if (model.f_apptype != null && columsList.Contains("f_apptype"))
{
strSql.Append("f_apptype='" + (model.f_apptype) + "',");
strSql_use.Append("f_apptype=:f_apptype,");
parameter = new OracleParameter(":f_apptype", OracleType.VarChar);
parameter.Value = model.f_apptype;
parameterList.Add(parameter);
}
if (model.f_apptypeid != null && columsList.Contains("f_apptypeid"))
{
strSql.Append("f_apptypeid='" + (model.f_apptypeid) + "',");
strSql_use.Append("f_apptypeid=:f_apptypeid,");
parameter = new OracleParameter(":f_apptypeid", OracleType.VarChar);
parameter.Value = model.f_apptypeid;
parameterList.Add(parameter);
}
if (model.f_appstatus != null && columsList.Contains("f_appstatus"))
{
strSql.Append("f_appstatus='" + (model.f_appstatus) + "',");
strSql_use.Append("f_appstatus=:f_appstatus,");
parameter = new OracleParameter(":f_appstatus", OracleType.VarChar);
parameter.Value = model.f_appstatus;
parameterList.Add(parameter);
}
if (model.f_appstatusid != null && columsList.Contains("f_appstatusid"))
{
strSql.Append("f_appstatusid='" + (model.f_appstatusid) + "',");
strSql_use.Append("f_appstatusid=:f_appstatusid,");
parameter = new OracleParameter(":f_appstatusid", OracleType.VarChar);
parameter.Value = model.f_appstatusid;
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());
}
List <string> paraStrList = new List <string>();
List <OracleParameter> pList = new List <OracleParameter>();
OracleParameter p = null;
if (columsList.Contains("f_comment"))
{
if (model.f_comment != null && model.f_comment.Length > 0)
{
p = new OracleParameter(":f_comment", OracleType.Clob);
p.Value = (model.f_comment);
pList.Add(p);
paraStrList.Add(" f_comment = :f_comment ");
}
else
{
paraStrList.Add(" f_comment = null ");
}
}
if (paraStrList.Count > 0)
{
string updateSqlString = " update tbl_app_version set " + string.Join(" , ", paraStrList.ToArray()) + " where sys_id = '" + model.sys_id + "' ";
if (pList.Count > 0)
{
if (t == null)
{
columscount = _iAccessData.ExecuteSql(updateSqlString, pList.ToArray());
}
else
{
columscount = t.ExecuteSql(updateSqlString, pList.ToArray());
}
}
}
#endregion
}
return(columscount.ToString());
}
public string RegisterUser(string userLoginNameString, string userPasswordString, string userNameString, string userTypeString, string clientInf)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
Eva.Library.Data.AccessDataTrans.IAccessDataTrans t = null;
string sql = "";
try
{
IDictionary <String, String> userInfDic = commonclass.commonclass.CheckClientInf(clientInf);
if (userInfDic == null)
{
resultDic["result"] = "false";
resultDic["message"] = "客户端信息错误";
}
else
{
t = commonclass.commonclass.CreateIAccessDataTrans();
t.getTrans().begin();
#region t_user
sara.platform.operation.auth.idal.It_user _idal_t_user = new sara.platform.operation.auth.dal.oracledal.t_user();
sara.platform.operation.auth.model.t_user model = new platform.operation.auth.model.t_user();
model.u_id = "";
model.u_code = userLoginNameString;
model.u_pwd = sara.platform.service.auth.Service.PassWordEncrypt(userPasswordString);
model.u_name = userNameString;
model.u_state = "1";
model.u_registerdate = System.DateTime.Now;
model.u_usestate = "1";
model.u_lastlogintime = System.DateTime.Now;
model.u_remark = "";
switch (userTypeString)
{
case "1":
model.u_organid = ""; //注册用户所在机构
break;
case "2":
model.u_organid = "5"; //注册用户所在机构
break;
case "3":
model.u_organid = "";
break;
}
model.u_filedids = "";
model.u_ruleids = "";
model.u_signedurl = "";
model.u_phototurl = "";
model.f_value6 = userInfDic["devicetype"].ToString();
string userid = _idal_t_user.Add(model, t);
#endregion
//此处添加代码，给用户赋予app权限
sql = " insert into t_userfield_relation ";
sql += " (id, fg_id, u_id, remark) ";
sql += " values ";
sql += " (( select max(id) +1 from t_userfield_relation), '1010','" + userid + "', '')";
t.ExecuteSql(sql);
sql = " insert into t_usergroup_relation ";
sql += " (id, u_id, g_id, remark)";
sql += " values";
sql += " (( select max(id) +1 from t_usergroup_relation), '" + userid + "', '105', '')";//新闻 - 未登陆 - 可见
t.ExecuteSql(sql);
sql = " insert into t_usergroup_relation ";
sql += " (id, u_id, g_id, remark)";
sql += " values";
sql += " (( select max(id) +1 from t_usergroup_relation), '" + userid + "', '107', '')";//新闻 - 已登陆 - 可见
t.ExecuteSql(sql);
sql = " insert into t_usergroup_relation ";
sql += " (id, u_id, g_id, remark)";
sql += " values";
sql += " (( select max(id) +1 from t_usergroup_relation), '" + userid + "', '108', '')";//新闻 - 已登陆 - 评论
t.ExecuteSql(sql);
t.getTrans().commit();
resultDic["result"] = "true";
resultDic["message"] = userid;
}
}
catch (Exception ex)
{
if (t != null)
{
t.getTrans().rollback();
}
resultDic["result"] = "error";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
/// <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(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\":\"\"}"----》成功加入队列
*
*/
IDictionary <string, string> clientInfoDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf);
string userid = clientInfoDic["userid"];
string username = clientInfoDic["username"];
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 = "";
string sql = "";
_t = commonclass.CreateIAccessDataTrans();
_t.getTrans().begin();
#region businesscode
//businesscode
//在此处添加针对projclassid = 3的业务代码
//更改水表表，用户表，客户表的状态，抄本信息（多个客户）
//置空客户表f_value1，f_value2的状态
//更新本表的状态
model_tbl_ld_xhhbt = idal_tbl_ld_xhhbt.GetList(" fk_tbl_maintable_sys_id='" + sys_idss[i].ToString() + "'", "", "*", "", "", null)[0];
model_tbl_ld_cben = idal_tbl_ld_cben.GetList("f_cbmc ='QH023'", "", "*", "", "", null)[0];
IList <sara.dd.ldsw.model.tbl_ld_xhhbtzb> model_tbl_ld_xhhbtzb = idal_tbl_ld_xhhbtzb.GetList(" fk_tbl_ld_xhhbt_sys_id='" + model_tbl_ld_xhhbt.sys_id + "'", "", "*", "", "", null);
foreach (sara.dd.ldsw.model.tbl_ld_xhhbtzb model in model_tbl_ld_xhhbtzb)
{
model_tbl_ld_khb = idal_tbl_ld_khb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0];
string khfz = model_tbl_ld_khb.f_khfz;
string khfzid = model_tbl_ld_khb.f_khfzid;
string[] khfzarr = khfz.Split(',');
string[] khfzidarr = khfzid.Split(',');
string newkhfz = "";
string newkhfzid = "";
if (khfz == "")
{
newkhfz = "龙达水务清户表";
newkhfzid = "4059";
}
else
{
for (int a = 0; a < khfzarr.Length; a++)
{
if (khfzarr[a] == "龙达水务新立户表" || khfzarr[a] == "客服中心总表" || khfzarr[a] == "客服中心大用户表" || khfzarr[a] == "经营中心考核表" || khfzarr[a] == "经营中心排子表" || khfzarr[a] == "经营中心远传表" || khfzarr[a] == "经营中心居民表")
{
}
else
{
newkhfz += khfzarr[a] + ',';
newkhfzid += khfzidarr[a] + ',';
}
}
newkhfz = newkhfz.TrimEnd(',') + "," + "龙达水务清户表";
newkhfzid = newkhfzid.TrimEnd(',') + "," + "4059";
}
sql = " update tbl_ld_khb set f_zt = '销户' , f_ztid ='1',f_value1='',f_value2='',";
sql += "f_cbbh='" + model_tbl_ld_cben.f_cbbh + "',f_cbbhid='" + model_tbl_ld_cben.sys_id + "',";
sql += "f_cbyxm='" + model_tbl_ld_cben.f_cbymc + "',f_cbyid='" + model_tbl_ld_cben.f_cbyid + "',";
sql += "f_khfz='" + newkhfz + "',f_khfzid='" + newkhfzid + "',";
sql += "f_cbzq='" + model_tbl_ld_cben.f_cbzq + "',f_cbmc='" + model_tbl_ld_cben.f_cbmc + "' where sys_id ='" + model.f_khbhid + "'";
_t.ExecuteSql(sql);
//在客户表中加日志
List <IDictionary <string, string> > array = new List <IDictionary <string, string> >();
if (model_tbl_ld_khb.f_zt != "销户")
{
IDictionary <string, string> temp = new Dictionary <string, string>();
temp.Add("key", "f_zt");
temp.Add("oldvalue", model_tbl_ld_khb.f_zt);
temp.Add("newvalue", "销户");
temp.Add("name", "状态");
array.Add(temp);
}
if (model_tbl_ld_khb.f_khfz != newkhfz)
{
IDictionary <string, string> temp = new Dictionary <string, string>();
temp.Add("key", "f_khfz");
temp.Add("oldvalue", model_tbl_ld_khb.f_khfz);
temp.Add("newvalue", newkhfz);
temp.Add("name", "客户分组");
array.Add(temp);
}
if (model_tbl_ld_cben.f_cbbh != model_tbl_ld_khb.f_cbbh)
{
IDictionary <string, string> temp = new Dictionary <string, string>();
temp.Add("key", "f_cbbh");
temp.Add("oldvalue", model_tbl_ld_khb.f_cbbh);
temp.Add("newvalue", model_tbl_ld_cben.f_cbbh);
temp.Add("name", "抄本编号");
array.Add(temp);
}
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", model_tbl_ld_khb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户销户", array, clientInf, _t);
model_tbl_ld_sbb = idal_tbl_ld_sbb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0];
string sbfz = model_tbl_ld_sbb.f_sbfz;
string sbfzid = model_tbl_ld_khb.f_sbfzid;
string[] sbfzarr = sbfz.Split(',');
string[] sbfzidarr = sbfzid.Split(',');
string newsbfz = "";
string newsbfzid = "";
if (sbfz == "")
{
newsbfz = "龙达水务清户表";
newsbfzid = "4100";
}
else
{
for (int a = 0; a < sbfzarr.Length; a++)
{
if (sbfzarr[a] == "龙达水务新立户表" || sbfzarr[a] == "客服中心总表" || sbfzarr[a] == "客服中心大用户表" || sbfzarr[a] == "经营中心考核表" || sbfzarr[a] == "经营中心排子表" || sbfzarr[a] == "经营中心远传表" || sbfzarr[a] == "经营中心居民表")
{
}
else
{
newsbfz += sbfzarr[a] + ',';
newsbfzid += sbfzidarr[a] + ',';
}
}
newsbfz = newsbfz.TrimEnd(',') + "," + "龙达水务清户表";
newsbfzid = newsbfzid.TrimEnd(',') + "," + "4100";
}
sql = " update tbl_ld_sbb set f_zt = '销户' , f_ztid ='1',f_sbfz='" + newsbfz + "',f_sbfzid='" + newsbfzid + "' where f_khbh ='" + model.f_khbh + "'";
_t.ExecuteSql(sql);
//在水表表中加日志
List <IDictionary <string, string> > array1 = new List <IDictionary <string, string> >();
if (model_tbl_ld_sbb.f_zt != "销户")
{
IDictionary <string, string> temp = new Dictionary <string, string>();
temp.Add("key", "f_zt");
temp.Add("oldvalue", model_tbl_ld_sbb.f_zt);
temp.Add("newvalue", "销户");
temp.Add("name", "状态");
array1.Add(temp);
}
if (model_tbl_ld_sbb.f_sbfz != newsbfz)
{
IDictionary <string, string> temp = new Dictionary <string, string>();
temp.Add("key", "f_khfz");
temp.Add("oldvalue", model_tbl_ld_sbb.f_sbfz);
temp.Add("newvalue", newsbfz);
temp.Add("name", "水表分组");
array1.Add(temp);
}
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_sbb", model_tbl_ld_sbb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户销户", array1, clientInf, _t);
model_tbl_ld_yhb = idal_tbl_ld_yhb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0];
string yhfz = model_tbl_ld_yhb.f_yhfz;
string yhfzid = model_tbl_ld_khb.f_yhfzid;
string[] yhfzarr = yhfz.Split(',');
string[] yhfzidarr = yhfzid.Split(',');
string newyhfz = "";
string newyhfzid = "";
if (yhfz == "")
{
newyhfz = "龙达水务清户表";
newyhfzid = "4138";
}
else
{
for (int a = 0; a < sbfzarr.Length; a++)
{
if (yhfzarr[a] == "龙达水务新立户表" || yhfzarr[a] == "客服中心总表" || yhfzarr[a] == "客服中心大用户表" || yhfzarr[a] == "经营中心考核表" || yhfzarr[a] == "经营中心排子表" || yhfzarr[a] == "经营中心远传表" || yhfzarr[a] == "经营中心居民表")
{
}
else
{
newyhfz += yhfzarr[a] + ',';
newyhfzid += yhfzidarr[a] + ',';
}
}
newyhfz = newyhfz.TrimEnd(',') + "," + "龙达水务清户表";
newyhfzid = newyhfzid.TrimEnd(',') + "," + "4138";
}
sql = " update tbl_ld_yhb set f_zt = '销户' , f_ztid ='3',f_yhfz='" + newyhfz + "',f_yhfzid='" + newyhfzid + "' where f_khbh ='" + model.f_khbh + "'";
_t.ExecuteSql(sql);
//在用户表中加日志
List <IDictionary <string, string> > array2 = new List <IDictionary <string, string> >();
if (model_tbl_ld_yhb.f_zt != "销户")
{
IDictionary <string, string> temp = new Dictionary <string, string>();
temp.Add("key", "f_zt");
temp.Add("oldvalue", model_tbl_ld_yhb.f_zt);
temp.Add("newvalue", "销户");
temp.Add("name", "状态");
array2.Add(temp);
}
if (model_tbl_ld_yhb.f_yhfz != newsbfz)
{
IDictionary <string, string> temp = new Dictionary <string, string>();
temp.Add("key", "f_khfz");
temp.Add("oldvalue", model_tbl_ld_yhb.f_yhfz);
temp.Add("newvalue", newyhfz);
temp.Add("name", "用户分组");
array2.Add(temp);
}
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_yhb", model_tbl_ld_yhb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户销户", array2, clientInf, _t);
sql = " update tbl_ld_xhhbt set f_zt = '归档' , f_ztid ='2',f_czr='" + username + "',f_czrid='" + userid + "',f_czsj=to_date('" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss') where sys_id ='" + model_tbl_ld_xhhbt.sys_id + "'";
_t.ExecuteSql(sql);
}
#endregion
//调整数据状态
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>
/// 重写更新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());
}
public string Analysis(string json, string columns, string clientInf, string czlx)
{
//首先保存数据
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_xgsbds model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_xgsbds>(json);
//获取附件根路径
string FileUpLoadRootPath = Eva.Library.Configuration.ConfigurationManager.AppSettings["FileUpLoadRootPath"].ToString() + "fileuploadpath/";
FileUpLoadRootPath = Eva.Library.Format.FormatTextTool.GetMapPath(FileUpLoadRootPath, HttpContext.Current.Server);
//获取附件名称
//_iAccessData = sara.dd.ldsw.commonclass.commonclass.CreateIAccessData();
string sqlString = "";
string sql = "";
sqlString = "SELECT fileuploadname FROM tbl_file_content WHERE menuid='" + model.f_drwj + "'";
DataTable dt = _t.Query(sqlString).Tables[0];
//判断是否上传附件
if (dt.Rows.Count > 0 && dt.Rows[0]["fileuploadname"] != null && dt.Rows[0]["fileuploadname"].ToString().Length > 0)
{
DataTable importfile = commonclass.commonclass.ReadExcel(FileUpLoadRootPath + dt.Rows[0]["fileuploadname"].ToString()).Tables[0];
//判断是否为正确的导入模板
if (importfile.Columns[0].ColumnName == "客户编号" && importfile.Columns[1].ColumnName == "新水表底数")
{
sqlString = "DELETE FROM tbl_ld_xgsbdszb WHERE fk_tbl_ld_xgsbds_sys_id='" + model.sys_id + "'";
string aa = _t.ExecuteSql(sqlString).ToString();
//创建子表对象list
DateTimeFormatInfo dtFormat = new DateTimeFormatInfo();
dtFormat.ShortDatePattern = "yyyy/MM/dd";
IDictionary <String, String> userInfDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf);
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
DateTime blankTime = Convert.ToDateTime("1900/01/01", dtFormat);
#region 循环Excel实例化子表对象
for (int i = 0; i < importfile.Rows.Count; i++)
{
DataRow dr = importfile.Rows[i];
if (dr[0].ToString() == "" || dr[1].ToString() == "")
{
resultDic["result"] = "false";
resultDic["message"] = "客户编号或新水表底数未填写，请重新确认！";
}
else
{
sara.dd.ldsw.model.tbl_ld_khb model_tbl_ld_khb = new sara.dd.ldsw.model.tbl_ld_khb();
string khbh = dr[0].ToString().PadLeft(10, '0');
IList <sara.dd.ldsw.model.tbl_ld_khb> ml = _idal_tbl_ld_khb.GetList(" f_khbh = '" + khbh + "'and f_value1 is null and f_value2 is null and f_ztid='0' ", "", "*", "", "", _t);
if (ml.Count > 0)
{
sara.dd.ldsw.model.tbl_ld_khb khmodel = ml[0];
//创建子表实例化对象
sara.dd.ldsw.model.tbl_ld_xgsbdszb tempmodel = new sara.dd.ldsw.model.tbl_ld_xgsbdszb();
tempmodel.sys_id = 0;
tempmodel.fk_tbl_ld_xgsbds_sys_id = model.sys_id.ToString();
tempmodel.sys_creatuserid = userInfDic["userid"].ToString();
tempmodel.sys_creatusername = userInfDic["username"].ToString();
tempmodel.sys_lastedituserid = userInfDic["userid"].ToString();
tempmodel.sys_lasteditusername = userInfDic["username"].ToString();
tempmodel.sys_creatdate = currentTime;
tempmodel.sys_lasteditdate = currentTime;
tempmodel.sys_deldate = blankTime;
tempmodel.sys_delflag = "0";
#region 对象赋值
tempmodel.f_khbh = khbh;
tempmodel.f_xsbds = dr[1].ToString();
tempmodel.f_dh = khmodel.f_dh;
tempmodel.f_dz = khmodel.f_dz;
tempmodel.f_yhm = khmodel.f_yhm;
tempmodel.f_sbbh = khmodel.f_sbbh;
tempmodel.f_ysbds = khmodel.f_bqzm;
string sys_id = _idal_tbl_ld_xgsbdszb.Add(tempmodel, _t);
#endregion
sql = "update tbl_ld_khb set f_value1='" + czlx + "',f_value2 = '" + model.sys_id + "' where sys_id = '" + model_tbl_ld_khb.sys_id + "'";
_t.ExecuteSql(sql);
}
#endregion
}
}
_t.getTrans().commit();
string result1 = this.Update(json, columns, clientInf);
resultDic["result"] = "true";
resultDic["message"] = result1;
}
else
{
resultDic["result"] = "false";
resultDic["message"] = "导入模板错误，请下载正确的导入模板进行导入！";
}
}
else
{
resultDic["result"] = "false";
resultDic["message"] = "请先上传导入文件再进行分析！";
}
NewLog("数据更新成功，更新的数据为：json：" + json + "，columns：" + columns, "sql_update", 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：" + json + "，columns：" + columns + "，异常信息：" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_update", clientInf);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
/// <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_filescontent 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_filescontent set ");
strSql_use.Append("update tbl_filescontent 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_userid != null && columsList.Contains("sys_userid"))
{
strSql.Append("sys_userid='" + (model.sys_userid) + "',");
strSql_use.Append("sys_userid=:sys_userid,");
parameter = new OracleParameter(":sys_userid", OracleType.VarChar);
parameter.Value = model.sys_userid;
parameterList.Add(parameter);
}
if (model.sys_username != null && columsList.Contains("sys_username"))
{
strSql.Append("sys_username='******',");
strSql_use.Append("sys_username=:sys_username,");
parameter = new OracleParameter(":sys_username", OracleType.VarChar);
parameter.Value = model.sys_username;
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.fk_maintable_sys_id != null && columsList.Contains("fk_maintable_sys_id"))
{
strSql.Append("fk_maintable_sys_id='" + (model.fk_maintable_sys_id) + "',");
strSql_use.Append("fk_maintable_sys_id=:fk_maintable_sys_id,");
parameter = new OracleParameter(":fk_maintable_sys_id", OracleType.VarChar);
parameter.Value = model.fk_maintable_sys_id;
parameterList.Add(parameter);
}
if (model.fk_projclass_sys_id != null && columsList.Contains("fk_projclass_sys_id"))
{
strSql.Append("fk_projclass_sys_id='" + (model.fk_projclass_sys_id) + "',");
strSql_use.Append("fk_projclass_sys_id=:fk_projclass_sys_id,");
parameter = new OracleParameter(":fk_projclass_sys_id", OracleType.VarChar);
parameter.Value = model.fk_projclass_sys_id;
parameterList.Add(parameter);
}
if (model.filename != null && columsList.Contains("filename"))
{
strSql.Append("filename='" + (model.filename) + "',");
strSql_use.Append("filename=:filename,");
parameter = new OracleParameter(":filename", OracleType.VarChar);
parameter.Value = model.filename;
parameterList.Add(parameter);
}
if (model.filerealname != null && columsList.Contains("filerealname"))
{
strSql.Append("filerealname='" + (model.filerealname) + "',");
strSql_use.Append("filerealname=:filerealname,");
parameter = new OracleParameter(":filerealname", OracleType.VarChar);
parameter.Value = model.filerealname;
parameterList.Add(parameter);
}
if (model.fileclass != null && columsList.Contains("fileclass"))
{
strSql.Append("fileclass='" + (model.fileclass) + "',");
strSql_use.Append("fileclass=:fileclass,");
parameter = new OracleParameter(":fileclass", OracleType.VarChar);
parameter.Value = model.fileclass;
parameterList.Add(parameter);
}
if (model.filesize != null && columsList.Contains("filesize"))
{
strSql.Append("filesize='" + (model.filesize) + "',");
strSql_use.Append("filesize=:filesize,");
parameter = new OracleParameter(":filesize", OracleType.VarChar);
parameter.Value = model.filesize;
parameterList.Add(parameter);
}
if (model.filetitle != null && columsList.Contains("filetitle"))
{
strSql.Append("filetitle='" + (model.filetitle) + "',");
strSql_use.Append("filetitle=:filetitle,");
parameter = new OracleParameter(":filetitle", OracleType.VarChar);
parameter.Value = model.filetitle;
parameterList.Add(parameter);
}
if (model.filenote != null && columsList.Contains("filenote"))
{
strSql.Append("filenote='" + (model.filenote) + "',");
strSql_use.Append("filenote=:filenote,");
parameter = new OracleParameter(":filenote", OracleType.VarChar);
parameter.Value = model.filenote;
parameterList.Add(parameter);
}
if (model.fnumber != null && columsList.Contains("fnumber"))
{
strSql.Append("fnumber='" + (model.fnumber) + "',");
strSql_use.Append("fnumber=:fnumber,");
parameter = new OracleParameter(":fnumber", OracleType.VarChar);
parameter.Value = model.fnumber;
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>
/// 算费回滚方法
/// </summary>
/// <param name="pgid"></param>
/// <param name="clientInf"></param>
/// <param name="t"></param>
private void CountRollBackJS(string pgid, string clientInf, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
sara.dd.ldsw.idal.Itbl_ld_khb idal_tbl_ld_khb = new sara.dd.ldsw.dal.tbl_ld_khb();
//查询评估下的全部客户,并修改客户的累积欠费字段
string querycbsql = "select F_KHBHID,F_BQJE from TBL_LD_CBIAO where F_PGBHID='" + pgid + "' and F_ZTID='2'";
DataTable dt = t.Query(querycbsql).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
//获取客户信息,并修改客户的累积欠费字段
IList <sara.dd.ldsw.model.tbl_ld_khb> ml = idal_tbl_ld_khb.GetList("sys_id = ('" + dt.Rows[i]["f_khbhid"] + "') ", "", "*", "", "", t);
if (ml.Count > 0)
{
sara.dd.ldsw.model.tbl_ld_khb model_tbl_ld_khb = ml[0];
string f_ljqf_old = model_tbl_ld_khb.f_ljqf;
double ljqf = Eva.Library.Text.NumberTool.Parse(model_tbl_ld_khb.f_ljqf);
ljqf -= Eva.Library.Text.NumberTool.Parse(dt.Rows[i]["f_bqje"].ToString());
model_tbl_ld_khb.f_ljqf = Eva.Library.Text.NumberTool.GetNumberByLength(ljqf.ToString(), 2);
#region 客户表写日志
List <IDictionary <string, string> > array = new List <IDictionary <string, string> >();
IDictionary <string, string> f_ljqf = new Dictionary <string, string>();
f_ljqf.Add("key", "f_ljqf");
f_ljqf.Add("oldvalue", f_ljqf_old);
f_ljqf.Add("newvalue", model_tbl_ld_khb.f_ljqf);
f_ljqf.Add("name", "累计欠费");
array.Add(f_ljqf);
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", model_tbl_ld_khb.sys_id.ToString(), "tbl_ld_cben_cbiao_treelist", "算费", array, clientInf, t);
#endregion
idal_tbl_ld_khb.Update(model_tbl_ld_khb, "f_ljqf", t);
IList <sara.dd.ldsw.model.tbl_ld_pgb> pgb = _idal_tbl_ld_pgb.GetList("sys_id = '" + pgid + "' ", "", "*", "", "", t);
sara.dd.ldsw.model.tbl_ld_pgb model = pgb[0];
#region 算费回滚写日志
List <IDictionary <string, string> > arr = new List <IDictionary <string, string> >();
IDictionary <string, string> temp = new Dictionary <string, string>();
temp.Add("key", "rollback");
temp.Add("oldvalue", "算费编号：" + model.f_pgbh + " 算费批次名称：" + model.f_pgpcmc);
temp.Add("newvalue", "");
temp.Add("name", "算费回滚");
arr.Add(temp);
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_pgb", model.sys_id.ToString(), "tbl_ld_pgb_detail", "算费回滚", arr, clientInf, t);
#endregion
}
}
//处理减免信息
int flag = 0;
string queryjmsql = "select SYS_ID,F_CB_CBBH FROM TBL_LD_CBIAO where F_PGBHID='" + pgid + "' and F_ZTID='2' and F_JMBHID is not null";
dt = t.Query(queryjmsql).Tables[0];
string jmids = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
jmids += dt.Rows[i]["sys_id"] + ",";
}
jmids = jmids.TrimEnd(',');
if (jmids != "")
{
//更新抄表记录中的减免数据
string updatecbsql = "update TBL_LD_CBIAO set F_JMBH='',F_JMBHID='',F_JMJE='0' where SYS_ID in(" + jmids + ")";
flag = t.ExecuteSql(updatecbsql);
//更新减免表的数据
string updatejmsql = "update TBL_LD_JMB set F_CBBH='',F_CBBHID='',F_ZTID='0',F_ZT='新建' where F_CBBHID in(" + jmids + ")";
flag = t.ExecuteSql(updatejmsql);
}
//更新评估表的数据
string updatepgsql = "update TBL_LD_PGB set F_ZTID='2',F_ZT='已回滚' where SYS_ID='" + pgid + "'";
flag = t.ExecuteSql(updatepgsql);
//更新抄表表的数据
string updatesql = "update TBL_LD_CBIAO set F_ZT='已抄表',F_ZTID='1',F_SF='0',F_PWF='0',F_BQJE='0',F_SFJL='' where F_PGBHID='" + pgid + "' and F_ZTID='2'";
flag = t.ExecuteSql(updatesql);
}
/// <summary>
/// 重写添加addlayerconfig
/// </summary>
/// <param name="json"></param>
/// <param name="clientInf"></param>
/// <returns></returns>
public string Add(sara.dd.ldsw.model.tbl_filescontent 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_userid != null)
{
strSql1.Append("sys_userid,");
strSql2.Append("'" + (model.sys_userid) + "',");
strSql3.Append(":sys_userid,");
parameter = new OracleParameter(":sys_userid", OracleType.VarChar);
parameter.Value = model.sys_userid;
parameterList.Add(parameter);
}
if (model.sys_username != null)
{
strSql1.Append("sys_username,");
strSql2.Append("'" + (model.sys_username) + "',");
strSql3.Append(":sys_username,");
parameter = new OracleParameter(":sys_username", OracleType.VarChar);
parameter.Value = model.sys_username;
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.fk_maintable_sys_id != null)
{
strSql1.Append("fk_maintable_sys_id,");
strSql2.Append("'" + (model.fk_maintable_sys_id) + "',");
strSql3.Append(":fk_maintable_sys_id,");
parameter = new OracleParameter(":fk_maintable_sys_id", OracleType.VarChar);
parameter.Value = model.fk_maintable_sys_id;
parameterList.Add(parameter);
}
if (model.fk_projclass_sys_id != null)
{
strSql1.Append("fk_projclass_sys_id,");
strSql2.Append("'" + (model.fk_projclass_sys_id) + "',");
strSql3.Append(":fk_projclass_sys_id,");
parameter = new OracleParameter(":fk_projclass_sys_id", OracleType.VarChar);
parameter.Value = model.fk_projclass_sys_id;
parameterList.Add(parameter);
}
if (model.filename != null)
{
strSql1.Append("filename,");
strSql2.Append("'" + (model.filename) + "',");
strSql3.Append(":filename,");
parameter = new OracleParameter(":filename", OracleType.VarChar);
parameter.Value = model.filename;
parameterList.Add(parameter);
}
if (model.filerealname != null)
{
strSql1.Append("filerealname,");
strSql2.Append("'" + (model.filerealname) + "',");
strSql3.Append(":filerealname,");
parameter = new OracleParameter(":filerealname", OracleType.VarChar);
parameter.Value = model.filerealname;
parameterList.Add(parameter);
}
if (model.fileclass != null)
{
strSql1.Append("fileclass,");
strSql2.Append("'" + (model.fileclass) + "',");
strSql3.Append(":fileclass,");
parameter = new OracleParameter(":fileclass", OracleType.VarChar);
parameter.Value = model.fileclass;
parameterList.Add(parameter);
}
if (model.filesize != null)
{
strSql1.Append("filesize,");
strSql2.Append("'" + (model.filesize) + "',");
strSql3.Append(":filesize,");
parameter = new OracleParameter(":filesize", OracleType.VarChar);
parameter.Value = model.filesize;
parameterList.Add(parameter);
}
if (model.filetitle != null)
{
strSql1.Append("filetitle,");
strSql2.Append("'" + (model.filetitle) + "',");
strSql3.Append(":filetitle,");
parameter = new OracleParameter(":filetitle", OracleType.VarChar);
parameter.Value = model.filetitle;
parameterList.Add(parameter);
}
if (model.filenote != null)
{
strSql1.Append("filenote,");
strSql2.Append("'" + (model.filenote) + "',");
strSql3.Append(":filenote,");
parameter = new OracleParameter(":filenote", OracleType.VarChar);
parameter.Value = model.filenote;
parameterList.Add(parameter);
}
if (model.fnumber != null)
{
strSql1.Append("fnumber,");
strSql2.Append("'" + (model.fnumber) + "',");
strSql3.Append(":fnumber,");
parameter = new OracleParameter(":fnumber", OracleType.VarChar);
parameter.Value = model.fnumber;
parameterList.Add(parameter);
}
strSql.Append("insert into tbl_filescontent(");
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_filescontent(");
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());
}
#endregion
}
return(sid);
}
/// <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);
}
/// <summary>
/// 重写更新updatepaper
/// </summary>
/// <param name="json"></param>
/// <param name="columns"></param>
/// <param name="clientInf"></param>
/// <returns></returns>
public string Update(sara.dd.ldsw.model.t_projstate_log 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 t_projstate_log set ");
strSql_use.Append("update t_projstate_log 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_flag != null && columsList.Contains("sys_flag"))
{
strSql.Append("sys_flag='" + (model.sys_flag) + "',");
strSql_use.Append("sys_flag=:sys_flag,");
parameter = new OracleParameter(":sys_flag", OracleType.VarChar);
parameter.Value = model.sys_flag;
parameterList.Add(parameter);
}
if (model.businessname != null && columsList.Contains("businessname"))
{
strSql.Append("businessname='" + (model.businessname) + "',");
strSql_use.Append("businessname=:businessname,");
parameter = new OracleParameter(":businessname", OracleType.VarChar);
parameter.Value = model.businessname;
parameterList.Add(parameter);
}
if (model.businessid != null && columsList.Contains("businessid"))
{
strSql.Append("businessid='" + (model.businessid) + "',");
strSql_use.Append("businessid=:businessid,");
parameter = new OracleParameter(":businessid", OracleType.VarChar);
parameter.Value = model.businessid;
parameterList.Add(parameter);
}
if (model.fromstate != null && columsList.Contains("fromstate"))
{
strSql.Append("fromstate='" + (model.fromstate) + "',");
strSql_use.Append("fromstate=:fromstate,");
parameter = new OracleParameter(":fromstate", OracleType.VarChar);
parameter.Value = model.fromstate;
parameterList.Add(parameter);
}
if (model.tostate != null && columsList.Contains("tostate"))
{
strSql.Append("tostate='" + (model.tostate) + "',");
strSql_use.Append("tostate=:tostate,");
parameter = new OracleParameter(":tostate", OracleType.VarChar);
parameter.Value = model.tostate;
parameterList.Add(parameter);
}
if (model.processsinsid != null && columsList.Contains("processsinsid"))
{
strSql.Append("processsinsid='" + (model.processsinsid) + "',");
strSql_use.Append("processsinsid=:processsinsid,");
parameter = new OracleParameter(":processsinsid", OracleType.VarChar);
parameter.Value = model.processsinsid;
parameterList.Add(parameter);
}
if (model.processdefid != null && columsList.Contains("processdefid"))
{
strSql.Append("processdefid='" + (model.processdefid) + "',");
strSql_use.Append("processdefid=:processdefid,");
parameter = new OracleParameter(":processdefid", OracleType.VarChar);
parameter.Value = model.processdefid;
parameterList.Add(parameter);
}
if (model.workflowid != null && columsList.Contains("workflowid"))
{
strSql.Append("workflowid='" + (model.workflowid) + "',");
strSql_use.Append("workflowid=:workflowid,");
parameter = new OracleParameter(":workflowid", OracleType.VarChar);
parameter.Value = model.workflowid;
parameterList.Add(parameter);
}
if (model.remark != null && columsList.Contains("remark"))
{
strSql.Append("remark='" + (model.remark) + "',");
strSql_use.Append("remark=:remark,");
parameter = new OracleParameter(":remark", OracleType.VarChar);
parameter.Value = model.remark;
parameterList.Add(parameter);
}
if (model.value1 != null && columsList.Contains("value1"))
{
strSql.Append("value1='" + (model.value1) + "',");
strSql_use.Append("value1=:value1,");
parameter = new OracleParameter(":value1", OracleType.VarChar);
parameter.Value = model.value1;
parameterList.Add(parameter);
}
if (model.value2 != null && columsList.Contains("value2"))
{
strSql.Append("value2='" + (model.value2) + "',");
strSql_use.Append("value2=:value2,");
parameter = new OracleParameter(":value2", OracleType.VarChar);
parameter.Value = model.value2;
parameterList.Add(parameter);
}
if (model.value3 != null && columsList.Contains("value3"))
{
strSql.Append("value3='" + (model.value3) + "',");
strSql_use.Append("value3=:value3,");
parameter = new OracleParameter(":value3", OracleType.VarChar);
parameter.Value = model.value3;
parameterList.Add(parameter);
}
if (model.value4 != null && columsList.Contains("value4"))
{
strSql.Append("value4='" + (model.value4) + "',");
strSql_use.Append("value4=:value4,");
parameter = new OracleParameter(":value4", OracleType.VarChar);
parameter.Value = model.value4;
parameterList.Add(parameter);
}
if (model.value5 != null && columsList.Contains("value5"))
{
strSql.Append("value5='" + (model.value5) + "',");
strSql_use.Append("value5=:value5,");
parameter = new OracleParameter(":value5", OracleType.VarChar);
parameter.Value = model.value5;
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.t_projstate_log 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_flag != null)
{
strSql1.Append("sys_flag,");
strSql2.Append("'" + (model.sys_flag) + "',");
strSql3.Append(":sys_flag,");
parameter = new OracleParameter(":sys_flag", OracleType.VarChar);
parameter.Value = model.sys_flag;
parameterList.Add(parameter);
}
if (model.businessname != null)
{
strSql1.Append("businessname,");
strSql2.Append("'" + (model.businessname) + "',");
strSql3.Append(":businessname,");
parameter = new OracleParameter(":businessname", OracleType.VarChar);
parameter.Value = model.businessname;
parameterList.Add(parameter);
}
if (model.businessid != null)
{
strSql1.Append("businessid,");
strSql2.Append("'" + (model.businessid) + "',");
strSql3.Append(":businessid,");
parameter = new OracleParameter(":businessid", OracleType.VarChar);
parameter.Value = model.businessid;
parameterList.Add(parameter);
}
if (model.fromstate != null)
{
strSql1.Append("fromstate,");
strSql2.Append("'" + (model.fromstate) + "',");
strSql3.Append(":fromstate,");
parameter = new OracleParameter(":fromstate", OracleType.VarChar);
parameter.Value = model.fromstate;
parameterList.Add(parameter);
}
if (model.tostate != null)
{
strSql1.Append("tostate,");
strSql2.Append("'" + (model.tostate) + "',");
strSql3.Append(":tostate,");
parameter = new OracleParameter(":tostate", OracleType.VarChar);
parameter.Value = model.tostate;
parameterList.Add(parameter);
}
if (model.processsinsid != null)
{
strSql1.Append("processsinsid,");
strSql2.Append("'" + (model.processsinsid) + "',");
strSql3.Append(":processsinsid,");
parameter = new OracleParameter(":processsinsid", OracleType.VarChar);
parameter.Value = model.processsinsid;
parameterList.Add(parameter);
}
if (model.processdefid != null)
{
strSql1.Append("processdefid,");
strSql2.Append("'" + (model.processdefid) + "',");
strSql3.Append(":processdefid,");
parameter = new OracleParameter(":processdefid", OracleType.VarChar);
parameter.Value = model.processdefid;
parameterList.Add(parameter);
}
if (model.workflowid != null)
{
strSql1.Append("workflowid,");
strSql2.Append("'" + (model.workflowid) + "',");
strSql3.Append(":workflowid,");
parameter = new OracleParameter(":workflowid", OracleType.VarChar);
parameter.Value = model.workflowid;
parameterList.Add(parameter);
}
if (model.remark != null)
{
strSql1.Append("remark,");
strSql2.Append("'" + (model.remark) + "',");
strSql3.Append(":remark,");
parameter = new OracleParameter(":remark", OracleType.VarChar);
parameter.Value = model.remark;
parameterList.Add(parameter);
}
if (model.value1 != null)
{
strSql1.Append("value1,");
strSql2.Append("'" + (model.value1) + "',");
strSql3.Append(":value1,");
parameter = new OracleParameter(":value1", OracleType.VarChar);
parameter.Value = model.value1;
parameterList.Add(parameter);
}
if (model.value2 != null)
{
strSql1.Append("value2,");
strSql2.Append("'" + (model.value2) + "',");
strSql3.Append(":value2,");
parameter = new OracleParameter(":value2", OracleType.VarChar);
parameter.Value = model.value2;
parameterList.Add(parameter);
}
if (model.value3 != null)
{
strSql1.Append("value3,");
strSql2.Append("'" + (model.value3) + "',");
strSql3.Append(":value3,");
parameter = new OracleParameter(":value3", OracleType.VarChar);
parameter.Value = model.value3;
parameterList.Add(parameter);
}
if (model.value4 != null)
{
strSql1.Append("value4,");
strSql2.Append("'" + (model.value4) + "',");
strSql3.Append(":value4,");
parameter = new OracleParameter(":value4", OracleType.VarChar);
parameter.Value = model.value4;
parameterList.Add(parameter);
}
if (model.value5 != null)
{
strSql1.Append("value5,");
strSql2.Append("'" + (model.value5) + "',");
strSql3.Append(":value5,");
parameter = new OracleParameter(":value5", OracleType.VarChar);
parameter.Value = model.value5;
parameterList.Add(parameter);
}
strSql.Append("insert into t_projstate_log(");
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 t_projstate_log(");
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());
}
#endregion
}
return(sid);
}
/// <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(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\":\"\"}"----》成功加入队列
*
*/
IDictionary <string, string> clientInfoDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf);
string userid = clientInfoDic["userid"];
string username = clientInfoDic["username"];
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 = "";
string sql = "";
_t = commonclass.CreateIAccessDataTrans();
_t.getTrans().begin();
#region businesscode
//businesscode
//在此处添加针对projclassid = 3的业务代码
//更改水表表，客户表的状态 （多个客户）
//置空客户表的f_value1，f_value2状态
//更新本表的状态
model_tbl_ld_xhhbt = idal_tbl_ld_xhhbt.GetList(" fk_tbl_maintable_sys_id='" + sys_idss[i].ToString() + "'", "", "*", "", "", null)[0];
IList <sara.dd.ldsw.model.tbl_ld_xhhbtzb> model_tbl_ld_xhhbtzb = idal_tbl_ld_xhhbtzb.GetList(" fk_tbl_ld_xhhbt_sys_id='" + model_tbl_ld_xhhbt.sys_id + "'", "", "*", "", "", null);
foreach (sara.dd.ldsw.model.tbl_ld_xhhbtzb model in model_tbl_ld_xhhbtzb)
{
sql = " update tbl_ld_khb set f_zt = '停用' , f_ztid ='9',f_value1='',f_value2='' where sys_id ='" + model.f_khbhid + "'";
_t.ExecuteSql(sql);
//在客户表中加日志
model_tbl_ld_khb = idal_tbl_ld_khb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0];
List <IDictionary <string, string> > array = new List <IDictionary <string, string> >();
if (model_tbl_ld_khb.f_zt != "停用")
{
IDictionary <string, string> temp = new Dictionary <string, string>();
temp.Add("key", "f_zt");
temp.Add("oldvalue", model_tbl_ld_khb.f_zt);
temp.Add("newvalue", "停用");
temp.Add("name", "状态");
array.Add(temp);
}
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", model_tbl_ld_khb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户报停", array, clientInf, _t);
sql = " update tbl_ld_sbb set f_zt = '停用' , f_ztid ='9' where f_khbh ='" + model.f_khbh + "'";
_t.ExecuteSql(sql);
//在水表表中加日志
model_tbl_ld_sbb = idal_tbl_ld_sbb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0];
List <IDictionary <string, string> > array1 = new List <IDictionary <string, string> >();
if (model_tbl_ld_sbb.f_zt != "停用")
{
IDictionary <string, string> temp = new Dictionary <string, string>();
temp.Add("key", "f_zt");
temp.Add("oldvalue", model_tbl_ld_sbb.f_zt);
temp.Add("newvalue", "停用");
temp.Add("name", "状态");
array1.Add(temp);
}
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_sbb", model_tbl_ld_sbb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户报停", array1, clientInf, _t);
//更新用户表的状态为停用
sql = " update tbl_ld_yhb set f_zt = '停用' , f_ztid ='9' where f_khbh ='" + model.f_khbh + "'";
_t.ExecuteSql(sql);
//在用户表中加日志
model_tbl_ld_yhb = idal_tbl_ld_yhb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0];
List <IDictionary <string, string> > array2 = new List <IDictionary <string, string> >();
if (model_tbl_ld_yhb.f_zt != "停用")
{
IDictionary <string, string> temp = new Dictionary <string, string>();
temp.Add("key", "f_zt");
temp.Add("oldvalue", model_tbl_ld_yhb.f_zt);
temp.Add("newvalue", "停用");
temp.Add("name", "状态");
array2.Add(temp);
}
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_yhb", model_tbl_ld_yhb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户报停", array2, clientInf, _t);
sql = " update tbl_ld_xhhbt set f_zt = '归档' , f_ztid ='2',f_czr='" + username + "',f_czrid='" + userid + "',f_czsj=to_date('" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss') where sys_id ='" + model_tbl_ld_xhhbt.sys_id + "'";
_t.ExecuteSql(sql);
}
#endregion
//调整数据状态
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);
}
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 string UpdateFileData(string fileId, string fileContent, string businessKey, string businessTableName, string clientInf)
{
Eva.Library.Data.AccessDataTrans.IAccessDataTrans t = null;
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 fileIdKey = fileId.Split('|')[0];
string fileIdValue = fileId.Split('|')[1];
string fileContentKey = fileContent.Split('|')[0];
string fileContentValue = fileContent.Split('|')[1];
string businessKeyName = businessKey.Split('|')[0];
string businessValue = businessKey.Split('|')[1];
string str = "";
t = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans();
t.getTrans().begin();
//验证，如果fileIdValue为空，则自动创建一个fileid的value
if (fileIdValue == "")
{
str = "select tbl_file_menu_sequence.nextval from dual";
object o = t.GetSingle(str);
string fileid = (o == null || o.ToString() == "" ? "0" : o.ToString());
fileid = (int.Parse(fileid) + 1).ToString();
str = "insert into tbl_file_menu(id,hascontent) values('" + fileid + "','1')";
t.ExecuteSql(str);
fileIdValue = fileid;
}
//分析传入数据
List <String> fileNameList = new List <string>();
List <String> fileSizeList = new List <string>();
string[] fileContentArray = fileContentValue.Split(';');
for (int i = 0; i < fileContentArray.Length; i++)
{
string[] a = fileContentArray[i].Split('^');
fileNameList.Add(a[0]);
fileSizeList.Add(a[1] + "^" + a[2]);
}
string fileNameString = "," + string.Join(",", fileNameList) + ",";
str = "select * from tbl_file_content where menuid = '" + fileIdValue + "'";
DataSet ds = t.Query(str);
List <String> oldfileNameList = new List <string>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oldfileNameList.Add(ds.Tables[0].Rows[i]["fileuploadname"].ToString());
}
string oldFileNameString = "," + string.Join(",", oldfileNameList) + ",";
//==================找到需要删除的文件-====================
List <String> needDelFileNameList = new List <string>();
for (int i = 0; i < oldfileNameList.Count; i++)
{
if (fileNameString.IndexOf("," + oldfileNameList[i] + ",") > -1)
{
}
else
{
needDelFileNameList.Add(oldfileNameList[i]);
}
}
for (int i = 0; i < needDelFileNameList.Count; i++)
{
//删除记录
DataRow[] dr_del = ds.Tables[0].Select(" fileuploadname = '" + needDelFileNameList[i] + "'");
if (dr_del.Length > 0)
{
str = "delete from tbl_file_content where id = '" + dr_del[0]["id"].ToString() + "'";
t.ExecuteSql(str);
}
}
//==================找到需要新建的文件-====================
List <String> needAddFileNameList = new List <string>();
for (int i = 0; i < fileNameList.Count; i++)
{
if (oldFileNameString.IndexOf("," + fileNameList[i] + ",") > -1)
{
}
else
{
needAddFileNameList.Add(fileNameList[i]);
}
}
for (int i = 0; i < needAddFileNameList.Count; i++)
{
str = " insert into tbl_file_content ";
str += " (id, menuid, fileuploadname, filerealname, filesize, filetype, creatdate, deldate, delflag) ";
str += " values ";
str += " (tbl_file_content_sequence.nextval, '" + fileIdValue + "', '" + needAddFileNameList[i] + "', '" + needAddFileNameList[i] + "', '0', '" + needAddFileNameList[i].Substring(needAddFileNameList[i].LastIndexOf('.')) + "', to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'), to_date('1900-01-01 00:00:00','yyyy-MM-dd hh24:mi:ss'), '0')";
t.ExecuteSql(str);
}
//更新业务数据
str = " update " + businessTableName + " set ";
str += fileContentKey + " = '" + fileContentValue + "'";
str += "," + fileIdKey + " = '" + fileIdValue + "'";
str += " where " + businessKeyName + " = '" + businessValue + "'";
t.ExecuteSql(str);
t.getTrans().commit();
resultDic["result"] = "true";
resultDic["message"] = "";
}
}
catch (Exception ex)
{
if (t != null)
{
t.getTrans().rollback();
}
resultDic["result"] = "error";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}