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);
}
