/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(XHD.Model.HJ_Phone_RecordsInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into hj_phone_records(");
strSql.Append("Factory_Id,tq_PhoneState,PhoneNum,Phone_Cust,Phone_Emp,Phone_Seat,CallTime,Time_Begin,Time_End,Id_Emp,EmpName,EmpDID,EmpDName,EmpIdCard,Customerid,Customer,CusAttribution,ContactName,File_Path,CallType,Answered,Appraise_Level,Remark,DialingRoute,InboundQueue,BusinessClass,ProceState,MemAccount,MediaSources,IsThirdParty,Evaluation,Clue,Relay)");
strSql.Append(" values (");
strSql.Append("@Factory_Id,@tq_PhoneState,@PhoneNum,@Phone_Cust,@Phone_Emp,@Phone_Seat,@CallTime,@Time_Begin,@Time_End,@Id_Emp,@EmpName,@EmpDID,@EmpDName,@EmpIdCard,@Customerid,@Customer,@CusAttribution,@ContactName,@File_Path,@CallType,@Answered,@Appraise_Level,@Remark,@DialingRoute,@InboundQueue,@BusinessClass,@ProceState,@MemAccount,@MediaSources,@IsThirdParty,@Evaluation,@Clue,@Relay)");
MySqlParameter[] parameters =
{
new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60),
new MySqlParameter("@tq_PhoneState", MySqlDbType.VarChar, 1),
new MySqlParameter("@PhoneNum", MySqlDbType.VarChar, 20),
new MySqlParameter("@Phone_Cust", MySqlDbType.VarChar, 20),
new MySqlParameter("@Phone_Emp", MySqlDbType.VarChar, 20),
new MySqlParameter("@Phone_Seat", MySqlDbType.VarChar, 20),
new MySqlParameter("@CallTime", MySqlDbType.DateTime),
new MySqlParameter("@Time_Begin", MySqlDbType.DateTime),
new MySqlParameter("@Time_End", MySqlDbType.DateTime),
new MySqlParameter("@Id_Emp", MySqlDbType.Int32, 11),
new MySqlParameter("@EmpName", MySqlDbType.VarChar, 50),
new MySqlParameter("@EmpDID", MySqlDbType.Int32, 11),
new MySqlParameter("@EmpDName", MySqlDbType.VarChar, 50),
new MySqlParameter("@EmpIdCard", MySqlDbType.VarChar, 50),
new MySqlParameter("@Customerid", MySqlDbType.Int32, 11),
new MySqlParameter("@Customer", MySqlDbType.VarChar, 250),
new MySqlParameter("@CusAttribution", MySqlDbType.VarChar, 100),
new MySqlParameter("@ContactName", MySqlDbType.VarChar, 50),
new MySqlParameter("@File_Path", MySqlDbType.VarChar, 500),
new MySqlParameter("@CallType", MySqlDbType.VarChar, 1),
new MySqlParameter("@Answered", MySqlDbType.VarChar, 1),
new MySqlParameter("@Appraise_Level", MySqlDbType.VarChar, 1),
new MySqlParameter("@Remark", MySqlDbType.VarChar, 200),
new MySqlParameter("@DialingRoute", MySqlDbType.VarChar, 100),
new MySqlParameter("@InboundQueue", MySqlDbType.VarChar, 100),
new MySqlParameter("@BusinessClass", MySqlDbType.VarChar, 100),
new MySqlParameter("@ProceState", MySqlDbType.VarChar, 1),
new MySqlParameter("@MemAccount", MySqlDbType.VarChar, 50),
new MySqlParameter("@MediaSources", MySqlDbType.VarChar, 100),
new MySqlParameter("@IsThirdParty", MySqlDbType.VarChar, 1),
new MySqlParameter("@Evaluation", MySqlDbType.LongText),
new MySqlParameter("@Clue", MySqlDbType.LongText),
new MySqlParameter("@Relay", MySqlDbType.VarChar, 50)
};
parameters[0].Value = model.Factory_Id;
parameters[1].Value = model.tq_PhoneState;
parameters[2].Value = model.PhoneNum;
parameters[3].Value = model.Phone_Cust;
parameters[4].Value = model.Phone_Emp;
parameters[5].Value = model.Phone_Seat;
parameters[6].Value = model.CallTime;
parameters[7].Value = model.Time_Begin;
parameters[8].Value = model.Time_End;
parameters[9].Value = model.Id_Emp;
parameters[10].Value = model.EmpName;
parameters[11].Value = model.EmpDID;
parameters[12].Value = model.EmpDName;
parameters[13].Value = model.EmpIdCard;
parameters[14].Value = model.Customerid;
parameters[15].Value = model.Customer;
parameters[16].Value = model.CusAttribution;
parameters[17].Value = model.ContactName;
parameters[18].Value = model.File_Path;
parameters[19].Value = model.CallType;
parameters[20].Value = model.Answered;
parameters[21].Value = model.Appraise_Level;
parameters[22].Value = model.Remark;
parameters[23].Value = model.DialingRoute;
parameters[24].Value = model.InboundQueue;
parameters[25].Value = model.BusinessClass;
parameters[26].Value = model.ProceState;
parameters[27].Value = model.MemAccount;
parameters[28].Value = model.MediaSources;
parameters[29].Value = model.IsThirdParty;
parameters[30].Value = model.Evaluation;
parameters[31].Value = model.Clue;
parameters[32].Value = model.Relay;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.HJ_Phone_RecordsInfo DataRowToModel(DataRow row)
{
XHD.Model.HJ_Phone_RecordsInfo model = new XHD.Model.HJ_Phone_RecordsInfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["Factory_Id"] != null)
{
model.Factory_Id = row["Factory_Id"].ToString();
}
if (row["tq_PhoneState"] != null)
{
model.tq_PhoneState = row["tq_PhoneState"].ToString();
}
if (row["PhoneNum"] != null)
{
model.PhoneNum = row["PhoneNum"].ToString();
}
if (row["Phone_Cust"] != null)
{
model.Phone_Cust = row["Phone_Cust"].ToString();
}
if (row["Phone_Emp"] != null)
{
model.Phone_Emp = row["Phone_Emp"].ToString();
}
if (row["Phone_Seat"] != null)
{
model.Phone_Seat = row["Phone_Seat"].ToString();
}
if (row["CallTime"] != null && row["CallTime"].ToString() != "")
{
model.CallTime = DateTime.Parse(row["CallTime"].ToString());
}
if (row["Time_Begin"] != null && row["Time_Begin"].ToString() != "")
{
model.Time_Begin = DateTime.Parse(row["Time_Begin"].ToString());
}
if (row["Time_End"] != null && row["Time_End"].ToString() != "")
{
model.Time_End = DateTime.Parse(row["Time_End"].ToString());
}
if (row["Id_Emp"] != null && row["Id_Emp"].ToString() != "")
{
model.Id_Emp = int.Parse(row["Id_Emp"].ToString());
}
if (row["EmpName"] != null)
{
model.EmpName = row["EmpName"].ToString();
}
if (row["EmpDID"] != null && row["EmpDID"].ToString() != "")
{
model.EmpDID = int.Parse(row["EmpDID"].ToString());
}
if (row["EmpDName"] != null)
{
model.EmpDName = row["EmpDName"].ToString();
}
if (row["EmpIdCard"] != null)
{
model.EmpIdCard = row["EmpIdCard"].ToString();
}
if (row["Customerid"] != null && row["Customerid"].ToString() != "")
{
model.Customerid = int.Parse(row["Customerid"].ToString());
}
if (row["Customer"] != null)
{
model.Customer = row["Customer"].ToString();
}
if (row["CusAttribution"] != null)
{
model.CusAttribution = row["CusAttribution"].ToString();
}
if (row["ContactName"] != null)
{
model.ContactName = row["ContactName"].ToString();
}
if (row["File_Path"] != null)
{
model.File_Path = row["File_Path"].ToString();
}
if (row["CallType"] != null)
{
model.CallType = row["CallType"].ToString();
}
if (row["Answered"] != null)
{
model.Answered = row["Answered"].ToString();
}
if (row["Appraise_Level"] != null)
{
model.Appraise_Level = row["Appraise_Level"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["DialingRoute"] != null)
{
model.DialingRoute = row["DialingRoute"].ToString();
}
if (row["InboundQueue"] != null)
{
model.InboundQueue = row["InboundQueue"].ToString();
}
if (row["BusinessClass"] != null)
{
model.BusinessClass = row["BusinessClass"].ToString();
}
if (row["ProceState"] != null)
{
model.ProceState = row["ProceState"].ToString();
}
if (row["MemAccount"] != null)
{
model.MemAccount = row["MemAccount"].ToString();
}
if (row["MediaSources"] != null)
{
model.MediaSources = row["MediaSources"].ToString();
}
if (row["IsThirdParty"] != null)
{
model.IsThirdParty = row["IsThirdParty"].ToString();
}
if (row["Evaluation"] != null)
{
model.Evaluation = row["Evaluation"].ToString();
}
if (row["Clue"] != null)
{
model.Clue = row["Clue"].ToString();
}
if (row["Relay"] != null)
{
model.Relay = row["Relay"].ToString();
}
}
return(model);
}
public bool Update(XHD.Model.HJ_Phone_RecordsInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update hj_phone_records set ");
strSql.Append("tq_PhoneState=@tq_PhoneState,");
strSql.Append("CallTime=@CallTime,");
strSql.Append("Time_Begin=@Time_Begin,");
strSql.Append("Time_End=@Time_End,");
strSql.Append("File_Path=@File_Path,");
strSql.Append("Answered=@Answered,");
strSql.Append("Appraise_Level=@Appraise_Level,");
strSql.Append("Remark=@Remark,");
strSql.Append("DialingRoute=@DialingRoute,");
strSql.Append("InboundQueue=@InboundQueue,");
strSql.Append("BusinessClass=@BusinessClass,");
strSql.Append("ProceState=@ProceState,");
strSql.Append("MemAccount=@MemAccount,");
strSql.Append("MediaSources=@MediaSources,");
strSql.Append("IsThirdParty=@IsThirdParty,");
strSql.Append("Evaluation=@Evaluation,");
strSql.Append("Clue=@Clue,");
strSql.Append("Relay=@Relay,");
strSql.Append("Phone_Seat=@Phone_Seat,");
strSql.Append("Phone_Cust=@Phone_Cust");
strSql.Append(" where PhoneNum=@PhoneNum");
strSql.Append(" and Factory_Id=@Factory_Id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@tq_PhoneState", MySqlDbType.VarChar, 1),
new MySqlParameter("@CallTime", MySqlDbType.DateTime),
new MySqlParameter("@Time_Begin", MySqlDbType.DateTime),
new MySqlParameter("@Time_End", MySqlDbType.DateTime),
new MySqlParameter("@File_Path", MySqlDbType.VarChar, 500),
new MySqlParameter("@Answered", MySqlDbType.VarChar, 1),
new MySqlParameter("@Appraise_Level", MySqlDbType.VarChar, 1),
new MySqlParameter("@Remark", MySqlDbType.VarChar, 200),
new MySqlParameter("@DialingRoute", MySqlDbType.VarChar, 100),
new MySqlParameter("@InboundQueue", MySqlDbType.VarChar, 100),
new MySqlParameter("@BusinessClass", MySqlDbType.VarChar, 100),
new MySqlParameter("@ProceState", MySqlDbType.VarChar, 1),
new MySqlParameter("@MemAccount", MySqlDbType.VarChar, 50),
new MySqlParameter("@MediaSources", MySqlDbType.VarChar, 100),
new MySqlParameter("@IsThirdParty", MySqlDbType.VarChar, 1),
new MySqlParameter("@Evaluation", MySqlDbType.LongText),
new MySqlParameter("@Clue", MySqlDbType.LongText),
new MySqlParameter("@Relay", MySqlDbType.VarChar, 50),
new MySqlParameter("@Phone_Seat", MySqlDbType.VarChar, 50),
new MySqlParameter("@Phone_Cust", MySqlDbType.VarChar, 50),
new MySqlParameter("@PhoneNum", MySqlDbType.VarChar, 20),
new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60)
};
parameters[0].Value = model.tq_PhoneState;
parameters[1].Value = model.CallTime;
parameters[2].Value = model.Time_Begin;
parameters[3].Value = model.Time_End;
parameters[4].Value = model.File_Path;
parameters[5].Value = model.Answered;
parameters[6].Value = model.Appraise_Level;
parameters[7].Value = model.Remark;
parameters[8].Value = model.DialingRoute;
parameters[9].Value = model.InboundQueue;
parameters[10].Value = model.BusinessClass;
parameters[11].Value = model.ProceState;
parameters[12].Value = model.MemAccount;
parameters[13].Value = model.MediaSources;
parameters[14].Value = model.IsThirdParty;
parameters[15].Value = model.Evaluation;
parameters[16].Value = model.Clue;
parameters[17].Value = model.Relay;
parameters[18].Value = model.Phone_Seat;
parameters[19].Value = model.Phone_Cust;
parameters[20].Value = model.PhoneNum;
parameters[21].Value = model.Factory_Id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
