/// <summary>
/// 获取客户信息实体
/// </summary>
/// <param name="customerId">客户编号</param>
/// <returns></returns>
public virtual EyouSoft.Model.SMSStructure.CustomerList GetCustomer(string customerId)
{
EyouSoft.Model.SMSStructure.CustomerList customerInfo = null;
DbCommand cmd = this._db.GetSqlStringCommand(SQL_SELECT_GETCUSTOMERINFO);
this._db.AddInParameter(cmd, "CUSTOMERID", DbType.AnsiStringFixedLength, customerId);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
{
if (rdr.Read())
{
customerInfo = new EyouSoft.Model.SMSStructure.CustomerList(rdr.GetString(rdr.GetOrdinal("ID"))
, rdr.GetInt32(rdr.GetOrdinal("CompanyID"))
, rdr.GetInt32(rdr.GetOrdinal("UserID"))
, rdr["CustomerCompanyName"].ToString()
, rdr["CustomerContactName"].ToString()
, rdr.GetInt32(rdr.GetOrdinal("ClassID"))
, rdr["ReMark"].ToString()
, rdr["MobileNumber"].ToString()
, rdr.GetDateTime(rdr.GetOrdinal("IssueTime"))
, rdr.GetInt32(rdr.GetOrdinal("ProvinceId"))
, rdr.GetInt32(rdr.GetOrdinal("CityId"))
);
}
}
return(customerInfo);
}
/// <summary>
/// 修改客户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateCustomerList(EyouSoft.Model.SMSStructure.CustomerList model)
{
bool result = false;
result = Dal.UpdateCustomerList(model);
handleLogsBll.Add(AddLogs("修改了客户信息", result));
return(result);
}
/// <summary>
/// 添加客户信息
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
public bool AddCustomerList(EyouSoft.Model.SMSStructure.CustomerList model)
{
if (model == null)
{
return(false);
}
bool result = false;
result = Dal.AddCustomerList(model);
handleLogsBll.Add(AddLogs("新增了客户信息", result));
return(result);
}
/// <summary>
/// 更新客户信息
/// </summary>
/// <param name="customerInfo">客户信息业务实体</param>
/// <returns>返回处理结果</returns>
public virtual bool UpdateCustomerList(EyouSoft.Model.SMSStructure.CustomerList customerInfo)
{
DbCommand cmd = this._db.GetSqlStringCommand(SQL_UPDATE_UpdateCustomer);
this._db.AddInParameter(cmd, "CUSTOMERCOMPANYNAME", DbType.String, customerInfo.CustomerCompanyName);
this._db.AddInParameter(cmd, "CUSTOMERCONTACTNAME", DbType.String, customerInfo.CustomerContactName);
this._db.AddInParameter(cmd, "CLASSID", DbType.Int32, customerInfo.ClassID);
this._db.AddInParameter(cmd, "REMARK", DbType.String, customerInfo.ReMark);
this._db.AddInParameter(cmd, "MOBILE", DbType.String, customerInfo.MobileNumber);
this._db.AddInParameter(cmd, "CUSTOMERID", DbType.String, customerInfo.ID);
this._db.AddInParameter(cmd, "COMPANYID", DbType.String, customerInfo.CompanyID);
this._db.AddInParameter(cmd, "ProvinceId", DbType.Int32, customerInfo.ProvinceId);
this._db.AddInParameter(cmd, "CityId", DbType.Int32, customerInfo.CityId);
return(EyouSoft.Toolkit.DAL.DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
/// <summary>
/// 添加客户信息
/// </summary>
/// <param name="customerInfo">客户信息业务实体</param>
/// <returns>返回处理结果</returns>
public virtual bool AddCustomerList(EyouSoft.Model.SMSStructure.CustomerList customerInfo)
{
DbCommand cmd = this._db.GetSqlStringCommand(SQL_INSERT_InsertCustomer);
this._db.AddInParameter(cmd, "ID", DbType.AnsiStringFixedLength, Guid.NewGuid().ToString());
this._db.AddInParameter(cmd, "COMPANYID", DbType.String, customerInfo.CompanyID);
this._db.AddInParameter(cmd, "USERID", DbType.String, customerInfo.UserID);
this._db.AddInParameter(cmd, "CUSTOMERCOMPANYNAME", DbType.String, customerInfo.CustomerCompanyName);
this._db.AddInParameter(cmd, "CUSTOMERCONTACTNAME", DbType.String, customerInfo.CustomerContactName);
this._db.AddInParameter(cmd, "CLASSID", DbType.String, customerInfo.ClassID);
this._db.AddInParameter(cmd, "REMARK", DbType.String, customerInfo.ReMark);
this._db.AddInParameter(cmd, "MOBILE", DbType.String, customerInfo.MobileNumber);
this._db.AddInParameter(cmd, "ProvinceId", DbType.Int32, customerInfo.ProvinceId);
this._db.AddInParameter(cmd, "CityId", DbType.Int32, customerInfo.CityId);
return(EyouSoft.Toolkit.DAL.DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
protected void Page_Load(object sender, EventArgs e)
{
//判断权限
if (!CheckGrant(global::Common.Enum.TravelPermission.短信中心_短信中心_栏目))
{
Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.短信中心_短信中心_栏目, true);
return;
}
string custId = Utils.GetQueryStringValue("custid"); //客户Id
string method = Utils.GetFormValue("hidMethod"); //当前操作
EyouSoft.BLL.SMSStructure.CustomerList custBll = new EyouSoft.BLL.SMSStructure.CustomerList();
if (method != "")
{
#region 保存客户
bool result = false;
string showMess = "数据保存成功！";
if (method == "save" || method == "continue")
{
#region 保存客户
EyouSoft.Model.SMSStructure.CustomerList custModel = new EyouSoft.Model.SMSStructure.CustomerList();
custModel.CustomerCompanyName = Utils.InputText(txtCompanyName.Value); //单位名
custModel.MobileNumber = Utils.InputText(txtMobile.Value); //手机
custModel.ReMark = Utils.InputText(txtRemark.Value, 200); //备注
custModel.CustomerContactName = Utils.InputText(txtUserName.Value); //姓名
custModel.ClassID = Utils.GetInt(Utils.GetFormValue(selClass.UniqueID));
custModel.CompanyID = CurrentUserCompanyID;
custModel.IssueTime = DateTime.Now;
custModel.UserID = SiteUserInfo.ID;
custModel.ID = custId;
if (custBll.IsExistCustomerMobile(CurrentUserCompanyID, custId, custModel.MobileNumber))
{
MessageBox.Show(this, "该号码已经存在！");
IList <EyouSoft.Model.SMSStructure.CustomerClass> classList = custBll.GetCustomerClass(CurrentUserCompanyID);
if (classList != null && classList.Count > 0)
{
selClass.DataTextField = "ClassName";
selClass.DataValueField = "ID";
selClass.DataSource = classList;
selClass.DataBind();
}
selClass.Items.Insert(0, new ListItem("请选择", ""));
return;
}
if (custId != "")
{
result = custBll.UpdateCustomerList(custModel);
}
else
{
result = custBll.AddCustomerList(custModel);
}
if (!result)
{
showMess = "数据保存失败！";
}
if (method == "save")
{
MessageBox.ResponseScript(this, string.Format(";alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();window.parent.location='/SMS/SmsCustomerList.aspx';", showMess, Utils.GetQueryStringValue("iframeId")));
}
else
{
MessageBox.ShowAndRedirect(this, showMess, "EditSmsCustomer.aspx");
}
return;
#endregion
}
if (method == "addClass")
{
#region 添加客户类别
string className = Utils.GetFormValue("className");
EyouSoft.Model.SMSStructure.CustomerClass custClass =
new EyouSoft.Model.SMSStructure.CustomerClass
{
ClassName = className,
CompanyID = CurrentUserCompanyID,
IssueTime = DateTime.Now,
UserID = SiteUserInfo.ID
};
int classId = custBll.AddCustomClass(custClass);
//添加类别
Utils.ResponseMeg(classId != 0, classId.ToString());
return;
#endregion
}
if (method == "delClass")
{
#region 除客户类别
int classId = Utils.GetInt(Utils.GetFormValue("classId"));
//删除类别
result = custBll.DeleteCustomClass(classId);
Utils.ResponseMeg(result, string.Empty);
return;
#endregion
}
#endregion
}
else
{
#region 初始化客户
//绑定客户类别
IList <EyouSoft.Model.SMSStructure.CustomerClass> classList = custBll.GetCustomerClass(CurrentUserCompanyID);
if (classList != null && classList.Count > 0)
{
selClass.DataTextField = "ClassName";
selClass.DataValueField = "ID";
selClass.DataSource = classList;
selClass.DataBind();
}
selClass.Items.Insert(0, new ListItem("请选择", ""));
//初始化客户
if (custId != "")
{
EyouSoft.Model.SMSStructure.CustomerList custModel = custBll.GetCustomer(custId);
if (custModel != null)
{
txtUserName.Value = custModel.CustomerContactName;
txtRemark.Value = custModel.ReMark;
txtMobile.Value = custModel.MobileNumber;
txtCompanyName.Value = custModel.CustomerCompanyName;
selClass.Value = custModel.ClassID.ToString();
}
}
#endregion
}
}
/// <summary>
/// 分页获取信息
/// </summary>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="companyId">公司编号</param>
/// <param name="customerCompanyName">客户公司名称 为空时不做为查询条件</param>
/// <param name="customerUserFullName">客户联系人姓名 为空时不做为查询条件</param>
/// <param name="mobile">手机号码 为空时不做为查询条件</param>
/// <param name="categoryId">客户类型编号 -1时不做为查询条件</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.SMSStructure.CustomerList> GetList(int pageSize, int pageIndex, ref int recordCount, string companyId, string customerCompanyName, string customerUserFullName, string mobile, int categoryId)
{
IList <EyouSoft.Model.SMSStructure.CustomerList> customers = new List <EyouSoft.Model.SMSStructure.CustomerList>();
StringBuilder cmdQuery = new StringBuilder();
string tableName = "view_SMS_Customers";
string primaryKey = "ID";
string orderByString = "IssueTime DESC";
string fields = " ID, CompanyID, UserID, CustomerCompanyName, CustomerContactName, ClassID, ReMark, MobileNumber, IssueTime, ClassName";
cmdQuery.Append(" 1=1 ");
cmdQuery.AppendFormat(" and CompanyID='{0}' ", companyId);
//switch (source)
//{
// case EyouSoft.Model.SMSStructure.CustomerList.CustomerSource.所有客户: //注意TongYCompanyId<>companyId是用来排除自己的
// cmdQuery.AppendFormat(" AND (CompanyID='{0}' OR CompanyID='0') AND TongYCompanyId <> '{0}' ", companyId);
// break;
// case EyouSoft.Model.SMSStructure.CustomerList.CustomerSource.我的客户:
// cmdQuery.AppendFormat(" AND CompanyID='{0}' ", companyId);
// break;
// case EyouSoft.Model.SMSStructure.CustomerList.CustomerSource.平台组团社客户://注意TongYCompanyId<>companyId是用来排除自己的
// cmdQuery.AppendFormat(" AND CompanyID='0' AND TongYCompanyId <> '{0}' ", companyId);
// break;
//}
//单位名称
if (!string.IsNullOrEmpty(customerCompanyName))
{
cmdQuery.AppendFormat(" AND (CustomerCompanyName LIKE '%{0}%')", customerCompanyName);
}
//姓名
if (!string.IsNullOrEmpty(customerUserFullName))
{
cmdQuery.AppendFormat(" AND (CustomerContactName LIKE '%{0}%')", customerUserFullName);
}
//手机
if (!string.IsNullOrEmpty(mobile))
{
cmdQuery.AppendFormat(" AND (MobileNumber LIKE '%{0}%')", mobile);
}
//分类
if (categoryId != -1 && categoryId != 0)
{
cmdQuery.AppendFormat(" AND ClassID={0}", categoryId.ToString());
}
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, cmdQuery.ToString(), orderByString))
{
EyouSoft.Model.SMSStructure.CustomerList model = null;
while (rdr.Read())
{
model = new EyouSoft.Model.SMSStructure.CustomerList();
model.ID = rdr.GetString(rdr.GetOrdinal("ID")).Trim();
model.CompanyID = rdr.GetInt32(rdr.GetOrdinal("CompanyID"));
model.UserID = rdr.GetInt32(rdr.GetOrdinal("UserID"));
model.CustomerCompanyName = rdr["CustomerCompanyName"].ToString();
model.CustomerContactName = rdr["CustomerContactName"].ToString();
model.ClassID = rdr.GetInt32(rdr.GetOrdinal("ClassID"));
model.ClassName = rdr["ClassName"].ToString();
model.ReMark = rdr["ReMark"].ToString();
model.MobileNumber = rdr["MobileNumber"].ToString();
model.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
customers.Add(model);
}
}
return(customers);
}