public string Add(string json, string clientInf) { Dictionary <string, string> resultDic = new Dictionary <string, string>(); resultDic["result"] = ""; resultDic["message"] = ""; try { sara.dd.ldsw.model.tbl_ld_qfts model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_qfts>(json); if (model.f_drbh == "") { model.f_drbh = sara.dd.ldsw.commonclass.commonclass.getBusinessNum("lh", "", null); } resultDic["result"] = "true"; resultDic["message"] = _idal_tbl_ld_qfts.Add(model, null); NewLog("数据创建成功,创建的数据为:" + json, "sql_insert", clientInf); } catch (Exception ex) { resultDic["result"] = "false"; resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace); NewLog("数据创建失败,创建的数据为:" + json + ",异常信息:" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_insert", clientInf); } return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic)); }
public string Update(string json, string columns, string clientInf) { Dictionary <string, string> resultDic = new Dictionary <string, string>(); resultDic["result"] = ""; resultDic["message"] = ""; try { sara.dd.ldsw.model.tbl_ld_qfts model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_qfts>(json); columns = FormatColumns(columns).Replace("^", ","); resultDic["result"] = "true"; resultDic["message"] = _idal_tbl_ld_qfts.Update(model, columns, null); NewLog("数据更新成功,更新的数据为:json:" + json + ",columns:" + columns, "sql_update", clientInf); } catch (Exception ex) { resultDic["result"] = "false"; resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace); NewLog("数据更新失败,更新的数据为:json:" + json + ",columns:" + columns + ",异常信息:" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_update", clientInf); } return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic)); }
/// <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_qfts 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_qfts set "); strSql_use.Append("update tbl_ld_qfts 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_drbh != null && columsList.Contains("f_drbh")) { strSql.Append("f_drbh='" + (model.f_drbh) + "',"); strSql_use.Append("f_drbh=:f_drbh,"); parameter = new OracleParameter(":f_drbh", OracleType.VarChar); parameter.Value = model.f_drbh; parameterList.Add(parameter); } if (model.f_drr != null && columsList.Contains("f_drr")) { strSql.Append("f_drr='" + (model.f_drr) + "',"); strSql_use.Append("f_drr=:f_drr,"); parameter = new OracleParameter(":f_drr", OracleType.VarChar); parameter.Value = model.f_drr; parameterList.Add(parameter); } if (model.f_fxsj != null && columsList.Contains("f_fxsj")) { strSql.Append("f_fxsj=to_date('" + model.f_fxsj.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),"); strSql_use.Append("f_fxsj=:f_fxsj,"); parameter = new OracleParameter(":f_fxsj", OracleType.DateTime); parameter.Value = model.f_fxsj; parameterList.Add(parameter); } if (model.f_drsj != null && columsList.Contains("f_drsj")) { strSql.Append("f_drsj=to_date('" + model.f_drsj.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),"); strSql_use.Append("f_drsj=:f_drsj,"); parameter = new OracleParameter(":f_drsj", OracleType.DateTime); parameter.Value = model.f_drsj; parameterList.Add(parameter); } if (model.f_drwj != null && columsList.Contains("f_drwj")) { strSql.Append("f_drwj='" + (model.f_drwj) + "',"); strSql_use.Append("f_drwj=:f_drwj,"); parameter = new OracleParameter(":f_drwj", OracleType.VarChar); parameter.Value = model.f_drwj; parameterList.Add(parameter); } if (model.f_bcfj != null && columsList.Contains("f_bcfj")) { strSql.Append("f_bcfj='" + (model.f_bcfj) + "',"); strSql_use.Append("f_bcfj=:f_bcfj,"); parameter = new OracleParameter(":f_bcfj", OracleType.VarChar); parameter.Value = model.f_bcfj; parameterList.Add(parameter); } if (model.f_zt != null && columsList.Contains("f_zt")) { strSql.Append("f_zt='" + (model.f_zt) + "',"); strSql_use.Append("f_zt=:f_zt,"); parameter = new OracleParameter(":f_zt", OracleType.VarChar); parameter.Value = model.f_zt; parameterList.Add(parameter); } if (model.f_ztid != null && columsList.Contains("f_ztid")) { strSql.Append("f_ztid='" + (model.f_ztid) + "',"); strSql_use.Append("f_ztid=:f_ztid,"); parameter = new OracleParameter(":f_ztid", OracleType.VarChar); parameter.Value = model.f_ztid; parameterList.Add(parameter); } if (model.f_bz != null && columsList.Contains("f_bz")) { strSql.Append("f_bz='" + (model.f_bz) + "',"); strSql_use.Append("f_bz=:f_bz,"); parameter = new OracleParameter(":f_bz", OracleType.VarChar); parameter.Value = model.f_bz; parameterList.Add(parameter); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where sys_id='" + model.sys_id + "'"); n = strSql_use.ToString().LastIndexOf(","); strSql_use.Remove(n, 1); strSql_use.Append(" where sys_id='" + model.sys_id + "'"); #endregion int columscount = 0; if (Eva.Library.Configuration.ConfigurationManager.AppSettings["SqlEditMode"].ToString() == "parameter") { #region parameter if (parameterList.Count > 0) { if (t == null) { columscount = _iAccessData.ExecuteSql(strSql_use.ToString(), parameterList.ToArray()); } else { columscount = t.ExecuteSql(strSql_use.ToString(), parameterList.ToArray()); } } #endregion } else { #region sql if (t == null) { columscount = _iAccessData.ExecuteSql(strSql.ToString()); } else { columscount = t.ExecuteSql(strSql.ToString()); } #endregion } return(columscount.ToString()); }
/// <summary> /// 重写添加addlayerconfig /// </summary> /// <param name="json"></param> /// <param name="clientInf"></param> /// <returns></returns> public string Add(sara.dd.ldsw.model.tbl_ld_qfts 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_drbh != null) { strSql1.Append("f_drbh,"); strSql2.Append("'" + (model.f_drbh) + "',"); strSql3.Append(":f_drbh,"); parameter = new OracleParameter(":f_drbh", OracleType.VarChar); parameter.Value = model.f_drbh; parameterList.Add(parameter); } if (model.f_drr != null) { strSql1.Append("f_drr,"); strSql2.Append("'" + (model.f_drr) + "',"); strSql3.Append(":f_drr,"); parameter = new OracleParameter(":f_drr", OracleType.VarChar); parameter.Value = model.f_drr; parameterList.Add(parameter); } if (model.f_fxsj != null) { strSql1.Append("f_fxsj,"); strSql2.Append("to_date('" + model.f_fxsj.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),"); strSql3.Append(":f_fxsj,"); parameter = new OracleParameter(":f_fxsj", OracleType.DateTime); parameter.Value = model.f_fxsj; parameterList.Add(parameter); } if (model.f_drsj != null) { strSql1.Append("f_drsj,"); strSql2.Append("to_date('" + model.f_drsj.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),"); strSql3.Append(":f_drsj,"); parameter = new OracleParameter(":f_drsj", OracleType.DateTime); parameter.Value = model.f_drsj; parameterList.Add(parameter); } if (model.f_drwj != null) { strSql1.Append("f_drwj,"); strSql2.Append("'" + (model.f_drwj) + "',"); strSql3.Append(":f_drwj,"); parameter = new OracleParameter(":f_drwj", OracleType.VarChar); parameter.Value = model.f_drwj; parameterList.Add(parameter); } if (model.f_bcfj != null) { strSql1.Append("f_bcfj,"); strSql2.Append("'" + (model.f_bcfj) + "',"); strSql3.Append(":f_bcfj,"); parameter = new OracleParameter(":f_bcfj", OracleType.VarChar); parameter.Value = model.f_bcfj; 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_qfts("); 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_qfts("); 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_qfts set " + string.Join(" , ", paraStrList.ToArray()) + " where sys_id = '" + sid + "' "; if (pList.Count > 0) { if (t == null) { _iAccessData.ExecuteSql(updateSqlString, pList.ToArray()); } else { t.ExecuteSql(updateSqlString, pList.ToArray()); } } } #endregion } return(sid); }
public string Import(string json, string columns, string clientInf) { Dictionary <string, string> resultDic = new Dictionary <string, string>(); resultDic["result"] = ""; resultDic["message"] = ""; try { sara.dd.ldsw.model.tbl_ld_qfts model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_qfts>(json); //判断待导入数据是否存在异常 _iAccessData = sara.dd.ldsw.commonclass.commonclass.CreateIAccessData(); string sqlString = ""; sqlString = "SELECT count(*) AS count FROM tbl_ld_qftsyl WHERE fk_tbl_ld_qfts_sys_id ='" + model.sys_id + "' AND sys_delflag='0'"; int count = int.Parse(_iAccessData.Query(sqlString).Tables[0].Rows[0]["count"].ToString()); if (count <= 0) { resultDic["result"] = "false"; resultDic["message"] = "导入未进行,不存在待导入数据,请修正后再导入。"; } else { //userinfo信息 IDictionary <String, String> userInfDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf); //时间信息 DateTimeFormatInfo dtFormat = new DateTimeFormatInfo(); dtFormat.ShortDatePattern = "yyyy/MM/dd"; System.DateTime currentTime = new System.DateTime(); currentTime = System.DateTime.Now; DateTime blankTime = Convert.ToDateTime("1900/01/01", dtFormat); //获取待导入数据 List <sara.dd.ldsw.model.tbl_ld_qftsyl> qftsylmodellist = _idal_tbl_ld_qftsyl.GetList("fk_tbl_ld_qfts_sys_id ='" + model.sys_id + "' AND sys_delflag='0'", "", "*", "", "", null); List <sara.dd.ldsw.model.tbl_ld_khb> khbmodellist = new List <ldsw.model.tbl_ld_khb>(); List <sara.dd.ldsw.model.tbl_ld_sbb> sbbmodellist = new List <ldsw.model.tbl_ld_sbb>(); List <sara.dd.ldsw.model.tbl_ld_yhb> yhbmodellist = new List <ldsw.model.tbl_ld_yhb>(); //获取客户编号 string khbhs = ""; foreach (model.tbl_ld_qftsyl qftsylmodel in qftsylmodellist) { khbhs += "'" + qftsylmodel.f_khbh + "',"; qftsylmodel.f_khzt = "停水"; } khbhs = khbhs.TrimEnd(','); //获取客户与水表对象集合 khbmodellist = _idal_tbl_ld_khb.GetList("f_khbh in (" + khbhs + ") and (f_ztid='0' or f_ztid='4')", "", "*", "", "", null); sbbmodellist = _idal_tbl_ld_sbb.GetList("f_khbh in (" + khbhs + ") and (f_ztid='0' or f_ztid='4')", "", "*", "", "", null); yhbmodellist = _idal_tbl_ld_yhb.GetList("f_khbh in (" + khbhs + ") and (f_ztid='0' or f_ztid='4')", "", "*", "", "", null); //修改客户状态 foreach (model.tbl_ld_khb khbmodel in khbmodellist) { khbmodel.f_zt = "停水"; khbmodel.f_ztid = "2"; } foreach (model.tbl_ld_sbb sbbmodel in sbbmodellist) { sbbmodel.f_zt = "停水"; sbbmodel.f_ztid = "2"; } foreach (model.tbl_ld_yhb yhbmodel in yhbmodellist) { yhbmodel.f_zt = "停水"; yhbmodel.f_ztid = "2"; } //更新数据库 _idal_tbl_ld_khb.UpdateList(khbmodellist, "f_zt,f_ztid", null); _idal_tbl_ld_sbb.UpdateList(sbbmodellist, "f_zt,f_ztid", null); _idal_tbl_ld_yhb.UpdateList(yhbmodellist, "f_zt,f_ztid", null); //更新子表 _idal_tbl_ld_qftsyl.UpdateList(qftsylmodellist, "f_khzt", null); model.f_zt = "已导入"; model.f_ztid = "2"; columns = FormatColumns(columns).Replace("^", ","); resultDic["result"] = "true"; resultDic["message"] = _idal_tbl_ld_qfts.Update(model, columns, null); NewLog("数据更新成功,更新的数据为:json:" + json + ",columns:" + columns, "sql_update", clientInf); } } catch (Exception ex) { resultDic["result"] = "false"; resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace); NewLog("数据更新失败,更新的数据为:json:" + json + ",columns:" + columns + ",异常信息:" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_update", clientInf); } return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic)); }
public string Analysis(string json, string columns, string clientInf) { //首先保存数据 string result1 = this.Update(json, columns, clientInf); Dictionary <string, string> resultDic = new Dictionary <string, string>(); resultDic["result"] = ""; resultDic["message"] = ""; try { sara.dd.ldsw.model.tbl_ld_qfts model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_qfts>(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 = ""; sqlString = "SELECT fileuploadname FROM tbl_file_content WHERE menuid='" + model.f_drwj + "'"; DataTable dt = _iAccessData.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 == "停水客户编号") { string khbhids = ""; for (int j = 0; j < importfile.Rows.Count; j++) { if (importfile.Rows[j][0].ToString() != null && importfile.Rows[j][0].ToString() != "") { string khbhid = ""; khbhid = importfile.Rows[j][0].ToString().PadLeft(10, '0'); khbhids += khbhid + ","; } } khbhids = khbhids.TrimEnd(','); if (khbhids == "") { resultDic["result"] = "false"; resultDic["message"] = "模板内没有数据!"; } else { List <sara.dd.ldsw.model.tbl_ld_khb> khbmodellist = _idal_tbl_ld_khb.GetList("f_khbh in (" + khbhids + ")", "", "sys_id,f_khbh,f_yhm,f_khfz,f_yslx,f_zt,f_sbbh,f_dh,f_dz,f_ztid", "", "", null); List <sara.dd.ldsw.model.tbl_ld_qftsyl> qftsylmodellist = new List <sara.dd.ldsw.model.tbl_ld_qftsyl>(); IDictionary <String, String> userInfDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf); DateTimeFormatInfo dtFormat = new DateTimeFormatInfo(); dtFormat.ShortDatePattern = "yyyy/MM/dd"; System.DateTime currentTime = new System.DateTime(); currentTime = System.DateTime.Now; DateTime blankTime = Convert.ToDateTime("1900/01/01", dtFormat); foreach (sara.dd.ldsw.model.tbl_ld_khb khmodel in khbmodellist) { if (khmodel.f_ztid == "0") { //创建子表实例化对象 sara.dd.ldsw.model.tbl_ld_qftsyl tempmodel = new sara.dd.ldsw.model.tbl_ld_qftsyl(); tempmodel.fk_tbl_ld_qfts_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"; tempmodel.f_khbh = khmodel.f_khbh; tempmodel.f_yhm = khmodel.f_yhm; tempmodel.f_khfz = khmodel.f_khfz; tempmodel.f_yslx = khmodel.f_yslx; tempmodel.f_khzt = khmodel.f_zt; tempmodel.f_sbbh = khmodel.f_sbbh; tempmodel.f_dh = khmodel.f_dh; tempmodel.f_dz = khmodel.f_dz; qftsylmodellist.Add(tempmodel); } } _idal_tbl_ld_qftsyl.AddList(qftsylmodellist, null); 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) { 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)); }