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