/// <summary> /// 增加一条数据 /// </summary> public int AddMemberContactMapping(Entities.ProjectTask_MemberContactMapping model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ProjectTask_MemberContactMapping("); strSql.Append("MemberID,ContactID,IsMain,CreateTime)"); strSql.Append(" values ("); strSql.Append("@MemberID,@ContactID,@IsMain,@CreateTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MemberID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ContactID", SqlDbType.Int, 4), new SqlParameter("@IsMain", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameters[0].Value = model.MemberID; parameters[1].Value = model.ContactID; parameters[2].Value = model.IsMain; parameters[3].Value = model.CreateTime; object obj = SqlHelper.ExecuteScalar(CONNECTIONSTRINGS, CommandType.Text, strSql.ToString(), parameters); return(obj == null ? 0 : Convert.ToInt32(obj)); }
/// <summary> /// 更新一条数据 /// </summary> public bool UpdateMemberContactMapping(Entities.ProjectTask_MemberContactMapping model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ProjectTask_MemberContactMapping set "); strSql.Append("MemberID=@MemberID,"); strSql.Append("ContactID=@ContactID,"); strSql.Append("IsMain=@IsMain,"); strSql.Append("CreateTime=@CreateTime"); strSql.Append(" where RecID=@RecID"); SqlParameter[] parameters = { new SqlParameter("@MemberID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ContactID", SqlDbType.Int, 4), new SqlParameter("@IsMain", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@RecID", SqlDbType.Int, 4) }; parameters[0].Value = model.MemberID; parameters[1].Value = model.ContactID; parameters[2].Value = model.IsMain; parameters[3].Value = model.CreateTime; parameters[4].Value = model.RecID; int rows = SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.Text, strSql.ToString(), parameters); return(rows > 0); }
/// <summary> /// 选择主要负责人的会员处理 /// </summary> internal void YesSelectMainHandle(int contactid) { if (!string.IsNullOrEmpty(YesMainIDs)) { string[] memberids = YesMainIDs.Split(','); foreach (string memberid in memberids) { //取消原有的负责人 DataTable dt = BLL.ProjectTask_MemberContactMapping.Instance.GetList("CC_MCM.MemberID='" + memberid + "' AND CC_MCM.IsMain = 1"); if (dt != null && dt.Rows.Count > 0) { Entities.ProjectTask_MemberContactMapping mapping = BLL.ProjectTask_MemberContactMapping.Instance.GetModel(Convert.ToInt32(dt.Rows[0]["RecID"])); if (mapping != null) { mapping.IsMain = 0; BLL.ProjectTask_MemberContactMapping.Instance.UpdateMemberContactMapping(mapping); } } //设置新的负责人 Entities.ProjectTask_MemberContactMapping model = BLL.ProjectTask_MemberContactMapping.Instance.GetModel(memberid, contactid); if (model != null) { model.IsMain = 1; BLL.ProjectTask_MemberContactMapping.Instance.UpdateMemberContactMapping(model); } } } }
/// <summary> /// 未选择会员处理 /// </summary> internal void NotSelectMemberHandle(int contactid) { if (!string.IsNullOrEmpty(NotMemberIDs)) { string[] memberids = NotMemberIDs.Split(','); foreach (string memberid in memberids) { Entities.ProjectTask_MemberContactMapping model = BLL.ProjectTask_MemberContactMapping.Instance.GetModel(memberid, contactid); if (model != null) { BLL.ProjectTask_MemberContactMapping.Instance.DeleteMemberContactMapping(model.RecID); } } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Entities.ProjectTask_MemberContactMapping GetModel(string memberid, int contactid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 RecID,MemberID,ContactID,IsMain,CreateTime from ProjectTask_MemberContactMapping "); strSql.Append(" where MemberID=@MemberID and ContactID =@ContactID"); SqlParameter[] parameters = { new SqlParameter("@MemberID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ContactID", SqlDbType.Int, 4) }; parameters[0].Value = new Guid(memberid); parameters[1].Value = contactid; Entities.ProjectTask_MemberContactMapping model = new Entities.ProjectTask_MemberContactMapping(); DataSet ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["RecID"] != null && ds.Tables[0].Rows[0]["RecID"].ToString() != "") { model.RecID = int.Parse(ds.Tables[0].Rows[0]["RecID"].ToString()); } if (ds.Tables[0].Rows[0]["MemberID"] != null && ds.Tables[0].Rows[0]["MemberID"].ToString() != "") { model.MemberID = new Guid(ds.Tables[0].Rows[0]["MemberID"].ToString()); } if (ds.Tables[0].Rows[0]["ContactID"] != null && ds.Tables[0].Rows[0]["ContactID"].ToString() != "") { model.ContactID = int.Parse(ds.Tables[0].Rows[0]["ContactID"].ToString()); } if (ds.Tables[0].Rows[0]["IsMain"] != null && ds.Tables[0].Rows[0]["IsMain"].ToString() != "") { model.IsMain = int.Parse(ds.Tables[0].Rows[0]["IsMain"].ToString()); } if (ds.Tables[0].Rows[0]["CreateTime"] != null && ds.Tables[0].Rows[0]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString()); } } else { model = null; } return(model); }
/// <summary> /// 选择的会员处理 /// </summary> internal void YesSelectMemberHandle(int contactid) { if (!string.IsNullOrEmpty(YesMemberIDs)) { string[] memberids = YesMemberIDs.Split(','); foreach (string memberid in memberids) { Entities.ProjectTask_MemberContactMapping model = BLL.ProjectTask_MemberContactMapping.Instance.GetModel(memberid, contactid); if (model == null) { model = new Entities.ProjectTask_MemberContactMapping(); model.MemberID = new Guid(memberid); model.ContactID = contactid; model.IsMain = 0; model.CreateTime = DateTime.Now; BLL.ProjectTask_MemberContactMapping.Instance.AddMemberContactMapping(model); } } } }
/// <summary> /// 获得数据列表 /// </summary> private List <Entities.ProjectTask_MemberContactMapping> DataTableToList(DataTable dt) { List <Entities.ProjectTask_MemberContactMapping> modelList = new List <Entities.ProjectTask_MemberContactMapping>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Entities.ProjectTask_MemberContactMapping model; for (int n = 0; n < rowsCount; n++) { model = new Entities.ProjectTask_MemberContactMapping(); if (dt.Rows[n]["RecID"] != null && dt.Rows[n]["RecID"].ToString() != "") { model.RecID = int.Parse(dt.Rows[n]["RecID"].ToString()); } if (dt.Rows[n]["MemberID"] != null && dt.Rows[n]["MemberID"].ToString() != "") { model.MemberID = new Guid(dt.Rows[n]["MemberID"].ToString()); } if (dt.Rows[n]["ContactID"] != null && dt.Rows[n]["ContactID"].ToString() != "") { model.ContactID = int.Parse(dt.Rows[n]["ContactID"].ToString()); } if (dt.Rows[n]["IsMain"] != null && dt.Rows[n]["IsMain"].ToString() != "") { model.IsMain = int.Parse(dt.Rows[n]["IsMain"].ToString()); } if (dt.Rows[n]["CreateTime"] != null && dt.Rows[n]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(dt.Rows[n]["CreateTime"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public bool UpdateMemberContactMapping(Entities.ProjectTask_MemberContactMapping model) { return(Dal.ProjectTask_MemberContactMapping.Instance.UpdateMemberContactMapping(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int AddMemberContactMapping(Entities.ProjectTask_MemberContactMapping model) { return(Dal.ProjectTask_MemberContactMapping.Instance.AddMemberContactMapping(model)); }