public List <REPAY_HIS> DataToRepay(DataTable dt) { List <REPAY_HIS> list = new List <REPAY_HIS>(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { REPAY_HIS r = new REPAY_HIS(); r.B_SYSID = dt.Rows[i]["B_SYSID"].ToString(); r.R_AMOUNT = dt.Rows[i]["R_AMOUNT"].ToString(); r.R_TYPE = dt.Rows[i]["R_TYPE"].ToString(); r.R_FINE = dt.Rows[i]["R_FINE"].ToString(); r.R_DATE = dt.Rows[i]["R_DATE"].ToString(); r.R_ISDEL = dt.Rows[i]["R_ISDEL"].ToString(); r.R_SYSID = dt.Rows[i]["R_SYSID"].ToString(); r.R_INTEREST = dt.Rows[i]["R_INTEREST"].ToString(); List <BORROW> lb = new T_BORROW_SQL(connstring).Get_Borrow(dt.Rows[i]["B_SYSID"].ToString()); if (lb.Count > 0) { r.BORROW = lb[0]; } else { r.BORROW = new BORROW(); } r.NUM = dt.Rows[i]["NUM"].ToString(); list.Add(r); } } return(list); }
public int Insert(REPAY_HIS r) { using (SqlConnection conn = new SqlConnection(connstring)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = string.Format("SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;SELECT MAX(R_SYSID) FROM T_REPAY_HIS WHERE B_SYSID='{0}' ;", r.B_SYSID); string r_sysid = string.Empty; r_sysid = cmd.ExecuteScalar().ToString(); if (string.IsNullOrEmpty(r_sysid)) { r_sysid = r.B_SYSID + "01"; } else { r_sysid = (Convert.ToInt64(r_sysid) + 1).ToString(); } cmd.CommandText = string.Format(@"INSERT INTO T_REPAY_HIS (B_SYSID,R_AMOUNT,R_TYPE,R_OVERTIME,R_FINE,R_DATE,R_INTEREST,R_SYSID) VALUES ('{0}','{1}',N'{2}','{3}',N'{4}','{5}','{6}','{7}')", r.B_SYSID, r.R_AMOUNT, r.R_TYPE, r.R_OVERTIME, r.R_FINE, r.R_DATE, r.R_INTEREST, r_sysid); return(cmd.ExecuteNonQuery()); } } }
public void UpdateByRepayUpdate(REPAY_HIS r, double diff) { using (SqlConnection conn = new SqlConnection(connstring)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = string.Format(@"UPDATE T_BORROW SET B_REPAYMENT=B_REPAYMENT+{0} WHERE B_SYSID='{1}'", diff, r.B_SYSID); cmd.ExecuteNonQuery(); } } }
public REPAY_HIS FaceToDate() { REPAY_HIS repay = new REPAY_HIS(); repay.B_SYSID = ddlBSysid.Text.Split('-')[0]; repay.R_AMOUNT = edtRamount.Text.Trim(); //repay.R_DATE = DateTime.Now.ToString("yyyy-MM-dd"); repay.R_DATE = edtR_date.Text; repay.R_OVERTIME = edtOverTime.Text; repay.R_FINE = edtRFine.Text.Trim(); repay.R_TYPE = edtRType.Text.Trim(); repay.R_INTEREST = edtRInterest.Text.Trim(); return(repay); }
/// <summary> /// 更新 /// </summary> /// <param name="r"></param> /// <returns></returns> public int Update(REPAY_HIS r) { using (SqlConnection conn = new SqlConnection(connstring)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = string.Format(@"UPDATE T_REPAY_HIS SET R_AMOUNT=N'{0}', R_TYPE=N'{1}', R_OVERTIME='{2}', R_FINE='{3}', R_DATE='{4}', R_INTEREST='{6}' WHERE R_SYSID='{5}'", r.R_AMOUNT, r.R_TYPE, r.R_OVERTIME, r.R_FINE, r.R_DATE, r.R_SYSID, r.R_INTEREST); return(cmd.ExecuteNonQuery()); } } }
public object ModRepay(string repay) { try { REPAY_HIS r = new JavaScriptSerializer().Deserialize <REPAY_HIS>(repay); REPAY_HIS ro = repay_his_sql.QueryByWhere_XP(string.Format(" AND R_SYSID='{0}'", r.R_SYSID))[0]; if (repay_his_sql.Update(r) == 1) { borrow_sql.UpdateByRepayUpdate(r, Convert.ToDouble(r.R_AMOUNT) - Convert.ToDouble(ro.R_AMOUNT)); return(new { state = 0, message = "修改成功" }); } else { return(new { state = -1, message = "修改失败" }); } } catch (Exception e) { return(new { state = -222, message = e.Message }); } }
private void btnOK_Click(object sender, EventArgs e) { try { if (Convert.ToDouble(lblBLimit.Text) > 0) { if (MessageBox.Show("确定保存?", "保存提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { string err = CheckData(); if (string.IsNullOrEmpty(err)) { REPAY_HIS r = FaceToDate(); string res; int i = 0; frmWaitingBox f = new frmWaitingBox((obj, args) => { Thread.Sleep(threadTime); i = repay_his_sql.Insert(r); }, waitTime, "Plase Wait...", false, false); f.ShowDialog(this); res = f.Message; if (!string.IsNullOrEmpty(res)) { MessageBox.Show(res); } else { if (i == 1) { borrow_sql.UpdateByRepayInsert(r); lblBLimit.Text = (Convert.ToDouble(lblBLimit.Text) - Convert.ToDouble(edtRamount.Text)).ToString(); bindData(ddlBSysid.Text.Split('-')[0]); edtOverTime.Text = ""; edtRamount.Text = ""; edtRFine.Text = ""; edtRInterest.Text = ""; edtRType.Text = ""; MessageBox.Show("保存成功", "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("保存失败", "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else { MessageBox.Show(err, "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } else { MessageBox.Show("已经还清!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception e1) { MessageBox.Show(e1.Message, "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }