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