示例#1
0
 /// <summary>
 /// 新增操作,返回自增长ID
 /// </summary>
 /// <param name="info"></param>
 /// <param name="credId"></param>
 /// <returns></returns>
 public int InsertCreditInfo(CreditInfo info, out int credId)
 {
     credId = 0;
     if (info == null)
     {
         return 0;
     }
     return DAL.InsertCreditInfo(info, out credId);
 }
示例#2
0
 /// <summary>
 /// 根据债权ID获取债权信息
 /// </summary>
 /// <param name="credID"></param>
 /// <returns></returns>
 public CreditInfo GetCreditInfoByCredID(object credID)
 {
     int id = XYECOM.Core.MyConvert.GetInt32(credID.ToString());
     CreditInfo info = new CreditInfo();
     if (id <= 0)
     {
         return info;
     }
     return new CreditInfoManager().GetCreditInfoById(id);
 }
示例#3
0
 /// <summary>
 /// 增加债权信息
 /// </summary>
 /// <param name="info"></param>
 /// <returns></returns>
 public bool InsertCreditInfo(CreditInfo info)
 {
     if (info == null)
     {
         return false;
     }
     int result = DAL.InsertCreditInfo(info);
     if (result > 0)
     {
         return true;
     }
     else
     {
         return false;
     }
 }
示例#4
0
        /// <summary>
        /// 根据编号获取抵债信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public CreditInfo GetCreditInfoById(int id)
        {
            string sql = "SELECT * FROM CreditInfo WHERE CreditId = @Id";
            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@Id",id),
            };
            CreditInfo info = null;

            using (SqlDataReader reader = XYECOM.Core.Data.SqlHelper.ExecuteReader(CommandType.Text, sql, param))
            {
                if (reader.Read())
                {
                    info = new CreditInfo();

                    info.CreditId = id;
                    info.Title = reader["Title"].ToString();
                    info.Age = reader["Age"].ToString();
                    info.ApprovaStatus = Core.MyConvert.GetInt32(reader["ApprovaStatus"].ToString());
                    info.AreaId = Core.MyConvert.GetInt32(reader["AreaId"].ToString());
                    info.Arrears = Core.MyConvert.GetDecimal(reader["Arrears"].ToString());
                    info.Bounty = Core.MyConvert.GetDecimal(reader["Bounty"].ToString());
                    info.CollectionPeriod = reader["CollectionPeriod"].ToString();
                    info.CreateDate = Core.MyConvert.GetDateTime(reader["CreateDate"].ToString());
                    info.DebtObligation = reader["DebtObligation"].ToString();
                    info.DebtorName = reader["DebtorName"].ToString();
                    info.DebtorReason = reader["DebtorReason"].ToString();
                    info.DebtorTelpone = reader["DebtorTelpone"].ToString();
                    info.DebtorType = reader["DebtorType"].ToString();
                    info.DepartId = Core.MyConvert.GetInt32(reader["DepartId"].ToString());
                    info.Introduction = reader["Introduction"].ToString();
                    info.IsConfirm = Core.MyConvert.GetBoolean(reader["IsConfirm"].ToString());
                    info.IsCreditEvaluation = Core.MyConvert.GetBoolean(reader["IsCreditEvaluation"].ToString());
                    info.IsInLitigation = Core.MyConvert.GetBoolean(reader["IsInLitigation"].ToString());
                    info.IsLitigationed = Core.MyConvert.GetBoolean(reader["IsLitigationed"].ToString());
                    info.IsSelfCollection = Core.MyConvert.GetBoolean(reader["IsSelfCollection"].ToString());
                    info.IsServerEvaluation = Core.MyConvert.GetBoolean(reader["IsServerEvaluation"].ToString());
                    info.IsCreditEvaluation = Core.MyConvert.GetBoolean(reader["IsCreditEvaluation"].ToString());
                    info.LicenseType = reader["LicenseType"].ToString();
                    info.PassDate = Core.MyConvert.GetDateTime(reader["PassDate"].ToString());
                    info.Remark = reader["Remark"].ToString();
                    info.UserId = Core.MyConvert.GetInt32(reader["UserId"].ToString());
                    info.IsDraft = Core.MyConvert.GetBoolean(reader["IsDraft"].ToString());
                }
            }
            return info;
        }
