コード例 #1
0
        /// <summary>
        ///  更新一条数据
        /// </summary>
        public int Update(Entities.CC_MagazineReturn model)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter("@RecID",        SqlDbType.Int,         4),
                new SqlParameter("@CustID",       SqlDbType.VarChar,    50),
                new SqlParameter("@ContactID",    SqlDbType.Int,         4),
                new SqlParameter("@DMSMemberID",  SqlDbType.VarChar,    50),
                new SqlParameter("@Title",        SqlDbType.VarChar,   200),
                new SqlParameter("@Status",       SqlDbType.Int,         4),
                new SqlParameter("@CMDID",        SqlDbType.Int,         4),
                new SqlParameter("@CreateTime",   SqlDbType.DateTime),
                new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
            };
            parameters[0].Value = model.RecID;
            parameters[1].Value = model.CustID;
            parameters[2].Value = model.ContactID;
            parameters[3].Value = model.DMSMemberID;
            parameters[4].Value = model.Title;
            parameters[5].Value = model.Status;
            parameters[6].Value = model.CMDID;
            parameters[7].Value = model.CreateTime;
            parameters[8].Value = model.CreateUserID;

            return(SqlHelper.ExecuteNonQuery(ConnectionStrings_CRM, CommandType.StoredProcedure, P_CC_MAGAZINERETURN_UPDATE, parameters));
        }
コード例 #2
0
        /// <summary>
        ///  增加一条数据
        /// </summary>
        public int Insert(Entities.CC_MagazineReturn model)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter("@RecID",        SqlDbType.Int,       4),
                new SqlParameter("@CustID",       SqlDbType.VarChar,  50),
                new SqlParameter("@ContactID",    SqlDbType.Int,       4),
                new SqlParameter("@DMSMemberID",  SqlDbType.VarChar,  50),
                new SqlParameter("@Title",        SqlDbType.VarChar, 200),
                new SqlParameter("@Status",       SqlDbType.Int,       4),
                new SqlParameter("@CMDID",        SqlDbType.Int,       4),
                new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
            };
            parameters[0].Direction = ParameterDirection.Output;
            parameters[1].Value     = model.CustID;
            parameters[2].Value     = model.ContactID;
            parameters[3].Value     = model.DMSMemberID;
            parameters[4].Value     = model.Title;
            parameters[5].Value     = model.Status;
            parameters[6].Value     = model.CMDID;
            parameters[7].Value     = model.CreateUserID;

            SqlHelper.ExecuteNonQuery(ConnectionStrings_CRM, CommandType.StoredProcedure, P_CC_MAGAZINERETURN_INSERT, parameters);
            return((int)parameters[0].Value);
        }
コード例 #3
0
        private Entities.CC_MagazineReturn LoadSingleCC_MagazineReturn(DataRow row)
        {
            Entities.CC_MagazineReturn model = new Entities.CC_MagazineReturn();

            if (row["RecID"].ToString() != "")
            {
                model.RecID = int.Parse(row["RecID"].ToString());
            }
            model.CustID = row["CustID"].ToString();
            if (row["ContactID"].ToString() != "")
            {
                model.ContactID = int.Parse(row["ContactID"].ToString());
            }
            model.DMSMemberID = row["DMSMemberID"].ToString();
            model.Title       = row["Title"].ToString();
            if (row["Status"].ToString() != "")
            {
                model.Status = int.Parse(row["Status"].ToString());
            }
            if (row["CMDID"].ToString() != "")
            {
                model.CMDID = int.Parse(row["CMDID"].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);
        }
コード例 #4
0
        /// <summary>
        /// 合同和它的金额(数组:0-总金额 1-现有金额)
        /// </summary>
        //private Dictionary<string, decimal[]> contractMoney = new Dictionary<string, decimal[]>();

        /// <summary>
        /// 校验
        /// </summary>
        private bool Valid(int rowNum, IDataReader reader, List <MagezineInfoImportExceptionInfo> exceptionInfoList, Dictionary <Entities.CC_MagazineReturn, string> magezineInfoList)
        {
            bool currentSuccess = true;
            MagezineInfoImportExceptionInfo ex = new MagezineInfoImportExceptionInfo();

            #region validate

            string custId     = reader[0].ToString().Trim();
            string memberCode = reader[2].ToString().Trim();
            string contacter  = reader[4].ToString().Trim();;

            int    contractId  = -1;
            string dmsMemberID = string.Empty;

            if (string.IsNullOrEmpty(custId) && string.IsNullOrEmpty(memberCode) && string.IsNullOrEmpty(contacter))
            {
                return(currentSuccess);//此行为空行
            }

            //判断UserID参数

            int intval = 0;
            if (!int.TryParse(UserID, out intval))
            {
                ex.Info.Append("用户ID参数不正确");
                currentSuccess = false;
            }

            //客户信息验证
            if (string.IsNullOrEmpty(custId))
            {
                ex.Info.Append("第" + rowNum + "行此[客户ID]不可为空。");
                currentSuccess = false;
            }
            else
            {
                BitAuto.YanFa.Crm2009.Entities.CustInfo custInfo = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(custId);
                if (custInfo == null)
                {
                    ex.Info.Append("第" + rowNum + "行此[客户ID]不存在。");
                    currentSuccess = false;
                }
            }

            //会员信息验证
            if (string.IsNullOrEmpty(memberCode))
            {
                ex.Info.Append("第" + rowNum + "行此[会员ID]不可为空。");
                currentSuccess = false;
            }
            else
            {
                List <BitAuto.YanFa.Crm2009.Entities.DMSMember> dmsMembers = BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.GetDMSMemberByCustID(custId);

                if (dmsMembers == null)
                {
                    ex.Info.Append("第" + rowNum + "行此[会员ID]不存在。");
                    currentSuccess = false;
                }
                else
                {
                    bool isExist = false;
                    foreach (BitAuto.YanFa.Crm2009.Entities.DMSMember dmsMember in dmsMembers)
                    {
                        if (dmsMember.MemberCode == memberCode.Trim())
                        {
                            isExist     = true;
                            dmsMemberID = dmsMember.ID.ToString();
                        }
                    }
                    if (!isExist)
                    {
                        ex.Info.Append("第" + rowNum + "行此客户下不存在此[会员ID]。");
                        currentSuccess = false;
                    }
                }
            }

            if (string.IsNullOrEmpty(contacter))
            {
                ex.Info.Append("第" + rowNum + "行此[联系人]不可为空。");
                currentSuccess = false;
            }
            else
            {
                contacter = contacter.Replace(',', ',');
                string[] contacterArry = contacter.Split(',');

                foreach (string cter in contacterArry)
                {
                    BitAuto.YanFa.Crm2009.Entities.QueryContactInfo query = new BitAuto.YanFa.Crm2009.Entities.QueryContactInfo();
                    query.CustID = custId;
                    query.CName  = cter.Trim();

                    int       totalCount = 0;
                    DataTable dt         = BitAuto.YanFa.Crm2009.BLL.ContactInfo.Instance.GetContactInfo(query, "", 1, 1, out totalCount);
                    if (dt.Rows.Count <= 0)
                    {
                        ex.Info.Append("第" + rowNum + "行联系人<" + cter + ">不存在。");
                        currentSuccess = false;
                    }
                    else
                    {
                        contractId = int.Parse(dt.Rows[0]["ID"].ToString());
                    }
                }
            }

            if (string.IsNullOrEmpty(CooperationName))
            {
                ex.Info.Append("合作名称不能为空");
                currentSuccess = false;
            }
            else
            {
                Entities.QueryCC_MagazineReturn query = new Entities.QueryCC_MagazineReturn();
                query.Title       = "第" + cooperationName + "期";
                query.Status      = 0;
                query.DMSMemberID = dmsMemberID;
                int       totalCount = 0;
                DataTable dt         = BLL.CC_MagazineReturn.Instance.GetCC_MagazineReturn(query, "", 1, 1, out totalCount);
                if (dt.Rows.Count > 0)
                {
                    ex.Info.Append("第" + rowNum + "行已经存在此期的会员");
                    currentSuccess = false;
                }
            }

            #endregion
            //如通过则插入数据
            if (currentSuccess)
            {
                Entities.CC_MagazineReturn info = new Entities.CC_MagazineReturn();
                info.ContactID    = contractId;
                info.CreateTime   = DateTime.Now;
                info.CreateUserID = int.Parse(UserID);
                info.CustID       = custId;
                info.DMSMemberID  = dmsMemberID;
                info.Title        = "第" + cooperationName + "期";
                info.Status       = 0;
                magezineInfoList.Add(info, contacter);
            }
            else
            {
                exceptionInfoList.Add(ex);
            }

            return(currentSuccess);
        }
コード例 #5
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Insert(Entities.CC_MagazineReturn model)
 {
     return(Dal.CC_MagazineReturn.Instance.Insert(model));
 }
コード例 #6
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public int Update(Entities.CC_MagazineReturn model)
 {
     return(Dal.CC_MagazineReturn.Instance.Update(model));
 }