public void DataToFace(BORROW b) { edtB_date.Text = b.B_DATETMP; edtBAmount.Text = b.B_AMOUNT; edtCName.Text = b.C_NAME; edtCID.Text = b.C_ID; ddlCSex.Text = b.C_SEX; edtCEmergency.Text = b.C_EMERGENCY; edtCContact.Text = b.C_CONTACT; edtCAddress.Text = b.C_ADDRESS; edtGID1.Text = b.G_ID1; edtGName1.Text = b.G_NAME1; ddlGJob1.Text = b.G_JOB1; edtGID2.Text = b.G_ID2; edtGName2.Text = b.G_NAME2; ddlGJob2.Text = b.G_JOB2; edtGID3.Text = b.G_ID3; edtGName3.Text = b.G_NAME3; ddlGJob3.Text = b.G_JOB3; edtGID4.Text = b.G_ID4; edtGName4.Text = b.G_NAME4; ddlGJob4.Text = b.G_JOB4; edtBInterest.Text = b.B_INTEREST; edtRepay.Text = b.B_REPAYDATE; edtRemind.Text = b.B_REMINDDATE; ddlRepayType.Text = b.B_REPAYTYPE; if (b.C_PIC != null) { pbID.Image = CashBorrowINFO.CS.Help.ReturnPhoto(b.C_PIC); } edtBTerm.Text = b.B_TERM; ddlType.Text = b.B_TYPE; edtCEmergencyName.Text = b.C_EMERGENCYNAME; lblAmount.Text = lblAmount.Text = (Convert.ToDouble(edtBAmount.Text) * Convert.ToDouble(edtBInterest.Text) / 100).ToString("#0.00") + "元"; }
/// <summary> /// 插入 /// </summary> /// <param name="b"></param> /// <param name="u_sysid"></param> /// <returns></returns> public int Insert(BORROW b) { using (SqlConnection conn = new SqlConnection(connstring)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = string.Format("SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;SELECT MAX(B_SYSID) FROM T_BORROW WHERE SUBSTRING(B_SYSID,1,8)='{0}';", DateTime.Now.ToString("yyyyMMdd")); string b_sysid = string.Empty; b_sysid = cmd.ExecuteScalar().ToString(); if (string.IsNullOrEmpty(b_sysid)) { b_sysid = DateTime.Now.ToString("yyyyMMdd") + "20001"; } else { b_sysid = (Convert.ToInt64(b_sysid) + 1).ToString(); } if (b.C_PIC != null) { cmd.CommandText = string.Format(@"INSERT INTO T_BORROW (B_SYSID,U_SYSID,C_NAME,C_ID,C_PIC,C_CONTACT,C_EMERGENCY,C_ADDRESS,C_SEX,G_NAME1,G_ID1,G_JOB1,G_NAME2,G_ID2,G_JOB2,G_NAME3,G_ID3,G_JOB3,G_NAME4,G_ID4,G_JOB4,B_AMOUNT,B_REPAYMENT,B_INTEREST,B_TYPE,B_REPAYDATE,B_REMINDDATE,B_DATE,B_DATETMP,B_TERM,C_EMERGENCYNAME,B_REPAYTYPE ) VALUES ('{0}','{1}',N'{2}','{3}',@C_PIC,'{4}',N'{5}',N'{6}',N'{7}',N'{8}',N'{9}',N'{10}',N'{11}',N'{12}',N'{13}',N'{14}',N'{15}',N'{16}',N'{17}',N'{18}',N'{19}','{20}','{21}','{22}',N'{23}','{24}','{25}','{26}','{27}','{28}',N'{29}',N'{30}')", b_sysid, b.U_SYSID, b.C_NAME, b.C_ID, b.C_CONTACT, b.C_EMERGENCY, b.C_ADDRESS, b.C_SEX, b.G_NAME1, b.G_ID1, b.G_JOB1, b.G_NAME2, b.G_ID2, b.G_JOB2, b.G_NAME3, b.G_ID3, b.G_JOB3, b.G_NAME4, b.G_ID4, b.G_JOB4, b.B_AMOUNT, b.B_REPAYMENT, b.B_INTEREST, b.B_TYPE, b.B_REPAYDATE, b.B_REMINDDATE, b.B_DATE, b.B_DATETMP, b.B_TERM, b.C_EMERGENCYNAME, b.B_REPAYTYPE); cmd.Parameters.Add("@C_PIC", SqlDbType.Image).Value = b.C_PIC; } else { cmd.CommandText = string.Format(@"INSERT INTO T_BORROW (B_SYSID,U_SYSID,C_NAME,C_ID,C_CONTACT,C_EMERGENCY,C_ADDRESS,C_SEX,G_NAME1,G_ID1,G_JOB1,G_NAME2,G_ID2,G_JOB2,G_NAME3,G_ID3,G_JOB3,G_NAME4,G_ID4,G_JOB4,B_AMOUNT,B_REPAYMENT,B_INTEREST,B_TYPE,B_REPAYDATE,B_REMINDDATE,B_DATE,B_DATETMP,B_TERM,C_EMERGENCYNAME,B_REPAYTYPE ) VALUES ('{0}','{1}',N'{2}','{3}','{4}',N'{5}',N'{6}',N'{7}',N'{8}',N'{9}',N'{10}',N'{11}',N'{12}',N'{13}',N'{14}',N'{15}',N'{16}',N'{17}',N'{18}',N'{19}','{20}','{21}','{22}',N'{23}','{24}','{25}','{26}','{27}','{28}',N'{29}',N'{30}')", b_sysid, b.U_SYSID, b.C_NAME, b.C_ID, b.C_CONTACT, b.C_EMERGENCY, b.C_ADDRESS, b.C_SEX, b.G_NAME1, b.G_ID1, b.G_JOB1, b.G_NAME2, b.G_ID2, b.G_JOB2, b.G_NAME3, b.G_ID3, b.G_JOB3, b.G_NAME4, b.G_ID4, b.G_JOB4, b.B_AMOUNT, b.B_REPAYMENT, b.B_INTEREST, b.B_TYPE, b.B_REPAYDATE, b.B_REMINDDATE, b.B_DATE, b.B_DATETMP, b.B_TERM, b.C_EMERGENCYNAME, b.B_REPAYTYPE); } return(cmd.ExecuteNonQuery()); } } }
public string Import(DataTable myds) { try { if (myds.Rows.Count == 0) { return("无数据"); } List <BORROW> lb = new List <BORROW>(); for (int i = 0; i < myds.Rows.Count; i++) { BORROW b = new BORROW(); b.C_NAME = myds.Rows[i][0].ToString(); b.C_ID = myds.Rows[i][1].ToString(); b.C_CONTACT = myds.Rows[i][2].ToString(); b.C_EMERGENCYNAME = myds.Rows[i][3].ToString(); b.C_EMERGENCY = myds.Rows[i][4].ToString(); b.C_ADDRESS = myds.Rows[i][5].ToString(); b.C_SEX = myds.Rows[i][6].ToString(); b.G_NAME1 = myds.Rows[i][7].ToString(); b.G_ID1 = myds.Rows[i][8].ToString(); b.G_JOB1 = myds.Rows[i][9].ToString(); b.G_NAME2 = myds.Rows[i][10].ToString(); b.G_ID2 = myds.Rows[i][11].ToString(); b.G_JOB2 = myds.Rows[i][12].ToString(); b.G_NAME3 = myds.Rows[i][13].ToString(); b.G_ID3 = myds.Rows[i][14].ToString(); b.G_JOB3 = myds.Rows[i][15].ToString(); b.G_NAME4 = myds.Rows[i][16].ToString(); b.G_ID4 = myds.Rows[i][17].ToString(); b.G_JOB4 = myds.Rows[i][18].ToString(); b.B_AMOUNT = myds.Rows[i][19].ToString(); b.B_REPAYMENT = myds.Rows[i][20].ToString(); b.B_INTEREST = myds.Rows[i][21].ToString(); b.B_TERM = myds.Rows[i][22].ToString(); b.B_TYPE = myds.Rows[i][23].ToString(); b.B_REPAYDATE = myds.Rows[i][24].ToString(); b.B_REMINDDATE = myds.Rows[i][25].ToString(); b.B_DATE = DateTime.Parse(myds.Rows[i][26].ToString()).ToString("yyyy-MM-dd"); b.B_DATETMP = DateTime.Parse(myds.Rows[i][27].ToString()).ToString("yyyy-MM-dd hh:mm:ss"); b.U_SYSID = logonUser.U_SYSID; b.C_PIC = new byte[0]; if (borrow_sql.Insert(b) != 1) { return(b.C_NAME + " 借款资料导入失败,请修改导入资料,重新导入后续资料"); } progressBar.Value = (i + 1) * 100 / myds.Rows.Count; Application.DoEvents(); } return("导入成功!"); } catch (Exception e1) { return(e1.Message); } }
public BORROW FaceToData() { BORROW b = new BORROW(); b.B_AMOUNT = edtBAmount.Text.Trim(); b.C_NAME = edtCName.Text.Trim(); b.C_ID = edtCID.Text.Trim(); b.C_SEX = ddlCSex.Text; if (pbID.Image != null) { b.C_PIC = CashBorrowINFO.CS.Help.ReturnByte(pbID.Image); } else { b.C_PIC = null; } b.C_EMERGENCY = edtCEmergency.Text.Trim(); b.C_CONTACT = edtCContact.Text.Trim(); b.C_ADDRESS = edtCAddress.Text.Trim(); b.G_ID1 = edtGID1.Text.Trim(); b.G_NAME1 = edtGName1.Text.Trim(); b.G_JOB1 = ddlGJob1.Text; b.G_ID2 = edtGID2.Text.Trim(); b.G_NAME2 = edtGName2.Text.Trim(); b.G_JOB2 = ddlGJob2.Text; b.G_ID3 = edtGID3.Text.Trim(); b.G_NAME3 = edtGName3.Text.Trim(); b.G_JOB3 = ddlGJob3.Text; b.G_ID4 = edtGID4.Text.Trim(); b.G_NAME4 = edtGName4.Text.Trim(); b.G_JOB4 = ddlGJob4.Text; b.B_DATE = edtB_date.Text.Substring(0, 10); b.B_INTEREST = edtBInterest.Text.Trim(); b.B_DATETMP = edtB_date.Text; b.B_REPAYMENT = "0"; b.B_REPAYDATE = edtRepay.Text; b.B_REMINDDATE = edtRemind.Text; b.U_SYSID = logonUser.U_SYSID; b.B_TYPE = ddlType.Text; b.B_SYSID = b_sysid; b.B_TERM = edtBTerm.Text.Trim(); b.C_EMERGENCYNAME = edtCEmergencyName.Text.Trim(); b.USER = logonUser; b.B_REPAYTYPE = ddlRepayType.Text.Trim(); return(b); }
public int Update_web(BORROW b) { using (SqlConnection conn = new SqlConnection(connstring)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = string.Format(@"UPDATE T_BORROW SET C_NAME=N'{0}', C_ID='{1}', C_CONTACT='{2}', C_EMERGENCY='{3}', C_ADDRESS=N'{4}', C_SEX=N'{5}', G_NAME1=N'{6}', G_ID1='{7}', G_JOB1=N'{8}', G_NAME2=N'{9}', G_ID2='{10}', G_JOB2=N'{11}', G_NAME3=N'{12}', G_ID3='{13}', G_JOB3=N'{14}', G_NAME4=N'{15}', G_ID4='{16}', G_JOB4=N'{17}', B_AMOUNT='{18}', B_REPAYMENT='{19}', B_INTEREST='{20}', B_TYPE=N'{21}', B_REPAYDATE='{22}', B_REMINDDATE='{23}', B_DATE='{24}', B_DATETMP='{25}', B_TERM={27}, C_EMERGENCYNAME=N'{28}', B_REPAYTYPE=N'{29}' WHERE B_SYSID='{26}'", b.C_NAME, b.C_ID, b.C_CONTACT, b.C_EMERGENCY, b.C_ADDRESS, b.C_SEX, b.G_NAME1, b.G_ID1, b.G_JOB1, b.G_NAME2, b.G_ID2, b.G_JOB2, b.G_NAME3, b.G_ID3, b.G_JOB3, b.G_NAME4, b.G_ID4, b.G_JOB4, b.B_AMOUNT, b.B_REPAYMENT, b.B_INTEREST, b.B_TYPE, b.B_REPAYDATE, b.B_REMINDDATE, b.B_DATE, b.B_DATETMP, b.B_SYSID, b.B_TERM, b.C_EMERGENCYNAME, b.B_REPAYTYPE); return(cmd.ExecuteNonQuery()); } } }
private void Borrow_form_Load(object sender, EventArgs e) { edtB_date.Text = DateTime.Now.ToString(); saveFileDialog1.FileName = logonUser.U_NAME + "_" + DateTime.Now.ToString("yyyyMMdd"); try { if (!string.IsNullOrEmpty(b_sysid)) { string res; List <BORROW> borrow = new List <BORROW>(); frmWaitingBox f = new frmWaitingBox((obj, args) => { Thread.Sleep(threadTime); borrow = borrow_sql.QueryByWhere_XP(string.Format(" AND B_SYSID='{0}'", b_sysid), true); }, waitTime, "Plase Wait...", false, false); f.ShowDialog(this); res = f.Message; if (!string.IsNullOrEmpty(res)) { MessageBox.Show(res); } else { if (borrow.Count > 0) { b = borrow[0]; } DataToFace(borrow[0]); } } else { btnPrint.Enabled = false; } } catch (Exception e1) { MessageBox.Show(e1.Message, "加载提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public Print_form(BORROW b) { InitializeComponent(); string res; List <BORROW> lborrow = new List <BORROW>(); frmWaitingBox f = new frmWaitingBox((obj, args) => { Thread.Sleep(threadTime); lborrow = borrow_sql.QueryByWhere_XP(string.Format(" AND B_SYSID='{0}'", b.B_SYSID), false); }, waitTime, "Plase Wait...", false, false); f.ShowDialog(this); res = f.Message; if (!string.IsNullOrEmpty(res)) { MessageBox.Show(res); } else { if (lborrow.Count > 0) { borrow = lborrow[0]; } else { MessageBox.Show("数据读取异常!"); btnPrePrint.Enabled = false; btnPrint.Enabled = false; btnSetPrint.Enabled = false; } } this.printDocument1.OriginAtMargins = true; //启用页边距 this.pageSetupDialog1.EnableMetric = true; //以毫米为单位 }
public List <BORROW> DataToCustomer(DataTable dt, bool flag) { List <BORROW> list = new List <BORROW>(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { BORROW b = new BORROW(); b.NUM = dt.Rows[i]["NUM"].ToString(); b.B_SYSID = dt.Rows[i]["B_SYSID"].ToString(); b.U_SYSID = dt.Rows[i]["U_SYSID"].ToString(); b.C_NAME = dt.Rows[i]["C_NAME"].ToString(); b.C_ID = dt.Rows[i]["C_ID"].ToString(); if (flag) { if (dt.Rows[i]["C_PIC"].ToString() == "") { b.C_PIC = null; } else { b.C_PIC = (byte[])dt.Rows[i]["C_PIC"]; } } b.C_CONTACT = dt.Rows[i]["C_CONTACT"].ToString(); b.C_EMERGENCY = dt.Rows[i]["C_EMERGENCY"].ToString(); b.C_ADDRESS = dt.Rows[i]["C_ADDRESS"].ToString(); b.C_SEX = dt.Rows[i]["C_SEX"].ToString(); b.G_NAME1 = dt.Rows[i]["G_NAME1"].ToString(); b.G_ID1 = dt.Rows[i]["G_ID1"].ToString(); b.G_JOB1 = dt.Rows[i]["G_JOB1"].ToString(); b.G_NAME2 = dt.Rows[i]["G_NAME2"].ToString(); b.G_ID2 = dt.Rows[i]["G_ID2"].ToString(); b.G_JOB2 = dt.Rows[i]["G_JOB2"].ToString(); b.G_NAME3 = dt.Rows[i]["G_NAME3"].ToString(); b.G_ID3 = dt.Rows[i]["G_ID3"].ToString(); b.G_JOB3 = dt.Rows[i]["G_JOB3"].ToString(); b.G_NAME4 = dt.Rows[i]["G_NAME4"].ToString(); b.G_ID4 = dt.Rows[i]["G_ID4"].ToString(); b.G_JOB4 = dt.Rows[i]["G_JOB4"].ToString(); b.B_AMOUNT = dt.Rows[i]["B_AMOUNT"].ToString(); b.B_REPAYMENT = dt.Rows[i]["B_REPAYMENT"].ToString(); //b.B_REPAYMENT = new T_REPAY_HIS_SQL(connstring).GetRepayAmount(b.B_SYSID); b.B_INTEREST = dt.Rows[i]["B_INTEREST"].ToString(); b.B_TYPE = dt.Rows[i]["B_TYPE"].ToString(); b.B_REPAYDATE = dt.Rows[i]["B_REPAYDATE"].ToString(); b.B_REMINDDATE = dt.Rows[i]["B_REMINDDATE"].ToString(); b.B_DATE = dt.Rows[i]["B_DATE"].ToString(); b.B_DATETMP = dt.Rows[i]["B_DATETMP"].ToString(); b.B_ISDEL = dt.Rows[i]["B_ISDEL"].ToString(); b.B_TERM = dt.Rows[i]["B_TERM"].ToString(); List <USER> lu = new T_USER_SQL(connstring).Get_User(dt.Rows[i]["U_SYSID"].ToString()); if (lu.Count > 0) { b.USER = lu[0]; } else { b.USER = new USER(); } b.C_EMERGENCYNAME = dt.Rows[i]["C_EMERGENCYNAME"].ToString(); b.B_REPAYTYPE = dt.Rows[i]["B_REPAYTYPE"].ToString(); list.Add(b); } } return(list); }
private void btenOk_Click(object sender, EventArgs e) { try { if (MessageBox.Show("确定保存?", "保存提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { string err = CheckDate(); if (string.IsNullOrEmpty(err)) { BORROW borrow = FaceToData(); b = borrow; if (string.IsNullOrEmpty(b_sysid)) { string res; int i = 0; frmWaitingBox f = new frmWaitingBox((obj, args) => { Thread.Sleep(threadTime); i = borrow_sql.Insert(borrow); }, waitTime, "Plase Wait...", false, false); f.ShowDialog(this); res = f.Message; if (!string.IsNullOrEmpty(res)) { MessageBox.Show(res); } else { if (i == 1) { MessageBox.Show("保存成功!", "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Information); btnOk.Enabled = false; btnPrint.Enabled = true; } else { MessageBox.Show("保存失败!", "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else { string res; int i = 0; frmWaitingBox f = new frmWaitingBox((obj, args) => { i = borrow_sql.Update(borrow); }, waitTime, "Plase Wait...", false, false); f.ShowDialog(this); res = f.Message; if (!string.IsNullOrEmpty(res)) { MessageBox.Show(res); } if (i == 1) { MessageBox.Show("保存成功!", "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("保存失败!", "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else { MessageBox.Show(err, "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } catch (Exception e1) { MessageBox.Show(e1.Message, "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }