private static sara.dd.ldsw.idal.Itbl_clob _idal_tbl_clob = dalfactory.Create <sara.dd.ldsw.idal.Itbl_clob>();// new sara.dd.ldsw.dal.tbl_clob(); #endregion #region 公有方法 /// <summary> /// 获取clobID /// </summary> /// <param name="tablename">业务表名称</param> /// <param name="columnname">业务表字段</param> /// <param name="sys_id">业务表主键</param> /// <param name="content">内容</param> /// <param name="userid">用户ID</param> /// <param name="username">用户名</param> /// <returns>clobid</returns> public static string GetNewClobId(string tablename, string columnname, string sys_id, string content, string userid, string username, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t) { string clob_sys_id = ""; _model_tbl_clob = new sara.dd.ldsw.model.tbl_clob(); _model_tbl_clob.sys_id = 0; _model_tbl_clob.sys_orderid = ""; _model_tbl_clob.sys_creatuserid = userid; _model_tbl_clob.sys_creatusername = username; _model_tbl_clob.sys_creatdate = System.DateTime.Now; _model_tbl_clob.sys_lastedituserid = userid; _model_tbl_clob.sys_lasteditusername = username; _model_tbl_clob.sys_lasteditdate = System.DateTime.Now; _model_tbl_clob.sys_deluserid = ""; _model_tbl_clob.sys_delusername = ""; _model_tbl_clob.sys_deldate = DateTime.Parse("1900-1-1"); _model_tbl_clob.sys_delflag = "0"; _model_tbl_clob.f_value1 = tablename + "^" + columnname; _model_tbl_clob.f_value2 = sys_id.ToString(); _model_tbl_clob.f_value3 = ""; _model_tbl_clob.f_value4 = ""; _model_tbl_clob.f_value5 = ""; _model_tbl_clob.f_value6 = ""; _model_tbl_clob.f_value7 = ""; _model_tbl_clob.f_value8 = ""; _model_tbl_clob.f_value9 = ""; _model_tbl_clob.f_value10 = ""; _model_tbl_clob.f_clob = content; clob_sys_id = _idal_tbl_clob.Add(_model_tbl_clob, t); return(clob_sys_id); }
/// <summary> /// 更新clob 根据clobID /// </summary> /// <param name="tablename">业务表名称</param> /// <param name="columnname">业务表字段</param> /// <param name="sys_id">业务表主键</param> /// <param name="content">内容</param> /// <param name="sys_id">Clobid</param> /// <param name="userid">用户ID</param> /// <param name="username">用户名</param> /// <returns>clobid</returns> public static string UpdataClob(string tablename, string columnname, string sys_id, string content, string clobid, string userid, string username, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t) { string reuslt = ""; _model_tbl_clob = _idal_tbl_clob.GetList(" sys_id='" + clobid + "'", "", "*", "", "", t)[0]; //_model_tbl_clob.sys_id = 0; //_model_tbl_clob.sys_orderid = ""; //_model_tbl_clob.sys_creatuserid = userid; //_model_tbl_clob.sys_creatusername = username; //_model_tbl_clob.sys_creatdate = System.DateTime.Now; _model_tbl_clob.sys_lastedituserid = userid; _model_tbl_clob.sys_lasteditusername = username; _model_tbl_clob.sys_lasteditdate = System.DateTime.Now; //_model_tbl_clob.sys_deluserid = ""; //_model_tbl_clob.sys_delusername = ""; //_model_tbl_clob.sys_deldate = DateTime.Parse("1900-1-1"); //_model_tbl_clob.sys_delflag = "0"; _model_tbl_clob.f_value1 = tablename + "^" + columnname; _model_tbl_clob.f_value2 = sys_id.ToString(); //_model_tbl_clob.f_value3 = ""; //_model_tbl_clob.f_value4 = ""; //_model_tbl_clob.f_value5 = ""; //_model_tbl_clob.f_value6 = ""; //_model_tbl_clob.f_value7 = ""; //_model_tbl_clob.f_value8 = ""; //_model_tbl_clob.f_value9 = ""; //_model_tbl_clob.f_value10 = ""; _model_tbl_clob.f_clob = content; _idal_tbl_clob.Update(_model_tbl_clob, "sys_lastedituserid,sys_lasteditusername,sys_lasteditdate,f_value1,f_value2,f_clob", t); return(reuslt); }
/// <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); }
/// <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()); }
/// <summary> /// 获取clob /// </summary> /// <param name="clobid">clobid</param> /// <param name="t"></param> /// <returns></returns> public static string GetClob(string clobid, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t) { _model_tbl_clob = _idal_tbl_clob.GetList(" sys_id='" + clobid + "'", "", "*", "", "", t)[0]; return(_model_tbl_clob.f_clob); }