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