LYZHGD_3.0/还原代码/DAL/T_ContactRec...

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

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

		public bool Add(Model.T_ContactRecord model)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("insert into T_CONTACTRECORD(");
			strSql.Append("ID,CALLERNUM,ZXBH,TALKDIRECTION,FILEPATH,CALLDURATION,CALLMODE,PROCESSTYPE,CONTENTTYPE,ADDDATE,IVRDATE,IVRENDDATE,RINGTIME,CONNECTTIME,HANGUPTIME,ISTRANSFER,TRANSFERTIME,HANGUPPERSION,CALLAREA,CONTENT)");
			strSql.Append(" values (");
			strSql.Append(":ID,:CALLERNUM,:ZXBH,:TALKDIRECTION,:FILEPATH,:CALLDURATION,:CALLMODE,:PROCESSTYPE,:CONTENTTYPE,:ADDDATE,:IVRDATE,:IVRENDDATE,:RINGTIME,:CONNECTTIME,:HANGUPTIME,:ISTRANSFER,:TRANSFERTIME,:HANGUPPERSION,:CALLAREA,:CONTENT)");
			OracleParameter[] parameters = new OracleParameter[]
			{
				new OracleParameter(":ID", OracleDbType.Int32, 7),
				new OracleParameter(":CALLERNUM", OracleDbType.Varchar2, 30),
				new OracleParameter(":ZXBH", OracleDbType.Int32, 4),
				new OracleParameter(":TALKDIRECTION", OracleDbType.Int32, 4),
				new OracleParameter(":FILEPATH", OracleDbType.Varchar2, 200),
				new OracleParameter(":CALLDURATION", OracleDbType.Int32, 4),
				new OracleParameter(":CALLMODE", OracleDbType.Int32, 4),
				new OracleParameter(":PROCESSTYPE", OracleDbType.Int32, 4),
				new OracleParameter(":CONTENTTYPE", OracleDbType.Int32, 4),
				new OracleParameter(":ADDDATE", OracleDbType.Date),
				new OracleParameter(":IVRDATE", OracleDbType.Date),
				new OracleParameter(":IVRENDDATE", OracleDbType.Date),
				new OracleParameter(":RINGTIME", OracleDbType.Date),
				new OracleParameter(":CONNECTTIME", OracleDbType.Date),
				new OracleParameter(":HANGUPTIME", OracleDbType.Date),
				new OracleParameter(":ISTRANSFER", OracleDbType.Int32, 4),
				new OracleParameter(":TRANSFERTIME", OracleDbType.Date),
				new OracleParameter(":HANGUPPERSION", OracleDbType.Int32, 4),
				new OracleParameter(":CALLAREA", OracleDbType.Varchar2, 20),
				new OracleParameter(":CONTENT", OracleDbType.Varchar2, 500)
			};
			parameters[0].Value = model.ID;
			parameters[1].Value = model.CALLERNUM;
			parameters[2].Value = model.ZXBH;
			parameters[3].Value = model.TALKDIRECTION;
			parameters[4].Value = model.FILEPATH;
			parameters[5].Value = model.CALLDURATION;
			parameters[6].Value = model.CALLMODE;
			parameters[7].Value = model.PROCESSTYPE;
			parameters[8].Value = model.CONTENTTYPE;
			parameters[9].Value = model.ADDDATE;
			parameters[10].Value = model.IVRDATE;
			parameters[11].Value = model.IVRENDDATE;
			parameters[12].Value = model.RINGTIME;
			parameters[13].Value = model.CONNECTTIME;
			parameters[14].Value = model.HANGUPTIME;
			parameters[15].Value = model.ISTRANSFER;
			parameters[16].Value = model.TRANSFERTIME;
			parameters[17].Value = model.HANGUPPERSION;
			parameters[18].Value = model.CALLAREA;
			parameters[19].Value = model.CONTENT;
			int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
			return rows > 0;
		}

		public bool Update(Model.T_ContactRecord model)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("update T_CONTACTRECORD set ");
			strSql.Append("CALLERNUM=:CALLERNUM,");
			strSql.Append("ZXBH=:ZXBH,");
			strSql.Append("TALKDIRECTION=:TALKDIRECTION,");
			strSql.Append("FILEPATH=:FILEPATH,");
			strSql.Append("CALLDURATION=:CALLDURATION,");
			strSql.Append("CALLMODE=:CALLMODE,");
			strSql.Append("PROCESSTYPE=:PROCESSTYPE,");
			strSql.Append("CONTENTTYPE=:CONTENTTYPE,");
			strSql.Append("ADDDATE=:ADDDATE,");
			strSql.Append("IVRDATE=:IVRDATE,");
			strSql.Append("IVRENDDATE=:IVRENDDATE,");
			strSql.Append("RINGTIME=:RINGTIME,");
			strSql.Append("CONNECTTIME=:CONNECTTIME,");
			strSql.Append("HANGUPTIME=:HANGUPTIME,");
			strSql.Append("ISTRANSFER=:ISTRANSFER,");
			strSql.Append("TRANSFERTIME=:TRANSFERTIME,");
			strSql.Append("HANGUPPERSION=:HANGUPPERSION,");
			strSql.Append("CALLAREA=:CALLAREA,");
			strSql.Append("CONTENT=:CONTENT");
			strSql.Append(" where ID=:ID ");
			OracleParameter[] parameters = new OracleParameter[]
			{
				new OracleParameter(":CALLERNUM", OracleDbType.Varchar2, 30),
				new OracleParameter(":ZXBH", OracleDbType.Int32, 4),
				new OracleParameter(":TALKDIRECTION", OracleDbType.Int32, 4),
				new OracleParameter(":FILEPATH", OracleDbType.Varchar2, 200),
				new OracleParameter(":CALLDURATION", OracleDbType.Int32, 4),
				new OracleParameter(":CALLMODE", OracleDbType.Int32, 4),
				new OracleParameter(":PROCESSTYPE", OracleDbType.Int32, 4),
				new OracleParameter(":CONTENTTYPE", OracleDbType.Int32, 4),
				new OracleParameter(":ADDDATE", OracleDbType.Date),
				new OracleParameter(":IVRDATE", OracleDbType.Date),
				new OracleParameter(":IVRENDDATE", OracleDbType.Date),
				new OracleParameter(":RINGTIME", OracleDbType.Date),
				new OracleParameter(":CONNECTTIME", OracleDbType.Date),
				new OracleParameter(":HANGUPTIME", OracleDbType.Date),
				new OracleParameter(":ISTRANSFER", OracleDbType.Int32, 4),
				new OracleParameter(":TRANSFERTIME", OracleDbType.Date),
				new OracleParameter(":HANGUPPERSION", OracleDbType.Int32, 4),
				new OracleParameter(":CALLAREA", OracleDbType.Varchar2, 20),
				new OracleParameter(":CONTENT", OracleDbType.Varchar2, 500),
				new OracleParameter(":ID", OracleDbType.Int32, 7)
			};
			parameters[0].Value = model.CALLERNUM;
			parameters[1].Value = model.ZXBH;
			parameters[2].Value = model.TALKDIRECTION;
			parameters[3].Value = model.FILEPATH;
			parameters[4].Value = model.CALLDURATION;
			parameters[5].Value = model.CALLMODE;
			parameters[6].Value = model.PROCESSTYPE;
			parameters[7].Value = model.CONTENTTYPE;
			parameters[8].Value = model.ADDDATE;
			parameters[9].Value = model.IVRDATE;
			parameters[10].Value = model.IVRENDDATE;
			parameters[11].Value = model.RINGTIME;
			parameters[12].Value = model.CONNECTTIME;
			parameters[13].Value = model.HANGUPTIME;
			parameters[14].Value = model.ISTRANSFER;
			parameters[15].Value = model.TRANSFERTIME;
			parameters[16].Value = model.HANGUPPERSION;
			parameters[17].Value = model.CALLAREA;
			parameters[18].Value = model.CONTENT;
			parameters[19].Value = model.ID;
			int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
			return rows > 0;
		}

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

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

		public Model.T_ContactRecord GetModel(decimal ID)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("select ID,CALLERNUM,ZXBH,TALKDIRECTION,FILEPATH,CALLDURATION,CALLMODE,PROCESSTYPE,CONTENTTYPE,ADDDATE,IVRDATE,IVRENDDATE,RINGTIME,CONNECTTIME,HANGUPTIME,ISTRANSFER,TRANSFERTIME,HANGUPPERSION,CALLAREA,CONTENT from T_CONTACTRECORD ");
			strSql.Append(" where ID=:ID ");
			OracleParameter[] parameters = new OracleParameter[]
			{
				new OracleParameter(":ID", OracleDbType.Int32, 7)
			};
			parameters[0].Value = ID;
			Model.T_ContactRecord model = new Model.T_ContactRecord();
			DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
			Model.T_ContactRecord result;
			if (ds.Tables[0].Rows.Count > 0)
			{
				if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
				{
					model.ID = decimal.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
				}
				if (ds.Tables[0].Rows[0]["CALLERNUM"] != null && ds.Tables[0].Rows[0]["CALLERNUM"].ToString() != "")
				{
					model.CALLERNUM = ds.Tables[0].Rows[0]["CALLERNUM"].ToString();
				}
				if (ds.Tables[0].Rows[0]["ZXBH"] != null && ds.Tables[0].Rows[0]["ZXBH"].ToString() != "")
				{
					model.ZXBH = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["ZXBH"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["TALKDIRECTION"] != null && ds.Tables[0].Rows[0]["TALKDIRECTION"].ToString() != "")
				{
					model.TALKDIRECTION = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["TALKDIRECTION"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["FILEPATH"] != null && ds.Tables[0].Rows[0]["FILEPATH"].ToString() != "")
				{
					model.FILEPATH = ds.Tables[0].Rows[0]["FILEPATH"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CALLDURATION"] != null && ds.Tables[0].Rows[0]["CALLDURATION"].ToString() != "")
				{
					model.CALLDURATION = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["CALLDURATION"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["CALLMODE"] != null && ds.Tables[0].Rows[0]["CALLMODE"].ToString() != "")
				{
					model.CALLMODE = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["CALLMODE"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["PROCESSTYPE"] != null && ds.Tables[0].Rows[0]["PROCESSTYPE"].ToString() != "")
				{
					model.PROCESSTYPE = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["PROCESSTYPE"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["CONTENTTYPE"] != null && ds.Tables[0].Rows[0]["CONTENTTYPE"].ToString() != "")
				{
					model.CONTENTTYPE = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["CONTENTTYPE"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["ADDDATE"] != null && ds.Tables[0].Rows[0]["ADDDATE"].ToString() != "")
				{
					model.ADDDATE = new DateTime?(DateTime.Parse(ds.Tables[0].Rows[0]["ADDDATE"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["IVRDATE"] != null && ds.Tables[0].Rows[0]["IVRDATE"].ToString() != "")
				{
					model.IVRDATE = new DateTime?(DateTime.Parse(ds.Tables[0].Rows[0]["IVRDATE"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["IVRENDDATE"] != null && ds.Tables[0].Rows[0]["IVRENDDATE"].ToString() != "")
				{
					model.IVRENDDATE = new DateTime?(DateTime.Parse(ds.Tables[0].Rows[0]["IVRENDDATE"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["RINGTIME"] != null && ds.Tables[0].Rows[0]["RINGTIME"].ToString() != "")
				{
					model.RINGTIME = new DateTime?(DateTime.Parse(ds.Tables[0].Rows[0]["RINGTIME"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["CONNECTTIME"] != null && ds.Tables[0].Rows[0]["CONNECTTIME"].ToString() != "")
				{
					model.CONNECTTIME = new DateTime?(DateTime.Parse(ds.Tables[0].Rows[0]["CONNECTTIME"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["HANGUPTIME"] != null && ds.Tables[0].Rows[0]["HANGUPTIME"].ToString() != "")
				{
					model.HANGUPTIME = new DateTime?(DateTime.Parse(ds.Tables[0].Rows[0]["HANGUPTIME"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["ISTRANSFER"] != null && ds.Tables[0].Rows[0]["ISTRANSFER"].ToString() != "")
				{
					model.ISTRANSFER = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["ISTRANSFER"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["TRANSFERTIME"] != null && ds.Tables[0].Rows[0]["TRANSFERTIME"].ToString() != "")
				{
					model.TRANSFERTIME = new DateTime?(DateTime.Parse(ds.Tables[0].Rows[0]["TRANSFERTIME"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["HANGUPPERSION"] != null && ds.Tables[0].Rows[0]["HANGUPPERSION"].ToString() != "")
				{
					model.HANGUPPERSION = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["HANGUPPERSION"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["CALLAREA"] != null && ds.Tables[0].Rows[0]["CALLAREA"].ToString() != "")
				{
					model.CALLAREA = ds.Tables[0].Rows[0]["CALLAREA"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CONTENT"] != null && ds.Tables[0].Rows[0]["CONTENT"].ToString() != "")
				{
					model.CONTENT = ds.Tables[0].Rows[0]["CONTENT"].ToString();
				}
				result = model;
			}
			else
			{
				result = null;
			}
			return result;
		}

		public DataSet GetList(string strWhere)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("select ID,CALLERNUM,ZXBH,TALKDIRECTION,FILEPATH,CALLDURATION,CALLMODE,PROCESSTYPE,CONTENTTYPE,ADDDATE,IVRDATE,IVRENDDATE,RINGTIME,CONNECTTIME,HANGUPTIME,ISTRANSFER,TRANSFERTIME,HANGUPPERSION,CALLAREA,CONTENT ");
			strSql.Append(" FROM T_CONTACTRECORD ");
			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_CONTACTRECORD ");
			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.ID desc");
			}
			strSql.Append(")AS Row, T.*  from T_CONTACTRECORD 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());
		}
	}
}