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!"); } }
/// <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()); } } }
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)), ""); }
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); }
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)); }
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)); }
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(); }
/// <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()); } } }
/// <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()); } } }
public void order(int quantity, CREDIT credit, QUALITY quality, DELIVERY deliveryTime) { throw new System.NotImplementedException(); }
public Kardex(CREDIT selectedCredit) { InitializeComponent(); fillKardex(selectedCredit); }
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; }