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)); }