/// <summary>
/// 新增
/// </summary>
/// <param name="model">实体对象</param>
/// <returns></returns>
public int Add(Common.Entity.DealerContact model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Insert into DealerContact(DealerID,Name,JobID,Phone,MobileTel,Fax,Email,OtherContactInfo,Remark) Values");
strSql.Append("(@DealerID,@Name,@JobID,@Phone,@MobileTel,@Fax,@Email,@OtherContactInfo,@Remark)");
strSql.Append(";SELECT @@IDENTITY");// 返回插入用户的主键
SqlParameter[] param =
{
new SqlParameter("@DealerID", model.DealerID),
new SqlParameter("@Name", model.Name),
new SqlParameter("@JobID", model.JobID),
new SqlParameter("@Phone", model.Phone),
new SqlParameter("@MobileTel", model.MobileTel),
new SqlParameter("@Fax", model.Fax),
new SqlParameter("@Email", model.Email),
new SqlParameter("@OtherContactInfo", model.OtherContactInfo),
new SqlParameter("@Remark", model.Remark),
};
try
{
return(SqlHelper.ExecuteNonQuery(SqlHelper.connStr, CommandType.Text, strSql.ToString(), param));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 获取实体对象
/// </summary>
/// <param name="PKID">PKID</param>
/// <returns></returns>
public Common.Entity.DealerContact GetDealerContactByPKID(int PKID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select DL.Name as 所属经销店,DT.ListName as 职务,
DC.* from DealerContact DC
left join Dealer DL on DC.DealerID=DL.PKID
left join Dictionary DT on DC.JobID=DT.PKID where DC.PKID=@PKID");
SqlParameter[] param =
{
new SqlParameter("@PKID", PKID)
};
DataTable dt = SqlHelper.GetDateTable(SqlHelper.connStr, CommandType.Text, strSql.ToString(), param);
Common.Entity.DealerContact model = null;
if (dt.Rows.Count > 0)
{
model = new Common.Entity.DealerContact();
model.PKID = Convert.ToInt32(dt.Rows[0]["PKID"]);
model.DealerID = Convert.ToInt32(dt.Rows[0]["DealerID"]);
model.Name = dt.Rows[0]["Name"].ToString();
model.JobID = Convert.ToInt32(dt.Rows[0]["JobID"]);
model.DealerName = dt.Rows[0]["所属经销店"].ToString();
model.JobName = dt.Rows[0]["职务"].ToString();
model.Phone = dt.Rows[0]["Phone"].ToString();
model.Email = dt.Rows[0]["Email"].ToString();
model.OtherContactInfo = dt.Rows[0]["OtherContactInfo"].ToString();
model.MobileTel = dt.Rows[0]["MobileTel"].ToString();
model.Fax = dt.Rows[0]["Fax"].ToString();
model.Remark = dt.Rows[0]["Remark"].ToString();
return(model);
}
return(model);
}
/// <summary>
/// 修改一条记录
/// </summary>
/// <param name="model">实体类</param>
/// <returns></returns>
public bool Update(Common.Entity.DealerContact model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"Update DealerContact set Name=@Name,JobID=@JobID,Phone=@Phone,
MobileTel=@MobileTel,Fax=@Fax,Email=@Email,OtherContactInfo=@OtherContactInfo,
Remark=@Remark where PKID=@PKID");
SqlParameter[] param =
{
new SqlParameter("@PKID", model.PKID),
new SqlParameter("@Name", model.Name),
new SqlParameter("@JobID", model.JobID),
new SqlParameter("@Phone", model.Phone),
new SqlParameter("@MobileTel", model.MobileTel),
new SqlParameter("@Fax", model.Fax),
new SqlParameter("@Email", model.Email),
new SqlParameter("@OtherContactInfo", model.OtherContactInfo),
new SqlParameter("@Remark", model.Remark),
};
object obj = SqlHelper.ExecuteNonQuery(SqlHelper.connStr, CommandType.Text, strSql.ToString(), param);
try
{
if (Convert.ToInt32(obj) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 经销店联系人分页列表
/// </summary>
/// <param name="context">上下文对象</param>
public void GetDealerContactManagerPager(HttpContext context)
{
int pageIndex = Convert.ToInt32(context.Request["page"]); // 当前页码
int pageSize = Convert.ToInt32(context.Request["rows"]); // 页码大小
int totalCount = 0;
var orderName = context.Request["sort"]; // 排序字段
var orderBy = context.Request["sortOrder"]; // 排序规则
var sort = sortInfo.GetSortOrder(orderName, orderBy);
userName = context.User.Identity.Name;
SysUserEntity model = new BLL.sysUser().GetSysUserByLoginName(userName);
List <Common.Entity.DealerContact> list = new List <Common.Entity.DealerContact>();
string search_Name = context.Request.Form["Name"];
int search_JobID = Convert.ToInt32(context.Request.Form["JobID"]);
Common.Entity.DealerContact filter = new Common.Entity.DealerContact
{
Name = search_Name,
JobID = search_JobID
};
if (sort.SortName != null && !string.IsNullOrEmpty(sort.IsDesc))
{
list = new BLL.DealerContact().GetDealerContactManagerPager(pageIndex, pageSize, model.DealerId, sort.SortName, sort.IsDesc, filter, out totalCount);
}
else
{
list = new BLL.DealerContact().GetDealerContactManagerPager(pageIndex, pageSize, model.DealerId, filter, out totalCount);
}
var models = new BLL.BoostrapTableInfo <Common.Entity.DealerContact>
{
total = totalCount,
rows = list
};
string resultJson = JsonConvert.SerializeObject(models);
context.Response.Write(resultJson);
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="context">上下文对象</param>
public void SaveDealerContact(HttpContext context)
{
int HidId = Convert.ToInt32(context.Request["HidId"]); // 获取前端隐藏域ID用来判断是新增还是修改操作
int jobId = Convert.ToInt32(context.Request.Form["fr_JobID"]);
int DealerId = Convert.ToInt32(context.Request.Form["DealerId"]);
string name = context.Request.Form["fr_Name"];
string Phone = context.Request.Form["Phone"];
string MobileTel = context.Request.Form["MobileTel"];
string Fax = context.Request.Form["Fax"];
string Email = context.Request.Form["Email"];
string OtherContactInfo = context.Request.Form["OtherContactInfo"];
string Remark = context.Request.Form["Remark"];
BLL.DealerContact bll = new BLL.DealerContact();
if (HidId <= 0)
{
// 添加
Common.Entity.DealerContact model = new Common.Entity.DealerContact();
bool IsExistsNameAndMobileTel = bll.Exists(name, MobileTel);
model.DealerID = DealerId;
model.Name = name;
model.JobID = jobId;
model.Phone = Phone;
model.MobileTel = MobileTel;
model.Fax = Fax;
model.Email = Email;
model.OtherContactInfo = OtherContactInfo;
model.Remark = Remark;
int result = bll.Add(model);
if (IsExistsNameAndMobileTel)
{
context.Response.Write("{\"msg\":\"经销店联系人已存在(经销店，姓名，移动电话)，请修改。\",\"state\":\"T\"}");
}
else if (result > 0)
{
context.Response.Write("{\"msg\":\"保存成功。\",\"success\":true}");
}
else
{
context.Response.Write("{\"msg\":\"保存失败,请重试。\",\"success\":false}");
}
}
else
{
Common.Entity.DealerContact entity = new Common.Entity.DealerContact();
entity.PKID = HidId;
entity.Name = name;
entity.JobID = jobId;
entity.Phone = Phone;
entity.MobileTel = MobileTel;
entity.Fax = Fax;
entity.Email = Email;
entity.OtherContactInfo = OtherContactInfo;
entity.Remark = Remark;
bool result = bll.Update(entity);
if (result)
{
context.Response.Write("{\"msg\":\"保存成功。\",\"success\":true}");
}
else
{
context.Response.Write("{\"msg\":\"保存失败。\",\"success\":false}");
}
}
}
/// <summary>
/// 从服务器端获取经销店分页列表
/// </summary>
/// <param name="pageIndex">当前页码</param>
/// <param name="pageSize">页码大小</param>
/// <param name="totalCount">总记录数</param>
/// <returns></returns>
public List <Common.Entity.DealerContact> GetDealerContactManagerPager(int pageIndex, int pageSize, int dealerId, Common.Entity.DealerContact keywork, out int totalCount)
{
using (IDbConnection conn = new SqlConnection(SqlHelper.connStr))
{
StringBuilder sqlCount = new StringBuilder();
sqlCount.Append(@"select count(@pageSize) from (select DL.Name as DealerName,DT.ListName as JobName,DC.* from DealerContact DC
left join Dealer DL on DC.DealerID=DL.PKID
left join Dictionary DT on DC.JobID=DT.PKID where DC.PKID>0 and DC.DealerID=@DealerID");
if (!string.IsNullOrEmpty(keywork.Name))
{
sqlCount.Append(@" and DC.Name like '%" + keywork.Name + "%'");
}
if (keywork.JobID > 0)
{
sqlCount.Append(@" and DC.JobID=@JobID");
}
sqlCount.Append(@" ) as T");
DynamicParameters param1 = new DynamicParameters();
param1.Add("pageSize", pageSize);
param1.Add("DealerID", dealerId);
param1.Add("JobID", keywork.JobID);
totalCount = conn.Query <int>(sqlCount.ToString(), param1).FirstOrDefault();// 输出总记录数
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select top (@pageSize) * from (select row_number() over (order by DC.Name) as rowNumber,
DL.Name as DealerName,DT.ListName as JobName,
DC.* from DealerContact DC
left join Dealer DL on DC.DealerID=DL.PKID
left join Dictionary DT on DC.JobID=DT.PKID where DC.PKID>0 and DC.DealerID=@DealerID");
if (!string.IsNullOrEmpty(keywork.Name))
{
strSql.Append(@" and DC.Name like '%" + keywork.Name + "%'");
}
if (keywork.JobID > 0)
{
strSql.Append(@" and DC.JobID=@JobID");
}
strSql.Append(@" ) as t where t.rowNumber>(@pageIndex-1)*@pageSize ");
DynamicParameters param2 = new DynamicParameters();
param2.Add("pageSize", pageSize);
param2.Add("pageIndex", pageIndex);
param2.Add("DealerID", dealerId);
param2.Add("JobID", keywork.JobID);
List <Common.Entity.DealerContact> list = conn.Query <Common.Entity.DealerContact>(strSql.ToString(), param2).ToList();
return(list);
};
}
/// <summary>
/// 修改一条记录
/// </summary>
/// <param name="model">实体类</param>
/// <returns></returns>
public bool Update(Common.Entity.DealerContact model)
{
return(new DAL.DealerContact().Update(model));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model">实体对象</param>
/// <returns></returns>
public int Add(Common.Entity.DealerContact model)
{
return(new DAL.DealerContact().Add(model));
}