示例#5
0
        protected void btnOk_Click(object sender, EventArgs e)
        {
            string goUrl = string.Empty;
            CreditInfo info = new CreditInfo();
            info.Title = this.txtTitle.Text.Trim();
            info.Age = this.txtAge.Text.Trim();
            string radSelect = this.radSelect.SelectedValue;
            if (radSelect == "草稿")
            {
                goUrl = "DraftCreditList.aspx";
                info.ApprovaStatus = (int)CreditState.Draft;
            }
            else
            {
                goUrl = "CreditInfoList.aspx";
                info.ApprovaStatus = (int)CreditState.Null;
            }
            info.AreaId = MyConvert.GetInt32(this.areaid.Value);
            info.Arrears = MyConvert.GetDecimal(this.txtArrears.Text.Trim());
            info.Bounty = MyConvert.GetDecimal(this.txtBounty.Text.Trim());
            info.CollectionPeriod = this.txtCollectionPeriod.Text.Trim();
            info.CreateDate = DateTime.Now;
            string debtObligation = string.Empty;
            for (int i = 0; i < this.cheDebtObligation.Items.Count; i++)
            {
                if (this.cheDebtObligation.Items[i].Selected == true)
                {
                    debtObligation += this.cheDebtObligation.Items[i].Value + ",";
                }
            }
            if (debtObligation.Length > 0)
            {
                info.DebtObligation = debtObligation.Substring(0, debtObligation.Length - 1);
            }
            else
            {
                info.DebtObligation = "";
            }
            info.DebtorName = this.txtDebtorName.Text.Trim();
            info.DebtorReason = this.txtDebtorReason.Text.Trim();
            info.DebtorTelpone = this.txtDebtorTelpone.Text.Trim();
            info.DebtorType = this.rdDebtorType.SelectedValue;
            info.DepartId = MyConvert.GetInt32(userinfo.userid.ToString());
            info.Introduction = this.txtIntroduction.Text.Trim();
            info.IsConfirm = this.radIsConfirm.SelectedValue == "1" ? true : false;
            info.IsInLitigation = this.radIsInLitigation.SelectedValue == "1" ? true : false;
            info.IsLitigationed = this.radIsLitigationed.SelectedValue == "1" ? true : false;
            info.IsSelfCollection = this.radIsSelfCollection.SelectedValue == "1" ? true : false;
            info.LicenseType = this.rdLicenseType.SelectedValue;
            info.Remark = this.txtRemark.Text.Trim();
            info.IsDraft = false;
            info.UserId = MyConvert.GetInt32(userinfo.CompanyId.ToString());
            int credId = 0;
            int result = credManage.InsertCreditInfo(info, out credId);

            string caseType = Request.Form["case"];

            if (caseType == "1")
            {
                //添加选择的档案信息
                RelatedCaseInfoManager relateManage = new RelatedCaseInfoManager();
                string strCase = this.hdgetid.Value;
                string[] cases = strCase.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
                relateManage.RelatedInfo(TableInfoType.ZqInfo, credId, userinfo.userid, userinfo.CompanyId, cases);
            }

            if (caseType == "0")
            {
                Business.CaseManager caseManager = new Business.CaseManager();

                string filePath = CaseUploadManager.UpLoadFile(userinfo.CompanyId, userinfo.userid, 0);

                CaseInfo caseInfo = new CaseInfo();
                caseInfo.CaseName = info.Title;
                caseInfo.CaseTypeId = 0;
                caseInfo.CaseTypeName = "默认分类";
                caseInfo.CompanyId = userinfo.CompanyId;
                caseInfo.CompanyName = userinfo.CompanyName;
                caseInfo.CreateDate = DateTime.Now;
                caseInfo.Description = info.Introduction;
                caseInfo.FilePath = filePath;
                caseInfo.PartId = userinfo.userid;
                caseInfo.PartName = userinfo.LayerName;
                int infoId = 0;

                caseManager.Insert(caseInfo, out infoId);

                RelatedCaseInfoManager relateManage = new RelatedCaseInfoManager();

                relateManage.RelatedInfo(TableInfoType.ZqInfo, credId, userinfo.userid, userinfo.CompanyId, infoId);
            }

            if (result > 0)
            {
                this.udCreditInfo.InfoID = credId;
                this.udCreditInfo.Update();
                GotoMsgBoxPageForDynamicPage("添加债权信息成功!", 1, goUrl);
            }
            else
            {
                GotoMsgBoxPageForDynamicPage("添加债权信息失败!", 1, goUrl);
            }
        }
示例#6
0
 /// <summary>
 /// 增加债权信息
 /// </summary>
 /// <param name="info"></param>
 /// <returns></returns>
 public int InsertCreditInfo(CreditInfo info)
 {
     string sql = @"Insert into CreditInfo (Title,DebtorName,DebtorTelpone,CollectionPeriod,DebtorReason,Arrears,Bounty,
                             Remark,LicenseType,DebtorType,Introduction,Age,IsInLitigation,IsLitigationed,IsSelfCollection,IsConfirm,
                             DebtObligation,DepartId,UserId,ApprovaStatus,CreateDate,AreaId,IsDraft)
                             values (@Title,@DebtorName,@DebtorTelpone,@CollectionPeriod,@DebtorReason,@Arrears,@Bounty,@Remark,
                             @LicenseType,@DebtorType,@Introduction,@Age,@IsInLitigation,@IsLitigationed,@IsSelfCollection,@IsConfirm,
                             @DebtObligation,@DepartId,@UserId,@ApprovaStatus,@CreateDate,@AreaId,@IsDraft)";
     SqlParameter[] param = new SqlParameter[]
     {
         new SqlParameter("@Title",info.Title),
         new SqlParameter("@DebtorName",info.DebtorName),
         new SqlParameter("@DebtorTelpone",info.DebtorTelpone),
         new SqlParameter("@CollectionPeriod",info.CollectionPeriod),
         new SqlParameter("@DebtorReason",info.DebtorReason),
         new SqlParameter("@Arrears",info.Arrears),
         new SqlParameter("@Bounty",info.Bounty),
         new SqlParameter("@Remark",info.Remark),
         new SqlParameter("@LicenseType",info.LicenseType),
         new SqlParameter("@DebtorType",info.DebtorType),
         new SqlParameter("@Introduction",info.Introduction),
         new SqlParameter("@Age",info.Age),
         new SqlParameter("@IsInLitigation",info.IsInLitigation),
         new SqlParameter("@IsLitigationed",info.IsLitigationed),
         new SqlParameter("@IsSelfCollection",info.IsSelfCollection),
         new SqlParameter("@IsConfirm",info.IsConfirm),
         new SqlParameter("@DebtObligation",info.DebtObligation),
         new SqlParameter("@DepartId",info.DepartId),
         new SqlParameter("@UserId",info.UserId),
         new SqlParameter("@ApprovaStatus",info.ApprovaStatus),
         new SqlParameter("@CreateDate",info.CreateDate),
         new SqlParameter("@AreaId",info.AreaId),
         new SqlParameter("@IsDraft",info.IsDraft)
     };
     int rowAffected = SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
     return rowAffected;
 }
示例#7
0
        /// <summary>
        /// 修改债权信息
        /// </summary>
        /// <param name="info"></param>
        /// <returns></returns>
        public int UpdateCreditInfoByID(CreditInfo info)
        {
            string sql = @"UPDATE CreditInfo SET Title =
                                    @Title,DebtorName=@DebtorName,DebtorTelpone=@DebtorTelpone,CollectionPeriod=@CollectionPeriod,DebtorReason=@DebtorReason,
                                    Arrears=@Arrears,Bounty=@Bounty,Remark=@Remark,LicenseType=@LicenseType,DebtorType=@DebtorType,Introduction=@Introduction,
                                    Age=@Age,IsInLitigation=@IsInLitigation,IsLitigationed=@IsLitigationed,IsSelfCollection=@IsSelfCollection,IsConfirm=@IsConfirm,DebtObligation=@DebtObligation,
                                   ApprovaStatus=@ApprovaStatus,AreaId=@AreaId,IsDraft=@IsDraft WHERE CreditId=@CreditId";

            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@Title",info.Title),
                new SqlParameter("@DebtorName",info.DebtorName),
                new SqlParameter("@DebtorTelpone",info.DebtorTelpone),
                new SqlParameter("@CollectionPeriod",info.CollectionPeriod),
                new SqlParameter("@DebtorReason",info.DebtorReason),
                new SqlParameter("@Arrears",info.Arrears),
                new SqlParameter("@Bounty",info.Bounty),
                new SqlParameter("@Remark",info.Remark),
                new SqlParameter("@LicenseType",info.LicenseType),
                new SqlParameter("@DebtorType",info.DebtorType),
                new SqlParameter("@Introduction",info.Introduction),
                new SqlParameter("@Age",info.Age),
                new SqlParameter("@IsInLitigation",info.IsInLitigation),
                new SqlParameter("@IsLitigationed",info.IsLitigationed),
                new SqlParameter("@IsSelfCollection",info.IsSelfCollection),
                new SqlParameter("@IsConfirm",info.IsConfirm),
                new SqlParameter("@DebtObligation",info.DebtObligation),
                new SqlParameter("@ApprovaStatus",info.ApprovaStatus),
                new SqlParameter("@AreaId",info.AreaId),
                new SqlParameter("@CreditId",info.CreditId),
                new SqlParameter("@IsDraft",info.IsDraft)
            };
            int rowAffected = SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
            return rowAffected;
        }
示例#8
0
        /// <summary>
        /// 新增并获取自增长列的值
        /// </summary>
        /// <param name="info"></param>
        /// <param name="Id"></param>
        /// <returns></returns>
        public int InsertCreditInfo(CreditInfo info, out int Id)
        {
            string sql = @"Insert into CreditInfo (Title,DebtorName,DebtorTelpone,CollectionPeriod,DebtorReason,Arrears,Bounty,
                                    Remark,LicenseType,DebtorType,Introduction,Age,IsInLitigation,IsLitigationed,IsSelfCollection,IsConfirm,
                                    DebtObligation,DepartId,UserId,ApprovaStatus,CreateDate,AreaId,IsDraft)
                                    values (@Title,@DebtorName,@DebtorTelpone,@CollectionPeriod,@DebtorReason,@Arrears,@Bounty,@Remark,
                                    @LicenseType,@DebtorType,@Introduction,@Age,@IsInLitigation,@IsLitigationed,@IsSelfCollection,@IsConfirm,
                                    @DebtObligation,@DepartId,@UserId,@ApprovaStatus,@CreateDate,@AreaId,@IsDraft);select @ID = @@identity";
            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@ID",SqlDbType.Int),
                new SqlParameter("@Title",info.Title),
                new SqlParameter("@DebtorName",info.DebtorName),
                new SqlParameter("@DebtorTelpone",info.DebtorTelpone),
                new SqlParameter("@CollectionPeriod",info.CollectionPeriod),
                new SqlParameter("@DebtorReason",info.DebtorReason),
                new SqlParameter("@Arrears",info.Arrears),
                new SqlParameter("@Bounty",info.Bounty),
                new SqlParameter("@Remark",info.Remark),
                new SqlParameter("@LicenseType",info.LicenseType),
                new SqlParameter("@DebtorType",info.DebtorType),
                new SqlParameter("@Introduction",info.Introduction),
                new SqlParameter("@Age",info.Age),
                new SqlParameter("@IsInLitigation",info.IsInLitigation),
                new SqlParameter("@IsLitigationed",info.IsLitigationed),
                new SqlParameter("@IsSelfCollection",info.IsSelfCollection),
                new SqlParameter("@IsConfirm",info.IsConfirm),
                new SqlParameter("@DebtObligation",info.DebtObligation),
                new SqlParameter("@DepartId",info.DepartId),
                new SqlParameter("@UserId",info.UserId),
                new SqlParameter("@ApprovaStatus",info.ApprovaStatus),
                new SqlParameter("@CreateDate",info.CreateDate),
                new SqlParameter("@AreaId",info.AreaId),
                new SqlParameter("@IsDraft",info.IsDraft)

            };
            param[0].Direction = ParameterDirection.Output;
            int rowAffected = SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
            if (rowAffected >= 0)
            {
                if (param[0].Value != null && param[0].Value.ToString() != "")
                    Id = (int)param[0].Value;
                else
                    Id = 0;
            }
            else
            {
                Id = -1;
            }
            return rowAffected;
        }
示例#9
0
 /// <summary>
 /// 修改债权信息
 /// </summary>
 /// <param name="info"></param>
 /// <returns></returns>
 public int UpdateCreditInfoByID(CreditInfo info)
 {
     if (info == null)
     {
         return 0;
     }
     return DAL.UpdateCreditInfoByID(info);
 }