private void btnSetQT_Click(object sender, EventArgs e)
{
if (!DetectionFiltration())
{
return;
}
string pws = textBox1.Text.Replace(" ", "");
if (pws.Length != 8)
{
MessageBox.Show("The length of the password must be 8!");
return;
}
byte[] uAccessPwd = DataConvert.HexStringToByteArray(pws);
//----------------------------
string filerData = txtFilter_EPC.Text.Replace(" ", "");
int filerBank = 1;
byte[] filerBuff = DataConvert.HexStringToByteArray(filerData);
int filerPtr = int.Parse(txtPtr.Text);
int filerLen = int.Parse(txtLen.Text);
if ((filerLen / 8 + (filerLen % 8 == 0 ? 0 : 1)) * 2 > filerData.Length)
{
MessageBox.Show("filter data length error!"); //to do
return;
}
if (rbTID.Checked)
{
filerBank = 2;
}
if (rbUser.Checked)
{
filerBank = 3;
}
//--------------------------------------
int time = 500;
int QTData = Convert.ToByte("000000" + comboBox2.SelectedIndex + comboBox1.SelectedIndex);
string msg = "";
//QT
if (UHFAPI.getInstance().SetQT(uAccessPwd, (byte)filerBank, filerPtr, filerLen, filerBuff, (byte)QTData))
{
time = 100;
msg = " success";
}
else
{
msg = " failure";
}
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
System.Threading.Thread.Sleep(time);
}, msg);
f.ShowDialog(this);
}
public void bindData()
{
dataGridEdit.DataSource = null;
string res;
DataTable dt = new DataTable();
int count = 0;
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
Thread.Sleep(threadTime);
count = Convert.ToInt32(edit_sql.GetTotal(" "));
dt = edit_sql.QueryByWhere(" ", pagerControl1.PageIndex - 1, pagerControl1.PageSize);
}, waitTime, "Plase Wait...", false, false);
f.ShowDialog(this);
res = f.Message;
if (!string.IsNullOrEmpty(res))
{
MessageBox.Show(res);
}
else
{
if (dt.Rows.Count == 0)
{
MessageBox.Show("无数据", "查询结果", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
pagerControl1.DrawControl(count);
dataGridEdit.DataSource = dt;
dataGridEdit.Columns[0].HeaderText = "序号";
}
}
}
public void bindData()
{
dataGridMessage.DataSource = null;
string where = string.Format(" AND A.U_SYSID='{0}'", logonUser.U_SYSID);
if (dateS.Checked == true)
{
where += string.Format(" AND S_SENDDATE >= '{0}' ", dateS.Text);
}
if (dateE.Checked == true)
{
where += string.Format(" AND S_SENDDATE <= '{0}' ", dateE.Text);
}
if (ddlType.Text == "发送成功")
{
where += " AND S_FLAG ='交易请求成功' ";
}
else if (ddlType.Text == "发送失败")
{
where += " AND S_FLAG <>'交易请求成功' ";
}
if (!string.IsNullOrEmpty(edtSTelephone.Text.Trim()))
{
where += " AND S_TELEPHONE LIKE '%" + edtSTelephone.Text.Trim() + "%' ";
}
int count = 0;
string res;
DataTable dt = new DataTable();
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
Thread.Sleep(threadTime);
count = Convert.ToInt32(sendmessage_sql.GetTotal(where));
dt = sendmessage_sql.QueryByWhere(where, pagerControl1.PageIndex - 1, pagerControl1.PageSize);
}, waitTime, "Plase Wait...", false, false);
f.ShowDialog(this);
res = f.Message;
if (!string.IsNullOrEmpty(res))
{
MessageBox.Show(res);
}
else
{
if (dt.Rows.Count == 0)
{
MessageBox.Show("无数据", "查询结果", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
pagerControl1.DrawControl(count);
dataGridMessage.DataSource = dt;
dataGridMessage.Columns[0].HeaderText = "序号";
dataGridMessage.Columns[0].Width = 80;
}
}
}
public void bindData()
{
dataGridCustomer.DataSource = null;
string where = string.Format(" AND U_SYSID='{0}'", logonUser.U_SYSID);
if (dateS.Checked == true)
{
where += string.Format(" AND B_DATE >= '{0}' ", dateS.Text);
}
if (dateE.Checked == true)
{
where += string.Format(" AND B_DATE <= '{0}' ", dateE.Text);
}
if (!string.IsNullOrEmpty(edtCID.Text.Trim()))
{
where += " AND C_ID LIKE '%" + edtCID.Text.Trim() + "%' ";
}
int count = 0;
string res;
DataTable dt = new DataTable();
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
Thread.Sleep(threadTime);
count = Convert.ToInt32(borrow_sql.GetTotalCustomer(where));
dt = borrow_sql.CustomerQueryByWhere(where, pagerControl1.PageIndex - 1, pagerControl1.PageSize);
}, waitTime, "Plase Wait...", false, false);
f.ShowDialog(this);
res = f.Message;
if (!string.IsNullOrEmpty(res))
{
MessageBox.Show(res);
}
else
{
if (dt.Rows.Count == 0)
{
MessageBox.Show("无数据", "查询结果", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
pagerControl1.DrawControl(count);
dataGridCustomer.DataSource = dt;
dataGridCustomer.Columns[0].HeaderText = "序号";
dataGridCustomer.Columns[0].Width = 80;
dataGridCustomer.Columns[1].Width = 100;
dataGridCustomer.Columns[2].Width = 150;
dataGridCustomer.Columns[3].Width = 100;
dataGridCustomer.Columns[4].Width = 150;
dataGridCustomer.Columns[5].Width = 150;
dataGridCustomer.Columns[6].Width = 200;
dataGridCustomer.Columns[7].Width = 80;
}
}
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("确定修改？", "修改提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
string err = string.Empty;
if (string.IsNullOrEmpty(edtUid.Text.Trim()))
{
err += "请输入账号！\r\n";
}
if (string.IsNullOrEmpty(edtUmail.Text.Trim()))
{
err += "请输入邮箱！\r\n";
}
if (string.IsNullOrEmpty(err))
{
FaceToDate();
string res;
int i = 0;
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
Thread.Sleep(threadTime);
i = user_sql.Update(logonUser);
}, 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);
}
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);
}
}
private void showMessage(string msg)
{
if (msg.ToLower().Contains("fail"))
{
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
System.Threading.Thread.Sleep(500);
}, msg);
f.ShowDialog(this);
}
}
private void btn_Submit_Click(object sender, EventArgs e)
{
try {
if (edtID.Text.Trim() != "" && edtPassword.Text.Trim() != "")
{
string res;
bool b = false;
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
Thread.Sleep(threadTime);
b = user_sql.logon(edtID.Text, edtPassword.Text, out logonUser);
}, waitTime, "Plase Wait...", false, false);
f.ShowDialog(this);
res = f.Message;
if (!string.IsNullOrEmpty(res))
{
MessageBox.Show(res);
}
else
{
if (b)
{
MessageBox.Show("登陆成功", "登陆通知", MessageBoxButtons.OK, MessageBoxIcon.Information);
Configuration config = System.Configuration.ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
if (cbSaveName.Checked == true)
{
config.AppSettings.Settings["saveUsername"].Value = edtID.Text.Trim();
config.AppSettings.Settings["saveCheck"].Value = "true";
config.Save();
}
else
{
config.AppSettings.Settings["saveUsername"].Value = "";
config.AppSettings.Settings["saveCheck"].Value = "false";
config.Save();
}
DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("密码或者账号错误", "登陆通知", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("请输入账号和密码！", "登陆通知", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception e1) {
MessageBox.Show(e1.Message, "错误报告", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void toolStripMenuItem1_Click(object sender, EventArgs e)
{
if (isOpen)
{
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
string Temperature = UHFAPI.getInstance().GetTemperature();
string temp = (Common.isEnglish?"Temperature:":"Temperature:") + Temperature + "℃";
frmWaitingBox.message = temp;
System.Threading.Thread.Sleep(1500);
});
f.ShowDialog(this);
}
}
public void bindData()
{
try
{
dataGridDeductions.DataSource = null;
string where = string.Format(" AND A.U_SYSID = '{0}' ", logonUser.U_SYSID);
if (dateS.Checked == true)
{
where += string.Format(" AND SUBSTRING(D_DATE,1,10) >= '{0}' ", dateS.Text);
}
if (dateE.Checked == true)
{
where += string.Format(" AND SUBSTRING(D_DATE,1,10) <= '{0}' ", dateE.Text);
}
string res;
DataTable dt = new DataTable();
int count = 0;
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
Thread.Sleep(threadTime);
count = Convert.ToInt32(debit_his_sql.GetTotal(where));
dt = debit_his_sql.QueryByWhere(where, pagerControl1.PageIndex - 1, pagerControl1.PageSize);
}, waitTime, "Plase Wait...", false, false);
f.ShowDialog(this);
res = f.Message;
if (!string.IsNullOrEmpty(res))
{
MessageBox.Show(res);
}
else
{
if (dt.Rows.Count == 0)
{
MessageBox.Show("无数据", "查询结果", MessageBoxButtons.OK, MessageBoxIcon.Information);
dataGridDeductions.DataSource = null;
}
else
{
pagerControl1.DrawControl(count);
dataGridDeductions.DataSource = dt;
dataGridDeductions.Columns[0].HeaderText = "序号";
}
}
}
catch (Exception e1)
{
MessageBox.Show(e1.Message, "报错", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, EventArgs e)
{
frmWaitingBox fw = new frmWaitingBox();
fw.StartWait();
for (long i = 0; i < 1000000000; i++)
{
sum += i;
//i++;
}
this.tbsum.Text = sum.ToString();
fw.EndWait();
}
private void button1_Click(object sender, EventArgs e)
{
string res;
DataTable dtable = null;
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
Thread.Sleep(5000);
string sql = "SELECT * FROM [test].[dbo].[studentInfo]";
dtable = SqlHelper.ExecuteDataTable(sql);
}, 10, "Plase Wait...", false, false);
f.ShowDialog(this);
res = f.Message;
//dataGridView1.DataSource = dt;
if (!string.IsNullOrEmpty(res))
{
MessageBox.Show(res);
}
//progressBar1.Maximum = 100000;
//progressBar1.Step = 1;
//for (int j = 0; j < 100000; j++)
//{
// Caluculate(j);
// progressBar1.PerformStep();
//}
//timer1.Start();
//progressBar1.Maximum = 100;
//if (progressBar1.Value == 100)
//{
// timer1.Stop();
// MessageBox.Show("over");
// progressBar1.Value = 0;
//}
//progressBar1.Maximum = 100;
//progressBar1.Step = 1;
//progressBar1.Value = 0;
//backgroundWorker.RunWorkerAsync();
//if (!backgroundWorker.IsBusy)
//{
// _inputPra.process = 100;
// _inputPra.delay = 1200;
// backgroundWorker.RunWorkerAsync(_inputPra);
//}
}
private void dataGridEdit_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
string res;
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
Thread.Sleep(threadTime);
string sysid = dataGridEdit.Rows[e.RowIndex].Cells[1].Value.ToString();
string url = ConfigurationManager.AppSettings.Get("infourl");
System.Diagnostics.Process.Start(url + "?sysid=" + sysid);
}, waitTime, "Plase Wait...", false, false);
f.ShowDialog(this);
res = f.Message;
if (!string.IsNullOrEmpty(res))
{
MessageBox.Show(res);
}
}
private void btnFilterEPC_Click(object sender, EventArgs e)
{
string epc = "";
string msg = "failure";
if (UHFAPI.getInstance().InventorySingle(ref epc))
{
txtFilter_EPC.Text = epc;
Common.tag = epc;
msg = "success";
}
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
System.Threading.Thread.Sleep(500);
}, msg);
f.ShowDialog(this);
}
private void btnPrint_Click(object sender, EventArgs e)
{
//Print_form f = new Print_form(FaceToData());
//f.Show();
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string res;
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
Thread.Sleep(threadTime);
print(saveFileDialog1.FileName);
}, waitTime, "Plase Wait...", false, false);
f.ShowDialog(this);
res = f.Message;
if (!string.IsNullOrEmpty(res))
{
MessageBox.Show(res);
}
}
//print();
}
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; //以毫米为单位
}
private void uHFVersionToolStripMenuItem_Click(object sender, EventArgs e)
{
if (isOpen)
{
StringBuilder sb = new StringBuilder();
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
string hardwareV = UHFAPI.getInstance().GetHardwareVersion();
string softWareV = UHFAPI.getInstance().GetSoftwareVersion();
int id = UHFAPI.getInstance().GetUHFGetDeviceID();
sb.Append("Hardware version: ");
sb.Append(hardwareV);
sb.Append("\r\nFirmware version: ");
sb.Append(softWareV);
sb.Append("\r\nDevice ID: ");
sb.Append(id);
});
f.ShowDialog(this);
MessageBoxEx.Show(this, sb.ToString());
}
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
//if (toolStripOpen.Text == strOpen1 || toolStripOpen.Text == strOpen2)
if (toolStripOpen.Text == strOpen1)
{
//----------------------------
int com = 0;
string ip = "";
uint portData = 0;
int type = combCommunicationMode.SelectedIndex;//0
if (type == 0)
{
com = int.Parse(cmbComPort.SelectedItem.ToString().Replace("COM", ""));
}
else if (type == 1)
{
if (txtPort.Text == "")
{
MessageBox.Show("fail!");
return;
}
char[] port = txtPort.Text.ToCharArray();
for (int k = 0; k < port.Length; k++)
{
if (port[k] != '0' && port[k] != '1' && port[k] != '2' && port[k] != '3' && port[k] != '4' &&
port[k] != '5' && port[k] != '6' && port[k] != '7' && port[k] != '8' && port[k] != '9')
{
MessageBox.Show("fail!");
return;
}
}
portData = uint.Parse(txtPort.Text);
ip = cmbComPort.Text;
}
else
{
MessageBox.Show("fail!");
return;
}
//---------------------------
string msg = Common.isEnglish ? "connecting..." : "connecting...";
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
bool result = false;// UHFOpen();
if (type == 0)
{
result = UHFAPI.getInstance().Open(com);
}
else
{
result = UHFAPI.getInstance().TcpConnect(ip, portData);
}
if (result)
{
this.Invoke(new EventHandler(delegate
{
combCommunicationMode.Enabled = false;
cmbComPort.Enabled = false;
//if (toolStripOpen.Text == strOpen1)
toolStripOpen.Text = strClose1;
/*else
* toolStripOpen.Text = strClose2;*/
isOpen = true;
if (eventOpen != null)
{
eventOpen(true);
}
MenuItemScanEPC.Enabled = true;
MenuItemReadWriteTag.Enabled = true;
configToolStripMenuItem.Enabled = true;
uHFVersionToolStripMenuItem.Enabled = true;
killLockToolStripMenuItem.Enabled = true;
// MenuItemReceiveEPC.Enabled = true;
toolStripMenuItem1.Enabled = true;
}));
}
else
{
//MessageBox.Show("f");
frmWaitingBox.message = "fail";
Thread.Sleep(1000);
}
}, msg);
f.ShowDialog(this);
}
else
{
if (UHFClose())
{
combCommunicationMode.Enabled = true;
cmbComPort.Enabled = true;
//if (toolStripOpen.Text == strClose1)
toolStripOpen.Text = strOpen1;
/*else
* toolStripOpen.Text = strOpen2;*/
isOpen = false;
if (eventOpen != null)
{
eventOpen(false);
}
MenuItemScanEPC.Enabled = false;
MenuItemReadWriteTag.Enabled = false;
configToolStripMenuItem.Enabled = false;
uHFVersionToolStripMenuItem.Enabled = false;
killLockToolStripMenuItem.Enabled = false;
toolStripMenuItem1.Enabled = false;
// MenuItemReceiveEPC.Enabled = false;
}
}
}
public void bindData()
{
dataGridBorrow.DataSource = null;
string where = string.Empty;
if (dateS.Checked == true)
{
where += string.Format(" AND B_DATE >= '{0}' ", dateS.Text);
}
if (dateE.Checked == true)
{
where += string.Format(" AND B_DATE <= '{0}' ", dateE.Text);
}
if (!string.IsNullOrEmpty(edtCName.Text.Trim()))
{
where += " AND C_ID LIKE '%" + edtCName.Text.Trim() + "%' ";
}
if (!string.IsNullOrEmpty(edtGName.Text.Trim()))
{
where += " AND ( G_ID1 LIKE '%" + edtGName.Text.Trim() + "%'OR G_ID2 LIKE '%" + edtGName.Text.Trim() + "%' OR G_ID3 LIKE '%" + edtGName.Text.Trim() + "%' OR G_ID4 LIKE '%" + edtGName.Text.Trim() + "%' )";
}
int count = 0;
string res;
DataTable dt = new DataTable();
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
Thread.Sleep(threadTime);
count = Convert.ToInt32(borrow_sql.GetTotal(where));
dt = borrow_sql.QueryByWhere_CB(where, pagerControl1.PageIndex - 1, pagerControl1.PageSize);
}, waitTime, "Plase Wait...", false, false);
f.ShowDialog(this);
res = f.Message;
if (!string.IsNullOrEmpty(res))
{
MessageBox.Show(res);
}
else
{
if (dt.Rows.Count == 0)
{
MessageBox.Show("无数据", "查询结果", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
pagerControl1.DrawControl(count);
dataGridBorrow.DataSource = dt;
dataGridBorrow.Columns[0].HeaderText = "序号";
dataGridBorrow.Columns[0].Width = 80;
dataGridBorrow.Columns[1].Width = 100;
dataGridBorrow.Columns[2].Width = 80;
dataGridBorrow.Columns[3].Width = 100;
dataGridBorrow.Columns[4].Width = 100;
dataGridBorrow.Columns[5].Width = 150;
dataGridBorrow.Columns[6].Width = 100;
dataGridBorrow.Columns[7].Width = 80;
dataGridBorrow.Columns[8].Width = 100;
dataGridBorrow.Columns[9].Width = 150;
dataGridBorrow.Columns[10].Width = 100;
dataGridBorrow.Columns[11].Width = 100;
dataGridBorrow.Columns[12].Width = 150;
dataGridBorrow.Columns[13].Width = 100;
dataGridBorrow.Columns[14].Width = 100;
dataGridBorrow.Columns[15].Width = 150;
dataGridBorrow.Columns[16].Width = 100;
dataGridBorrow.Columns[17].Width = 100;
dataGridBorrow.Columns[18].Width = 150;
dataGridBorrow.Columns[19].Width = 100;
dataGridBorrow.Columns[20].Width = 100;
dataGridBorrow.Columns[21].Width = 150;
dataGridBorrow.Columns[22].Width = 80;
dataGridBorrow.Columns[23].Width = 100;
dataGridBorrow.Columns[24].Width = 100;
dataGridBorrow.Columns[25].Width = 100;
dataGridBorrow.Columns[26].Width = 100;
dataGridBorrow.Columns[27].Width = 150;
}
}
}
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);
}
}
private void button5_Click(object sender, EventArgs e)
{
if (!DetectionFiltration())
{
return;
}
string filerData = txtFilter_EPC.Text.Replace(" ", "");
string accessPwd = txtLockPwd.Text.Replace(" ", "");
int FilterStartaddr = int.Parse(txtPtr.Text);
int FilterLength = int.Parse(txtLen.Text);
if (accessPwd.Length != 8)
{
MessageBoxEx.Show(this, "The length of the password must be 8!");
return;
}
if ((FilterLength / 8 + (FilterLength % 8 == 0 ? 0 : 1)) * 2 > filerData.Length)
{
MessageBox.Show("filter data length error!"); //to do
return;
}
byte[] pwd = DataConvert.HexStringToByteArray(accessPwd);
byte[] filerBuff = DataConvert.HexStringToByteArray(filerData);
int FilterBank = 1;
if (rbTID.Checked)
{
FilterBank = 2;
}
else if (rbUser.Checked)
{
FilterBank = 3;
}
byte[] lockbuf = new byte[3];
int[] ilockCode = new int[20];
if (cbKill.Checked)
{
if (rbTemporaryOpen.Checked || rbTemporaryLock.Checked)
{
ilockCode[19] = 1;
ilockCode[9] = rbTemporaryOpen.Checked ? 0 : 1;
}
else if (rbPermanentOpen.Checked || rbPermanentLock.Checked)
{
ilockCode[18] = 1;
ilockCode[8] = 1;
ilockCode[19] = 1;
ilockCode[9] = rbPermanentOpen.Checked ? 0 : 1;
}
}
if (cbAccess.Checked)
{
if (rbTemporaryOpen.Checked || rbTemporaryLock.Checked)
{
ilockCode[17] = 1;
ilockCode[7] = rbTemporaryOpen.Checked ? 0 : 1;
}
else if (rbPermanentOpen.Checked || rbPermanentLock.Checked)
{
ilockCode[16] = 1;
ilockCode[6] = 1;
ilockCode[17] = 1;
ilockCode[7] = rbPermanentOpen.Checked ? 0 : 1;
}
}
if (cbEPC.Checked)
{
if (rbTemporaryOpen.Checked || rbTemporaryLock.Checked)
{
ilockCode[15] = 1;
ilockCode[5] = rbTemporaryOpen.Checked ? 0 : 1;
}
else if (rbPermanentOpen.Checked || rbPermanentLock.Checked)
{
ilockCode[14] = 1;
ilockCode[4] = 1;
ilockCode[15] = 1;
ilockCode[5] = rbPermanentOpen.Checked ? 0 : 1;
}
}
if (cbTID.Checked)
{
if (rbTemporaryOpen.Checked || rbTemporaryLock.Checked)
{
ilockCode[13] = 1;
ilockCode[3] = rbTemporaryOpen.Checked ? 0 : 1;
}
else if (rbPermanentOpen.Checked || rbPermanentLock.Checked)
{
ilockCode[12] = 1;
ilockCode[12] = 1;
ilockCode[13] = 1;
ilockCode[3] = rbPermanentOpen.Checked ? 0 : 1;
}
}
if (cbUser.Checked)
{
if (rbTemporaryOpen.Checked || rbTemporaryLock.Checked)
{
ilockCode[11] = 1;
ilockCode[1] = rbTemporaryOpen.Checked ? 0 : 1;
}
else if (rbPermanentOpen.Checked || rbPermanentLock.Checked)
{
ilockCode[0] = 1;
ilockCode[10] = 1;
ilockCode[11] = 1;
ilockCode[1] = rbPermanentOpen.Checked ? 0 : 1;
}
}
StringBuilder sb = new StringBuilder();
sb.Append("0000");
for (int k = ilockCode.Length - 1; k >= 0; k--)
{
sb.Append(ilockCode[k]);
}
lockbuf[0] = Convert.ToByte(sb.ToString().Substring(0, 8), 2);
lockbuf[1] = Convert.ToByte(sb.ToString().Substring(8, 8), 2);
lockbuf[2] = Convert.ToByte(sb.ToString().Substring(16, 8), 2);
label7.Text = "LockData:" + DataConvert.ByteArrayToHexString(lockbuf);
string msg = "";
if (UHFAPI.getInstance().LockTag(pwd, (byte)FilterBank, FilterStartaddr, FilterLength, filerBuff, lockbuf))
{
msg = "success";
}
else
{
msg = "failure";
}
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
System.Threading.Thread.Sleep(500);
}, msg);
f.ShowDialog(this);
}
private void button4_Click(object sender, EventArgs e)
{
if (!DetectionFiltration())
{
return;
}
string filerData = txtFilter_EPC.Text.Replace(" ", "");
string accessPwd = txtGBPWD.Text.Replace(" ", "");
byte[] pwd = DataConvert.HexStringToByteArray(accessPwd);
byte[] filerBuff = DataConvert.HexStringToByteArray(filerData);
int FilterStartaddr = int.Parse(txtPtr.Text);
int FilterLength = int.Parse(txtLen.Text);
int FilterBank = 1;
if (rbTID.Checked)
{
FilterBank = 2;
}
else if (rbUser.Checked)
{
FilterBank = 3;
}
if (accessPwd.Length != 8)
{
MessageBoxEx.Show(this, "The length of the password must be 8!");
return;
}
if (comboBank.SelectedIndex < 0 || comboConfig.SelectedIndex < 0 || comboAction.SelectedIndex < 0)
{
MessageBoxEx.Show(this, "failure!");
return;
}
byte memory = 0;
if (comboBank.SelectedIndex == 0)
{
memory = 0;
}
else if (comboBank.SelectedIndex == 1)
{
memory = 0x10;
}
else if (comboBank.SelectedIndex == 2)
{
memory = 0x20;
}
else if (comboBank.SelectedIndex == 3)
{
memory = (byte)(0x30 + userNumber);
}
byte config = (byte)comboConfig.SelectedIndex;
byte action = (byte)comboAction.SelectedIndex;
string msg = "";
if (UHFAPI.getInstance().GBTagLock(pwd, (byte)FilterBank, FilterStartaddr, FilterLength, filerBuff, memory, config, action))
{
msg = "success";
}
else
{
msg = "failure";
}
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
System.Threading.Thread.Sleep(500);
}, msg);
f.ShowDialog(this);
}
private void btnQTWrite_Click(object sender, EventArgs e)
{
if (!DetectionFiltration())
{
return;
}
string pws = txtQT_pwd.Text.Replace(" ", "");
if (pws.Length != 8)
{
MessageBox.Show("The length of the password must be 8!");
return;
}
int bank = cmbQT_bank.SelectedIndex;
int startIndex = int.Parse(txtQT_ptr.Text);
int leng = int.Parse(QT_Length.Text);
byte[] uAccessPwd = DataConvert.HexStringToByteArray(pws);
//-----------------------------
string filerData = txtFilter_EPC.Text.Replace(" ", "");
int filerBank = 1;
byte[] filerBuff = DataConvert.HexStringToByteArray(filerData);
int filerPtr = int.Parse(txtPtr.Text);
int filerLen = int.Parse(txtLen.Text);
if ((filerLen / 8 + (filerLen % 8 == 0 ? 0 : 1)) * 2 > filerData.Length)
{
MessageBox.Show("filter data length error!"); //to do
return;
}
if (rbTID.Checked)
{
filerBank = 2;
}
if (rbUser.Checked)
{
filerBank = 3;
}
//--------------------------------------
int QTData = Convert.ToByte("000000" + cmbQT2.SelectedIndex + cmbQT1.SelectedIndex);
string msg = "";
//
string qtData = txtQT_data.Text.Replace(" ", "");
if (!StringUtils.IsHexNumber(qtData))
{
MessageBox.Show("Please input hexadecimal data!");
return;
}
if (qtData.Length % 4 != 0)
{
MessageBox.Show("Write data of the length of the string must be in multiples of four!");
return;
}
if (leng > (qtData.Length / 2))
{
MessageBox.Show("Write data length error! ");
return;
}
byte[] uDatabuf = DataConvert.HexStringToByteArray(qtData);
bool result = UHFAPI.getInstance().WriteQT(uAccessPwd, (byte)filerBank, filerPtr, filerLen, filerBuff,
(byte)QTData, (byte)bank, startIndex, (byte)leng, uDatabuf);
if (result)
{
msg = "Write success";
}
else
{
msg = "Write failure";
}
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
System.Threading.Thread.Sleep(500);
}, msg);
f.ShowDialog(this);
}
private void btnQTRead_Click(object sender, EventArgs e)
{
if (!DetectionFiltration())
{
return;
}
string pws = txtQT_pwd.Text.Replace(" ", "");
if (pws.Length != 8)
{
MessageBox.Show("The length of the password must be 8!");
return;
}
int bank = cmbQT_bank.SelectedIndex;
int startIndex = int.Parse(txtQT_ptr.Text);
int leng = int.Parse(QT_Length.Text);
byte[] uAccessPwd = DataConvert.HexStringToByteArray(pws);
//----------------------------
string filerData = txtFilter_EPC.Text.Replace(" ", "");
int filerBank = 1;
byte[] filerBuff = DataConvert.HexStringToByteArray(filerData);
int filerPtr = int.Parse(txtPtr.Text);
int filerLen = int.Parse(txtLen.Text);
if ((filerLen / 8 + (filerLen % 8 == 0 ? 0 : 1)) * 2 > filerData.Length)
{
MessageBox.Show("filter data length error!"); //to do
return;
}
if (rbTID.Checked)
{
filerBank = 2;
}
if (rbUser.Checked)
{
filerBank = 3;
}
//--------------------------------------
int QTData = Convert.ToByte("000000" + cmbQT2.SelectedIndex + cmbQT1.SelectedIndex);
string msg = "";
txtQT_data.Text = "";
//
string data = UHFAPI.getInstance().ReadQT(uAccessPwd, (byte)filerBank, filerPtr, filerLen, filerBuff,
(byte)QTData, (byte)bank, startIndex, (byte)leng);
if (data != string.Empty)
{
txtQT_data.Text = data;
msg = " success";
}
else
{
msg = " failure";
}
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
System.Threading.Thread.Sleep(500);
}, msg);
f.ShowDialog(this);
}
private void btnConnect_Click(object sender, EventArgs e)
{
//if (btnConnect.Text == strOpen1 || btnConnect.Text == strOpen2)
if (btnConnect.Text == strOpen1)
{
//----------------------------
if (txtPort.Text == "")
{
MessageBox.Show("fail!");
return;
}
char[] port = txtPort.Text.ToCharArray();
for (int k = 0; k < port.Length; k++)
{
if (port[k] != '0' && port[k] != '1' && port[k] != '2' && port[k] != '3' && port[k] != '4' &&
port[k] != '5' && port[k] != '6' && port[k] != '7' && port[k] != '8' && port[k] != '9')
{
MessageBox.Show("only numbers are allowed!");
return;
}
}
uint portData = uint.Parse(txtPort.Text);
string[] tempIp = ipControl1.IpData;
StringBuilder sb = new StringBuilder();
sb.Append(tempIp[0]);
sb.Append(".");
sb.Append(tempIp[1]);
sb.Append(".");
sb.Append(tempIp[2]);
sb.Append(".");
sb.Append(tempIp[3]);
string ip = sb.ToString();
//---------------------------
string msg = Common.isEnglish ? "connecting..." : "connecting...";
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
bool result = false;
result = UHFAPI.getInstance().TcpConnect(ip, portData);
if (result)
{
this.Invoke(new EventHandler(delegate
{
combCommunicationMode.Enabled = false;
txtPort.Enabled = false;
ipControl1.Enabled = false;
//if (btnConnect.Text == strOpen1)
btnConnect.Text = strClose1;
/*else
* btnConnect.Text = strClose2;*/
isOpen = true;
if (eventOpen != null)
{
eventOpen(true);
}
UHFAPP.IPConfig.IPEntity entity = new IPConfig.IPEntity();
entity.Port = (int)portData;
entity.Ip = ipControl1.IpData;
IPConfig.setIPConfig(entity);
MenuItemScanEPC.Enabled = true;
MenuItemReadWriteTag.Enabled = true;
configToolStripMenuItem.Enabled = true;
uHFVersionToolStripMenuItem.Enabled = true;
killLockToolStripMenuItem.Enabled = true;
toolStripMenuItem1.Enabled = true;
// MenuItemReceiveEPC.Enabled = true;
}));
}
else
{
//MessageBox.Show("f");
frmWaitingBox.message = "fail";
Thread.Sleep(1000);
}
}, msg);
f.ShowDialog(this);
}
else
{
UHFAPI.getInstance().TcpDisconnect();
combCommunicationMode.Enabled = true;
txtPort.Enabled = true;
ipControl1.Enabled = true;
//if (btnConnect.Text == strClose1)
btnConnect.Text = strOpen1;
/*else
* btnConnect.Text = strOpen2;*/
isOpen = false;
if (eventOpen != null)
{
eventOpen(false);
}
MenuItemScanEPC.Enabled = false;
MenuItemReadWriteTag.Enabled = false;
configToolStripMenuItem.Enabled = false;
uHFVersionToolStripMenuItem.Enabled = false;
killLockToolStripMenuItem.Enabled = false;
toolStripMenuItem1.Enabled = false;
//MenuItemReceiveEPC.Enabled = false;
}
}
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);
}
}
private void button3_Click(object sender, EventArgs e)
{
if (!DetectionFiltration())
{
return;
}
string filerData = txtFilter_EPC.Text.Replace(" ", "");
string accessPwd = txtBlockPermalockPwd.Text.Replace(" ", "");
if (accessPwd.Length != 8)
{
MessageBoxEx.Show(this, "The length of the password must be 8!");
return;
}
int bank = cmbBlockPermalockBank.SelectedIndex;
byte[] pwd = DataConvert.HexStringToByteArray(accessPwd);
byte[] filerBuff = DataConvert.HexStringToByteArray(filerData);
int Ptr = int.Parse(txtBlockPermalockPtr.Text);
int FilterStartaddr = int.Parse(txtPtr.Text);
int FilterLength = int.Parse(txtLen.Text);
int FilterBank = 1;
if (rbTID.Checked)
{
FilterBank = 2;
}
else if (rbUser.Checked)
{
FilterBank = 3;
}
int ReadLock = cmbBlockPermalockReadLock.SelectedIndex;
int uRange = Ptr + 1;
int[] data = new int[16];
if (cbBlock1.Checked)
{
data[0] = 1;
}
if (cbBlock2.Checked)
{
data[1] = 1;
}
if (cbBlock3.Checked)
{
data[2] = 1;
}
if (cbBlock4.Checked)
{
data[3] = 1;
}
if (cbBlock5.Checked)
{
data[4] = 1;
}
if (cbBlock6.Checked)
{
data[5] = 1;
}
if (cbBlock7.Checked)
{
data[6] = 1;
}
if (cbBlock8.Checked)
{
data[7] = 1;
}
if (cbBlock9.Checked)
{
data[8] = 1;
}
if (cbBlock10.Checked)
{
data[9] = 1;
}
if (cbBlock11.Checked)
{
data[10] = 1;
}
if (cbBlock12.Checked)
{
data[11] = 1;
}
if (cbBlock13.Checked)
{
data[12] = 1;
}
if (cbBlock14.Checked)
{
data[13] = 1;
}
if (cbBlock15.Checked)
{
data[14] = 1;
}
if (cbBlock16.Checked)
{
data[15] = 1;
}
StringBuilder sb = new StringBuilder();
for (int k = 0; k < data.Length; k++)
{
sb.Append(data[k]);
}
byte[] uMaskbuf = new byte[2];
uMaskbuf[0] = Convert.ToByte(sb.ToString().Substring(0, 8), 2);
uMaskbuf[1] = Convert.ToByte(sb.ToString().Substring(8, 8), 2);
label8.Text = "Maskbuf:" + DataConvert.ByteArrayToHexString(uMaskbuf);
string msg = "";
if (UHFAPI.getInstance().BlockPermalock(pwd, (byte)FilterBank, FilterStartaddr,
FilterLength, filerBuff, (byte)ReadLock, (byte)bank, Ptr, (byte)uRange, uMaskbuf))
{
msg = "success";
if (ReadLock == 0)
{
label8.Text = "Maskbuf:" + DataConvert.ByteArrayToHexString(uMaskbuf);
string str1 = System.Convert.ToString(uMaskbuf[0], 2);
str1 = "0000000".Substring(0, 8 - str1.Length) + str1;
string str2 = System.Convert.ToString(uMaskbuf[1], 2);
str2 = "0000000".Substring(0, 8 - str2.Length) + str2;
cbBlock1.Checked = (str1.Substring(0, 1) == "1" ? true : false);
cbBlock2.Checked = (str1.Substring(1, 1) == "1" ? true : false);
cbBlock3.Checked = (str1.Substring(2, 1) == "1" ? true : false);
cbBlock4.Checked = (str1.Substring(3, 1) == "1" ? true : false);
cbBlock5.Checked = (str1.Substring(4, 1) == "1" ? true : false);
cbBlock6.Checked = (str1.Substring(5, 1) == "1" ? true : false);
cbBlock7.Checked = (str1.Substring(6, 1) == "1" ? true : false);
cbBlock8.Checked = (str1.Substring(7, 1) == "1" ? true : false);
cbBlock9.Checked = (str2.Substring(0, 1) == "1" ? true : false);
cbBlock10.Checked = (str2.Substring(1, 1) == "1" ? true : false);
cbBlock11.Checked = (str2.Substring(2, 1) == "1" ? true : false);
cbBlock12.Checked = (str2.Substring(3, 1) == "1" ? true : false);
cbBlock13.Checked = (str2.Substring(4, 1) == "1" ? true : false);
cbBlock14.Checked = (str2.Substring(5, 1) == "1" ? true : false);
cbBlock15.Checked = (str2.Substring(6, 1) == "1" ? true : false);
cbBlock16.Checked = (str2.Substring(7, 1) == "1" ? true : false);
}
}
else
{
msg = "failure";
}
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
System.Threading.Thread.Sleep(500);
}, msg);
f.ShowDialog(this);
}
private void ddlBSysid_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(ddlBSysid.Text))
{
string b_sysid = ddlBSysid.Text.Split('-')[0];
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), false);
}, waitTime, "Plase Wait...", false, false);
f.ShowDialog(this);
res = f.Message;
if (!string.IsNullOrEmpty(res))
{
MessageBox.Show(res);
}
else
{
if (borrow.Count > 0)
{
lblCName.Text = borrow[0].C_NAME;
lblCID.Text = borrow[0].C_ID;
lblBAMOUNT.Text = borrow[0].B_AMOUNT;
lblBLimit.Text = (Convert.ToDecimal(borrow[0].B_AMOUNT) - Convert.ToDecimal(borrow[0].B_REPAYMENT)).ToString();
bindData(b_sysid);
Decimal ramount = Convert.ToDecimal(borrow[0].B_AMOUNT) / Convert.ToDecimal(borrow[0].B_TERM);
Decimal rint = Convert.ToDecimal(borrow[0].B_AMOUNT) * Convert.ToDecimal(borrow[0].B_INTEREST) / 100 / 12;
if (borrow[0].B_REPAYTYPE == "等额本息")
{
lblRemind.Text = string.Format(@"款息提醒：本次应还本金{0}元，利息{1}元。合计{2}元。",
ramount.ToString("#0.00"),
rint.ToString("#0.00"),
(ramount + rint).ToString("#0.00"));
}
else
{
if ((Convert.ToInt64(DateTime.Now.ToString("yyyyMMdd").Substring(0, 6)) - Convert.ToInt64(borrow[0].B_DATE.Replace("-", "").Substring(0, 6))).ToString() == borrow[0].B_TERM)
{
lblRemind.Text = string.Format(@"款息提醒：本次应还本金{0}元，利息{1}元。合计{2}元。",
borrow[0].B_AMOUNT,
rint.ToString("#0.00"),
(Convert.ToDecimal(borrow[0].B_AMOUNT) + rint).ToString("#0.00"));
}
else
{
lblRemind.Text = string.Format(@"款息提醒：本次应还本金0元，利息{0}元。合计{0}元。",
rint.ToString("#0.00"));
}
}
}
}
}
}
catch (Exception e1) {
MessageBox.Show(e1.Message, "数据获取", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
string err = string.Empty;
if (edtUid.Text.Trim() == "")
{
err += "请输入账号！\r\n";
edtUid.BackColor = System.Drawing.Color.Red;
}
if (edtUmail.Text.Trim() == "")
{
err += "请输入邮箱！\r\n";
edtUmail.BackColor = System.Drawing.Color.Red;
}
if (edtUTelephone.Text.Trim() == "")
{
err += "请输入手机号！\r\n";
edtUTelephone.BackColor = System.Drawing.Color.Red;
}
if (edtUname.Text.Trim() == "")
{
err += "请输入公司名称！\r\n";
edtUname.BackColor = System.Drawing.Color.Red;
}
if (edtPassword.Text.Trim() == "")
{
err += "请输密码！\r\n";
edtPassword.BackColor = System.Drawing.Color.Red;
}
if (edtPsddeord_R.Text.Trim() == "")
{
err += "请输入确认密码！\r\n";
edtPsddeord_R.BackColor = System.Drawing.Color.Red;
}
if (edtPassword.Text.Trim() != "" && edtPsddeord_R.Text.Trim() != "" && edtPassword.Text.Trim() != edtPsddeord_R.Text.Trim())
{
err += "2次密码不一致！\r\n";
edtPsddeord_R.BackColor = System.Drawing.Color.Red;
}
if (string.IsNullOrEmpty(err))
{
if (user_sql.CheckUser(edtUid.Text.Trim(), "id"))
{
err += "该账号已注册！\r\n";
edtUid.BackColor = System.Drawing.Color.Red;
}
if (user_sql.CheckUser(edtUmail.Text.Trim(), "mail"))
{
err += "该邮件已注册！\r\n";
edtUmail.BackColor = System.Drawing.Color.Red;
}
if (user_sql.CheckUser(edtUTelephone.Text.Trim(), "telephone"))
{
err += "该手机已注册！\r\n";
edtUTelephone.BackColor = System.Drawing.Color.Red;
}
if (string.IsNullOrEmpty(err))
{
try
{
DbHelp.CS.USER user = new DbHelp.CS.USER();
user.U_ID = edtUid.Text.Trim();
user.U_MAIL = edtUmail.Text.Trim();
user.U_NAME = edtUname.Text.Trim();
user.U_TELEPHONE = edtUTelephone.Text.Trim();
user.U_PASSWORD = edtPassword.Text.Trim();
user.U_PROVINCE = ddlProvince.Text;
user.U_CITY = ddlCity.Text;
user.U_AREA = ddlArea.Text;
string res;
int b = 0;
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
Thread.Sleep(threadTime);
b = user_sql.Insert(user);
}, waitTime, "Plase Wait...", false, false);
f.ShowDialog(this);
res = f.Message;
if (!string.IsNullOrEmpty(res))
{
MessageBox.Show(res);
}
else
{
if (b == 1)
{
MessageBox.Show("注册成功!", "注册通知", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show("注册失败，请再试一下!", "注册通知", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception e1)
{
MessageBox.Show(e1.Message, "错误报告", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(err, "错误报告", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(err, "错误报告", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnImport_Click(object sender, EventArgs e)
{
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
try
{
edtPath.Text = openFileDialog.FileName;
dataGridBorrow.DataSource = null;
DataTable myds = new DataTable();
string strCon;
OleDbConnection olecon = new OleDbConnection();
OleDbDataAdapter myda = new OleDbDataAdapter();
try
{
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}; Extended Properties=Excel 8.0;";
strCon = string.Format(strCon, openFileDialog.FileName);
olecon = new OleDbConnection(strCon);
myda = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strCon);
myda.Fill(myds);
}
catch (Exception e1) {
olecon.Dispose();
strCon = "Provider=Microsoft.Ace.OleDb.12.0;Data Source={0}; Extended Properties='Excel 12.0; HDR=Yes; IMEX=1';";
strCon = string.Format(strCon, openFileDialog.FileName);
olecon = new OleDbConnection(strCon);
myda = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strCon);
myda.Fill(myds);
}
olecon.Close();
dataGridBorrow.DataSource = myds;
string res;
string result = "";
frmWaitingBox f = new frmWaitingBox((obj, args) =>
{
Thread.Sleep(threadTime);
result = Import(myds);
}, 3600, "正在导入", true, false);
f.ShowDialog(this);
res = f.Message;
if (!string.IsNullOrEmpty(res))
{
MessageBox.Show(res);
}
else
{
MessageBox.Show(result, "导入信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//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_EMERGENCY = myds.Rows[i][3].ToString();
// b.C_ADDRESS = myds.Rows[i][4].ToString();
// b.C_SEX = myds.Rows[i][5].ToString();
// b.G_NAME1 = myds.Rows[i][6].ToString();
// b.G_ID1 = myds.Rows[i][7].ToString();
// b.G_JOB1 = myds.Rows[i][8].ToString();
// b.G_NAME2 = myds.Rows[i][9].ToString();
// b.G_ID2 = myds.Rows[i][10].ToString();
// b.G_JOB2 = myds.Rows[i][11].ToString();
// b.G_NAME3 = myds.Rows[i][12].ToString();
// b.G_ID3 = myds.Rows[i][13].ToString();
// b.G_JOB3 = myds.Rows[i][14].ToString();
// b.G_NAME4 = myds.Rows[i][15].ToString();
// b.G_ID4 = myds.Rows[i][16].ToString();
// b.G_JOB4 = myds.Rows[i][17].ToString();
// b.B_AMOUNT = myds.Rows[i][18].ToString();
// b.B_REPAYMENT = myds.Rows[i][19].ToString();
// b.B_INTEREST = myds.Rows[i][20].ToString();
// b.B_TERM= myds.Rows[i][21].ToString();
// b.B_TYPE = myds.Rows[i][22].ToString();
// b.B_REPAYDATE = myds.Rows[i][23].ToString();
// b.B_REMINDDATE = myds.Rows[i][24].ToString();
// b.B_DATE = DateTime.Parse(myds.Rows[i][25].ToString()).ToString("yyyy-MM-dd");
// b.B_DATETMP = DateTime.Parse(myds.Rows[i][26].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){
// MessageBox.Show(b.C_NAME+" 借款资料导入失败，请修改导入资料，重新导入后续资料", "导入", MessageBoxButtons.OK, MessageBoxIcon.Error);
// }
// progressBar.Value = (i + 1) * 100 / myds.Rows.Count;
// Application.DoEvents();
//}
//MessageBox.Show("资料导入成！", "导入", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception e1)
{
MessageBox.Show(e1.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
