public ActionResult ClienterBatchSave()
{
string businessId = Request.Params["BusinessId"].ToString();
string OverallS = Request.Params["OverallS"].ToString();
List <BusinessBindClienterDM> list = ParseHelper.JSONStringToList <BusinessBindClienterDM>(Request.Params["OverallS"].ToString());
for (int i = 0; i < list.Count; i++)
{
if (list[i].IsBind)//前台选中绑定记录
{
string phone = list[i].ClienterPhoneNo;
string name = list[i].ClienterName;
int clienterId = iClienterProvider.GetId(phone, name);
BusinessClienterRelation model = iBusinessClienterRelationProvider.GetDetails(new BusinessClienterRelationPM
{
BusinessId = Convert.ToInt32(businessId),
ClienterId = clienterId
});
if (model == null)//插入
{
iBusinessProvider.AddClienterBind(new ClienterBindOptionLogModel {
BusinessId = Convert.ToInt32(businessId),
ClienterId = clienterId,
OptId = UserContext.Current.Id,
OptName = UserContext.Current.Name,
Remark = "添加绑定"
});
}
else if (model != null && model.IsBind == 0)//更新
{
iBusinessProvider.ModifyClienterBind(new ClienterBindOptionLogModel
{
BusinessId = Convert.ToInt32(businessId),
ClienterId = clienterId,
OptId = UserContext.Current.Id,
OptName = UserContext.Current.Name,
Remark = "修改绑定",
IsBind = 1
});
}
}
}
return(Json(new Ets.Model.Common.ResultModel(true, "保存成功！", JsonRequestBehavior.DenyGet)));
}
/// <summary>
/// 获取商户骑士对应关系
/// </summary>
/// <UpdateBy>hulingbo</UpdateBy>
/// <UpdateTime>20150609</UpdateTime>
/// <param name="id"></param>
/// <returns></returns>
public BusinessClienterRelation GetDetails(BusinessClienterRelationPM businessClienterRelation)
{
BusinessClienterRelation model = null;
string querySql = @"
select Id,BusinessId,ClienterId,IsEnable,CreateBy,CreateTime,UpdateBy,UpdateTime,IsBind
from dbo.[BusinessClienterRelation] (nolock )
where IsEnable=1 and BusinessId=@BusinessId and ClienterId=@ClienterId";
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.AddWithValue("BusinessId", businessClienterRelation.BusinessId);
dbParameters.AddWithValue("ClienterId", businessClienterRelation.ClienterId);
DataTable dt = DataTableHelper.GetTable(DbHelper.ExecuteDataset(SuperMan_Read, querySql, dbParameters));
if (DataTableHelper.CheckDt(dt) && dt.Rows.Count > 0)
{
model = MapRows <BusinessClienterRelation>(dt)[0];
}
return(model);
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <UpdateBy>hulingbo</UpdateBy>
/// <UpdateTime>20150609</UpdateTime>
/// <param name="businessBalanceRecord"></param>
/// <returns></returns>
public int Insert(BusinessClienterRelation businessClienterRelation)
{
const string insertSql = @"
insert into BusinessClienterRelation(BusinessId,ClienterId,CreateBy,UpdateBy)
values(@BusinessId,@ClienterId,@CreateBy,@UpdateBy)
select @@IDENTITY";
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.AddWithValue("BusinessId", businessClienterRelation.BusinessId);
dbParameters.AddWithValue("ClienterId", businessClienterRelation.ClienterId);
dbParameters.AddWithValue("CreateBy", businessClienterRelation.CreateBy);
dbParameters.AddWithValue("UpdateBy", businessClienterRelation.UpdateBy);
object result = DbHelper.ExecuteScalar(SuperMan_Write, insertSql, dbParameters);
if (result == null)
{
return(0);
}
return(ParseHelper.ToInt(result.ToString()));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <UpdateBy>hulingbo</UpdateBy>
/// <UpdateTime>20150609</UpdateTime>
/// <param name="model"></param>
/// <returns></returns>
public int Create(BusinessClienterRelation businessClienterRelation)
{
return(businessClienterRelationDao.Insert(businessClienterRelation));
}
