LYZHGD_3.0/还原代码/DAL/T_KNOWLEDGE.cs

using DBUtility;
using JAnCallCenter.Model;
using System;
using System.Data;
using Oracle.ManagedDataAccess.Client;
using System.Text;

namespace JAnCallCenter.DAL
{
	public class T_KNOWLEDGE
	{
		public bool Exists(decimal F_ID)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("select count(1) from T_KNOWLEDGE");
			strSql.Append(" where F_ID=:F_ID ");
			OracleParameter[] parameters = new OracleParameter[]
			{
				new OracleParameter(":F_ID", OracleDbType.Int32, 4)
			};
			parameters[0].Value = F_ID;
			return DbHelperOra.Exists(strSql.ToString(), parameters);
		}

		public bool Add(Model.T_KNOWLEDGE model)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("insert into T_KNOWLEDGE(");
			strSql.Append("F_ID,F_TITLE,F_DIGEST,F_CONTENT,F_CLASS,F_USERID,F_FILEPARTH,F_ADDDATA)");
			strSql.Append(" values (");
			strSql.Append("s_t_knowledge.nextval,:F_TITLE,:F_DIGEST,:F_CONTENT,:F_CLASS,:F_USERID,:F_FILEPARTH,:F_ADDDATA)");
			OracleParameter[] parameters = new OracleParameter[]
			{
				new OracleParameter(":F_TITLE", OracleDbType.Varchar2, 200),
				new OracleParameter(":F_DIGEST", OracleDbType.Varchar2, 4000),
				new OracleParameter(":F_CONTENT", OracleDbType.Long),
				new OracleParameter(":F_CLASS", OracleDbType.Int32, 4),
				new OracleParameter(":F_USERID", OracleDbType.Int32, 4),
				new OracleParameter(":F_FILEPARTH", OracleDbType.Varchar2, 200),
				new OracleParameter(":F_ADDDATA", OracleDbType.Date)
			};
			parameters[0].Value = model.F_TITLE;
			parameters[1].Value = model.F_DIGEST;
			parameters[2].Value = model.F_CONTENT;
			parameters[3].Value = model.F_CLASS;
			parameters[4].Value = model.F_USERID;
			parameters[5].Value = model.F_FILEPARTH;
			parameters[6].Value = model.F_ADDDATA;
			int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
			return rows > 0;
		}

		public bool Update(Model.T_KNOWLEDGE model)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("update T_KNOWLEDGE set ");
			strSql.Append("F_TITLE=:F_TITLE,");
			strSql.Append("F_DIGEST=:F_DIGEST,");
			strSql.Append("F_CONTENT=:F_CONTENT,");
			strSql.Append("F_CLASS=:F_CLASS,");
			strSql.Append("F_USERID=:F_USERID,");
			strSql.Append("F_FILEPARTH=:F_FILEPARTH,");
			strSql.Append("F_ADDDATA=:F_ADDDATA");
			strSql.Append(" where F_ID=:F_ID ");
			OracleParameter[] parameters = new OracleParameter[]
			{
				new OracleParameter(":F_TITLE", OracleDbType.Varchar2, 200),
				new OracleParameter(":F_DIGEST", OracleDbType.Varchar2, 4000),
				new OracleParameter(":F_CONTENT", OracleDbType.Long),
				new OracleParameter(":F_CLASS", OracleDbType.Int32, 4),
				new OracleParameter(":F_USERID", OracleDbType.Int32, 4),
				new OracleParameter(":F_FILEPARTH", OracleDbType.Varchar2, 200),
				new OracleParameter(":F_ADDDATA", OracleDbType.Date),
				new OracleParameter(":F_ID", OracleDbType.Int32, 4)
			};
			parameters[0].Value = model.F_TITLE;
			parameters[1].Value = model.F_DIGEST;
			parameters[2].Value = model.F_CONTENT;
			parameters[3].Value = model.F_CLASS;
			parameters[4].Value = model.F_USERID;
			parameters[5].Value = model.F_FILEPARTH;
			parameters[6].Value = model.F_ADDDATA;
			parameters[7].Value = model.F_ID;
			int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
			return rows > 0;
		}

		public bool Delete(decimal F_ID)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("delete from T_KNOWLEDGE ");
			strSql.Append(" where F_ID=:F_ID ");
			OracleParameter[] parameters = new OracleParameter[]
			{
				new OracleParameter(":F_ID", OracleDbType.Int32, 4)
			};
			parameters[0].Value = F_ID;
			int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
			return rows > 0;
		}

		public bool DeleteList(string F_IDlist)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("delete from T_KNOWLEDGE ");
			strSql.Append(" where F_ID in (" + F_IDlist + ")  ");
			int rows = DbHelperOra.ExecuteSql(strSql.ToString());
			return rows > 0;
		}

		public Model.T_KNOWLEDGE GetModel(decimal F_ID)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("select F_ID,F_TITLE,F_DIGEST,F_CONTENT,F_CLASS,F_USERID,F_FILEPARTH,F_ADDDATA from T_KNOWLEDGE ");
			strSql.Append(" where F_ID=:F_ID ");
			OracleParameter[] parameters = new OracleParameter[]
			{
				new OracleParameter(":F_ID", OracleDbType.Int32, 4)
			};
			parameters[0].Value = F_ID;
            Model.T_KNOWLEDGE model = new Model.T_KNOWLEDGE();
			DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
            Model.T_KNOWLEDGE result;
			if (ds.Tables[0].Rows.Count > 0)
			{
				if (ds.Tables[0].Rows[0]["F_ID"] != null && ds.Tables[0].Rows[0]["F_ID"].ToString() != "")
				{
					model.F_ID = decimal.Parse(ds.Tables[0].Rows[0]["F_ID"].ToString());
				}
				if (ds.Tables[0].Rows[0]["F_TITLE"] != null && ds.Tables[0].Rows[0]["F_TITLE"].ToString() != "")
				{
					model.F_TITLE = ds.Tables[0].Rows[0]["F_TITLE"].ToString();
				}
				if (ds.Tables[0].Rows[0]["F_DIGEST"] != null && ds.Tables[0].Rows[0]["F_DIGEST"].ToString() != "")
				{
					model.F_DIGEST = ds.Tables[0].Rows[0]["F_DIGEST"].ToString();
				}
				if (ds.Tables[0].Rows[0]["F_CONTENT"] != null && ds.Tables[0].Rows[0]["F_CONTENT"].ToString() != "")
				{
					model.F_CONTENT = ds.Tables[0].Rows[0]["F_CONTENT"].ToString();
				}
				if (ds.Tables[0].Rows[0]["F_CLASS"] != null && ds.Tables[0].Rows[0]["F_CLASS"].ToString() != "")
				{
					model.F_CLASS = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["F_CLASS"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["F_USERID"] != null && ds.Tables[0].Rows[0]["F_USERID"].ToString() != "")
				{
					model.F_USERID = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["F_USERID"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["F_FILEPARTH"] != null && ds.Tables[0].Rows[0]["F_FILEPARTH"].ToString() != "")
				{
					model.F_FILEPARTH = ds.Tables[0].Rows[0]["F_FILEPARTH"].ToString();
				}
				if (ds.Tables[0].Rows[0]["F_ADDDATA"] != null && ds.Tables[0].Rows[0]["F_ADDDATA"].ToString() != "")
				{
					model.F_ADDDATA = new DateTime?(DateTime.Parse(ds.Tables[0].Rows[0]["F_ADDDATA"].ToString()));
				}
				result = model;
			}
			else
			{
				result = null;
			}
			return result;
		}

		public DataSet GetList(string strWhere)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("select F_ID,F_TITLE,F_DIGEST,F_CONTENT,F_CLASS,F_USERID,F_FILEPARTH,F_ADDDATA ");
			strSql.Append(" FROM T_KNOWLEDGE ");
			if (strWhere.Trim() != "")
			{
				strSql.Append(" where " + strWhere);
			}
			return DbHelperOra.Query(strSql.ToString());
		}

		public int GetRecordCount(string strWhere)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("select count(1) FROM T_KNOWLEDGE ");
			if (strWhere.Trim() != "")
			{
				strSql.Append(" where " + strWhere);
			}
			object obj = DbHelperSQL.GetSingle(strSql.ToString());
			int result;
			if (obj == null)
			{
				result = 0;
			}
			else
			{
				result = Convert.ToInt32(obj);
			}
			return result;
		}

		public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("SELECT * FROM ( ");
			strSql.Append(" SELECT ROW_NUMBER() OVER (");
			if (!string.IsNullOrEmpty(orderby.Trim()))
			{
				strSql.Append("order by T." + orderby);
			}
			else
			{
				strSql.Append("order by T.F_ID desc");
			}
			strSql.Append(")AS Row, T.*  from T_KNOWLEDGE T ");
			if (!string.IsNullOrEmpty(strWhere.Trim()))
			{
				strSql.Append(" WHERE " + strWhere);
			}
			strSql.Append(" ) TT");
			strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
			return DbHelperOra.Query(strSql.ToString());
		}
	}
}