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);
}
}
