Exemplo n.º 1
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            string Name       = txtName.Text;
            string Amount     = txtAmount.Text;
            string Commission = txtCom.Text;
            string Rate       = txtRate.Text;
            string Term       = txtTerm.Text;
            string Type       = cmbType.Text;

            if (Name != "" && Amount != "" && Commission != "" && Rate != "" && Type != "Select credit type..." && Term != "")
            {
                CREDIT cr = new CREDIT()
                {
                    NAME          = Name,
                    DISBURSEMENT  = Convert.ToInt32(Amount),
                    COMMISSION    = Convert.ToInt32(Commission),
                    INTEREST_RATE = Convert.ToInt32(Rate),
                    TERM          = Convert.ToInt32(Term),
                    CREDIT_TYPE   = db.CREDIT_TYPES.FirstOrDefault(c => c.NAME == Type).ID
                };
                db.CREDITS.Add(cr);
                db.SaveChanges();
                clearCreditForm();
            }
            else
            {
                MessageBox.Show("Please, fill in all fields!");
            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// 插入产品
        /// </summary>
        /// <param name="p"></param>
        /// <returns></returns>
        public static int insertCredit(CREDIT c)
        {
            using (SqlConnection conn = new SqlConnection(Conn.connString))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = string.Format("SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;SELECT MAX(ID) from T_CREDIT where SUBSTRING(ID,1,8)='{0}';", DateTime.Now.ToString("yyyyMMdd"));
                    string id = string.Empty;
                    id = cmd.ExecuteScalar().ToString();
                    if (!string.IsNullOrEmpty(id))
                    {
                        c.id = (Convert.ToInt64(id) + 1).ToString();
                    }
                    else
                    {
                        c.id = DateTime.Now.ToString("yyyyMMdd") + "0001";
                    }


                    cmd.CommandText = string.Format(@"insert into T_CREDIT (ID,ACCOUNTTYPE,AMOUNT,PAYTYPE,DATE,PID,CID,UID,COUNT) VALUES ('{0}',N'{1}',{2},N'{3}','{4}','{5}','{6}','{7}',{8})",
                                                    c.id, c.accounttype, Convert.ToDecimal(c.amount), c.paytype, c.date, c.pid, c.cid, c.uid, Convert.ToInt32(c.count));
                    return(cmd.ExecuteNonQuery());
                }
            }
        }
Exemplo n.º 3
0
        private void fillKardex(CREDIT selectedCredit)
        {
            this.selectedCredit = selectedCredit;
            dgwKardex.DefaultCellStyle
            .Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgwKardex.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgwKardex.ColumnCount     = 5;
            dgwKardex.Columns[0].Name = "Months";
            dgwKardex.Columns[1].Name = "Monthly PR payment";
            dgwKardex.Columns[2].Name = "Monthly Int payment";
            dgwKardex.Columns[3].Name = "Monthly Total payment";
            dgwKardex.Columns[4].Name = "Outstanding balance";

            int    months      = Convert.ToInt32(selectedCredit.TERM);
            double outBalance  = Convert.ToDouble(selectedCredit.DISBURSEMENT);
            double prPay       = Convert.ToDouble(outBalance / months);
            double sumInterest = 0;

            for (int i = 1; i <= months; i++)
            {
                double intPay = Convert.ToDouble(outBalance * selectedCredit.INTEREST_RATE / 100 / 12);
                sumInterest += intPay;
                double totPay = prPay + intPay;
                outBalance -= prPay;
                dgwKardex.Rows.Add(i, String.Format("{0:n}", Math.Round(prPay, 2)), String.Format("{0:n}", Math.Round(intPay, 2)), String.Format("{0:n}", Math.Round(totPay, 2)), String.Format("{0:n}", Math.Round(outBalance, 2)));
            }
            dgwKardex.Rows.Add("Total", String.Format("{0:n}", Math.Round(Convert.ToDouble(selectedCredit.DISBURSEMENT), 2)), String.Format("{0:n}", Math.Round(sumInterest, 2)), String.Format("{0:n}", Math.Round(sumInterest + Convert.ToDouble(selectedCredit.DISBURSEMENT), 2)), "");
        }
Exemplo n.º 4
0
        public static List <CREDIT> DataToCredit(DataTable dt)
        {
            List <CREDIT> list = new List <CREDIT>();

            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    CREDIT d = new CREDIT
                    {
                        id          = dt.Rows[i]["ID"].ToString(),
                        accounttype = dt.Rows[i]["ACCOUNTTYPE"].ToString(),
                        amount      = dt.Rows[i]["AMOUNT"].ToString(),
                        paytype     = dt.Rows[i]["PAYTYPE"].ToString(),
                        date        = dt.Rows[i]["DATE"].ToString(),
                        pid         = dt.Rows[i]["PID"].ToString(),
                        cid         = dt.Rows[i]["CID"].ToString(),
                        uid         = dt.Rows[i]["UID"].ToString(),
                        count       = dt.Rows[i]["COUNT"].ToString(),
                        customer    = DB_Customer.C_Customer(dt.Rows[i]["CID"].ToString()),
                        product     = DB_Product.C_Product(dt.Rows[i]["PID"].ToString())
                    };
                    list.Add(d);
                }
            }
            return(list);
        }
Exemplo n.º 5
0
        public HttpResponseMessage deleteCredit([FromBody] CREDIT c)
        {
            Result <CREDIT> ru     = new Result <CREDIT>();
            int             result = 0;

            try
            {
                result = DB_Credit.deleteCredit(c);

                if (result == 1)
                {
                    ru.code    = "7020";
                    ru.success = "true";
                    ru.message = "删除成功!";
                }
                else
                {
                    ru.code    = "7021";
                    ru.success = "false";
                    ru.message = "删除失败";
                }
            }
            catch (Exception e) {
                ru.code    = "7022";
                ru.success = "false";
                ru.message = e.Message;
            }

            ru.systemTime = Conn.GetTimeStamp();
            ru.data       = null;

            return(Conn.toJson(ru));
        }
Exemplo n.º 6
0
        public HttpResponseMessage queryCredit([FromBody] CREDIT c)
        {
            Result <CREDIT> ru        = new Result <CREDIT>();
            List <CREDIT>   lcustomer = new List <CREDIT>();

            try
            {
                lcustomer = DB_Credit.getCredit(c.uid);

                if (lcustomer.Count > 0)
                {
                    ru.code    = "7030";
                    ru.success = "true";
                    ru.message = "获取成功!";
                }
                else
                {
                    ru.code    = "7031";
                    ru.success = "false";
                    ru.message = "无数据";
                }
            }
            catch (Exception e) {
                ru.code    = "7032";
                ru.success = "false";
                ru.message = e.Message;
            }

            ru.systemTime = Conn.GetTimeStamp();
            ru.data       = lcustomer;

            return(Conn.toJson(ru));
        }
Exemplo n.º 7
0
        private void selectRow(object sender, DataGridViewCellMouseEventArgs e)
        {
            int Id = Convert.ToInt32(dgwCredits.Rows[e.RowIndex].Cells[0].Value);

            selectedCredit = db.CREDITS.FirstOrDefault(c => c.ID == Id);
            Kardex krd = new Kardex(selectedCredit);

            krd.Show();
        }
Exemplo n.º 8
0
 /// <summary>
 /// 修改产品
 /// </summary>
 /// <param name="p"></param>
 /// <returns></returns>
 public static int modeCredit(CREDIT c)
 {
     using (SqlConnection conn = new SqlConnection(Conn.connString))
     {
         conn.Open();
         using (SqlCommand cmd = conn.CreateCommand())
         {
             cmd.CommandText = string.Format(@"update T_CREDIT set ACCOUNTTYPE=N'{0}',AMOUNT={1},PAYTYPE=N'{2}',DATE='{3}',PID='{4}',CID='{5}',COUNT={6} where ID='{7}' ", c.accounttype, Convert.ToDecimal(c.amount), c.paytype, c.date, c.pid, c.cid, Convert.ToInt32(c.count), c.id);
             return(cmd.ExecuteNonQuery());
         }
     }
 }
Exemplo n.º 9
0
 /// <summary>
 /// 删除产品
 /// </summary>
 /// <param name="p"></param>
 /// <returns></returns>
 public static int deleteCredit(CREDIT c)
 {
     using (SqlConnection conn = new SqlConnection(Conn.connString))
     {
         conn.Open();
         using (SqlCommand cmd = conn.CreateCommand())
         {
             cmd.CommandText = string.Format(@"delete from T_CREDIT where ID='{0}'",
                                             c.id);
             return(cmd.ExecuteNonQuery());
         }
     }
 }
Exemplo n.º 10
0
 public void order(int quantity, CREDIT credit, QUALITY quality, DELIVERY deliveryTime)
 {
     throw new System.NotImplementedException();
 }
Exemplo n.º 11
0
 public void order(int quantity, CREDIT credit, QUALITY quality, DELIVERY deliveryTime)
 {
     throw new System.NotImplementedException();
 }
Exemplo n.º 12
0
 public Kardex(CREDIT selectedCredit)
 {
     InitializeComponent();
     fillKardex(selectedCredit);
 }
Exemplo n.º 13
0
 public SubjectElem(string name, int year, int semester, CREDIT credit, string lecturer)
 {
     Name = name;
     Year = year;
     Semester = semester;
     Credit = credit;
     Lecturer = lecturer;
     Assessment = ASSESSMENT.NONE;
 }