/// <summary>
/// 查询数据
/// </summary>
/// <param name="regCode"></param>
/// <param name="cardNumber"></param>
/// <param name="cardName"></param>
/// <param name="cardCode"></param>
/// <param name="isUsed"></param>
private void SearchData(string regCode, string cardNumber, string cardName, string cardCode, int isUsed)
{
//封装数据
Service.Regulatory data = new Regulatory.Service.Regulatory();
data.RegCode = regCode;
data.CardNumber = cardNumber;
data.CardName = cardName;
data.CardCode = cardCode;
data.IsUsed = isUsed;
data.PageIndex = pageIndex;
data.PageSize = pageSize;
//
data.AccID = accID;
//查询数据
int total;
DataTable dt = service.GetRegulatoryList(connectionString, data, out total);
dgvRegulatory.DataSource = dt;
lblPageC.Text = pageIndex.ToString();
if (total == 0)
{
total = 1;
}
lblPageT.Text = total % pageSize == 0?(total / pageSize).ToString():(total / pageSize + 1).ToString();
btnControl();
}
/// <summary>
/// 批量导入监管码
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnInsertReg_Click(object sender, EventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "excel files|*.xls";
DialogResult dr = openFileDialog.ShowDialog();
if (dr == DialogResult.OK)
{
//获取execl表的数据
DataSet ds = ExcelToDataSet(openFileDialog.FileName);
if (ds == null)
{
return;
}
Service.Regulatory data;
string errMsg = string.Empty;
//存储错误信息
string info = string.Empty;
//循环监管添加
foreach (DataRow row in ds.Tables[0].Rows)
{
data = new Regulatory.Service.Regulatory();
if (row[0].ToString().Length != 32)
{
continue;
}
data.RegCode = row[0].ToString();
data.AccID = accID;
//判断是否存在
bool flag = service.ExistsRegulatory(connectionString, data);
if (flag)//说明已存在 跳过
{
info += string.Format("监管码：{0}已存在！\r\n", row[0].ToString());
continue;
}
//添加监管码
flag = service.AddRegulatory(connectionString, data, out errMsg);
if (!flag)
{
info += string.Format("监管码：{0}添加失败！\r\n", row[0].ToString());
break;
}
}
if (!string.IsNullOrEmpty(info))
{
MessageBox.Show("添加完成，详细信息如下：\r\n" + info);
}
btnSearch_Click(null, null);
}
}
