/// <summary>
/// 添加或编辑删除客户关系信息
/// </summary>
internal void AddDeleteCustRelationInfo()
{
if (!string.IsNullOrEmpty(this.TID) && !string.IsNullOrEmpty(this.DelRelationCustIDs))
{
Entities.ProjectTask_DelCustRelation model = BLL.ProjectTask_DelCustRelation.Instance.GetProjectTask_DelCustRelationByTID(this.TID);
if (model != null)
{
model.CustID = this.CustID;
model.DelCustIDs = this.DelRelationCustIDs;
model.Remark = this.DescriptionWhenDelete;
BLL.ProjectTask_DelCustRelation.Instance.Update(model);
}
else
{
model = new Entities.ProjectTask_DelCustRelation();
model.PTID = this.TID;
model.CustID = this.CustID;
model.DelCustIDs = this.DelRelationCustIDs;
model.Remark = this.DescriptionWhenDelete;
model.CreateTime = DateTime.Now;
model.CreateUserID = BLL.Util.GetLoginUserID();
BLL.ProjectTask_DelCustRelation.Instance.Insert(model);
}
}
}
private Entities.ProjectTask_DelCustRelation LoadSingleProjectTask_DelCustRelation(DataRow row)
{
Entities.ProjectTask_DelCustRelation model = new Entities.ProjectTask_DelCustRelation();
if (row["RecID"].ToString() != "")
{
model.RecID = int.Parse(row["RecID"].ToString());
}
if (row["PTID"].ToString() != "")
{
model.PTID = row["PTID"].ToString();
}
model.CustID = row["CustID"].ToString();
model.DelCustIDs = row["DelCustIDs"].ToString();
model.Remark = row["Remark"].ToString();
if (row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["CreateUserID"].ToString() != "")
{
model.CreateUserID = int.Parse(row["CreateUserID"].ToString());
}
return(model);
}
private void BindData()
{
int count = -1;
BitAuto.YanFa.Crm2009.Entities.QueryCustInfo query = new BitAuto.YanFa.Crm2009.Entities.QueryCustInfo();
Entities.ProjectTask_DelCustRelation model = BLL.ProjectTask_DelCustRelation.Instance.GetProjectTask_DelCustRelationByTID(TID);
if (IsShowdDelCustRelation && model != null &&
!string.IsNullOrEmpty(model.DelCustIDs))
{
query.DelCustIDs = model.DelCustIDs;
}
else
{
if (!string.IsNullOrEmpty(CustName))
{
if (!string.IsNullOrEmpty(CustNameAllMatch) &&
CustNameAllMatch.ToLower().Equals("yes"))
{
query.ExistCustName = CustName;
}
else
{
query.CustName = CustName;
}
}
if (ProvinceID > 0)
{
query.ProvinceID = ProvinceID.ToString();
}
if (CityID > 0)
{
query.CityID = CityID.ToString();
}
if (CountyID > 0)
{
query.CountyID = CountyID.ToString();
}
if (ExceptCustID > 0)
{
query.ExistCustID = ExceptCustID.ToString();
}
if (!string.IsNullOrEmpty(CustAddress))
{
query.Address = CustAddress;
}
//if (!string.IsNullOrEmpty(TradeMarketID))
//{
// query.TradeMarketID = TradeMarketID;
//}
if (!string.IsNullOrEmpty(CustContactName))
{
query.ContactAllName = CustContactName;
}
}
DataTable dt = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(query, "CustName", 1, 100, out count);
repterCustInfo.DataSource = dt;
repterCustInfo.DataBind();
}
/// <summary>
/// 根据TID，更新CustID
/// </summary>
/// <param name="tid">TID</param>
/// <param name="custid">CustID</param>
public void UpdateCustIDByTID(string tid, string custid)
{
Entities.ProjectTask_DelCustRelation model = GetProjectTask_DelCustRelationByTID(tid);
if (model != null)
{
model.CustID = custid;
Update(model);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.ProjectTask_DelCustRelation model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.Int, 4),
new SqlParameter("@PTID", SqlDbType.VarChar, 20),
new SqlParameter("@CustID", SqlDbType.VarChar, 50),
new SqlParameter("@DelCustIDs", SqlDbType.VarChar, 2000),
new SqlParameter("@Remark", SqlDbType.VarChar, 2000),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RecID;
parameters[1].Value = model.PTID;
parameters[2].Value = model.CustID;
parameters[3].Value = model.DelCustIDs;
parameters[4].Value = model.Remark;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.CreateUserID;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_DELCUSTRELATION_UPDATE, parameters));
}
/// <summary>
/// 插入删除客户申请记录
/// </summary>
/// <param name="tid">任务ID</param>
/// <returns></returns>
public int InsertByDelCustRelation(string tid, string cc_CustOriginalName, string cc_CustChangeName)
{
Entities.ProjectTask_DelCustRelation delModel = BLL.ProjectTask_DelCustRelation.Instance.GetProjectTask_DelCustRelationByTID(tid);
if (delModel != null)
{
Entities.ProjectTask_AuditContrastInfo model = new Entities.ProjectTask_AuditContrastInfo();
model.PTID = tid;
model.CustID = delModel.CustID;
model.ContrastInfoInside = delModel.DelCustIDs;
string contrastInfo = "客户名称重复，关联客户ID：" + delModel.DelCustIDs;
if (cc_CustOriginalName != cc_CustChangeName)
{
contrastInfo = "客户名称由：" + cc_CustOriginalName + "，改为：" + cc_CustChangeName + "," + contrastInfo;
}
model.ContrastInfo = contrastInfo; //"客户名称由：" + cc_CustOriginalName + "，改为：" + cc_CustChangeName + "，客户名称重复，关联客户ID：" + delModel.DelCustIDs;
model.ExportStatus = 0; //0-未导出，1-已导出
model.ContrastType = 4;
model.CreateTime = DateTime.Now;
model.CreateUserID = BLL.Util.GetLoginUserID();
model.DisposeStatus = 0;//未处理
return(Insert(model));
}
return(-1);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.ProjectTask_DelCustRelation model)
{
return(Dal.ProjectTask_DelCustRelation.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.ProjectTask_DelCustRelation model)
{
return(Dal.ProjectTask_DelCustRelation.Instance.Insert(model));
}
