银行卡号校验
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
using Office = Microsoft.Office.Core;
using Microsoft.Office.Tools.Excel;
using System.Diagnostics;
using System.Threading;
namespace zizhuTools
{
public partial class bank_card : Form //银行卡号校验
{
Excel.Application Bc_fm;
Excel.Range rng_add;
Excel.Range rng_tqsv;
Stopwatch sw = new Stopwatch();
public bank_card()
{
InitializeComponent();
}
private void bank_card_Load(object sender, EventArgs e)
{
// MessageBox.Show("这是新版本");
Bc_fm = Globals.ThisAddIn.Application;
rng_add = Bc_fm.Selection;//初始选择位置
bc_jy_tb.Text = rng_add.get_Address();
}
private void bc_jy_tb_Click(object sender, EventArgs e)
{
this.WindowState = FormWindowState.Minimized;
//MessageBox.Show("已经设置最小化");
rng_add = Bc_fm.InputBox("选择单元格", "在Excel中选取", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, 8);
bc_jy_tb.Text = rng_add.get_Address();
//this.TopMost = true;
//this.TopMost = false;
this.WindowState = FormWindowState.Normal;
}
private void bc_btn_Click(object sender, EventArgs e)
{
this.WindowState = FormWindowState.Minimized;
//MessageBox.Show("已经设置最小化");
rng_add = Bc_fm.InputBox("选择单元格", "在Excel中选取", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, 8);
bc_jy_tb.Text = rng_add.get_Address();
this.WindowState = FormWindowState.Normal;
}
//校验银行卡号
private void c_ent_btn_Click(object sender, EventArgs e)
{
this.Text = "验证银行卡号(程序运行中)";
this.WindowState = FormWindowState.Minimized;
int wsfm =int.Parse(hfws_fm.Text);
int wsend = int.Parse(hfws_end.Text);
rng_tqsv = Bc_fm.InputBox("选择【同排】单元格", "在Excel中选取", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, 8);
this.WindowState = FormWindowState.Normal;
// rng_tqsv = rng_tqsv.Resize[1, 1];
sw.Start();
//遍历数据
System.Text.RegularExpressions.Regex rg = new System.Text.RegularExpressions.Regex("^\\d{" + wsfm + "," + wsend + "}");
if (c_gs_chk.Checked)//使用公式
{
int rg_row, rg_col;
rg_row = rng_tqsv.Cells[1].row;
rg_col = rng_tqsv.Cells[1].Column;
//遍历数据
int rg_i = rg_row;
foreach (Excel.Range rn2 in rng_add)
{
Bc_fm.Cells[rg_i, rg_col].Value = string.Format("=IF(OR(LEN({0})<{1},LEN({0})>{2}), \"位数不对\", IF(MOD(10-RIGHT(MID({0},1,1)+MID({0},3,1)+MID({0},5,1)+MID({0},7,1)+MID({0},9,1)+MID({0},11,1)+MID({0},13,1)+MID({0},15,1)+MID({0},17,1)+IF(MID({0},2,1)>=\"5\",(MID({0},2,1)-5)*2+1,MID({0},2,1)*2)+IF(MID({0},4,1)>=\"5\",(MID({0},4,1)-5)*2+1,MID({0},4,1)*2)+IF(MID({0},6,1)>=\"5\",(MID({0},6,1)-5)*2+1,MID({0},6,1)*2)+IF(MID({0},8,1)>=\"5\",(MID({0},8,1)-5)*2+1,MID({0},8,1)*2)+IF(MID({0},10,1)>=\"5\",(MID({0},10,1)-5)*2+1,MID({0},10,1)*2)+IF(MID({0},12,1)>=\"5\",(MID({0},12,1)-5)*2+1,MID({0},12,1)*2)+IF(MID({0},14,1)>=\"5\",(MID({0},14,1)-5)*2+1,MID({0},14,1)*2)+IF(MID({0},16,1)>=\"5\",(MID({0},16,1)-5)*2+1,MID({0},16,1)*2)+IF(MID({0},18,1)>=\"5\",(MID({0},18,1)-5)*2+1,MID({0},18,1)*2),1),10)=INT(RIGHT({0},1)),\"账号正确\",\"账号错误\"))", rn2.get_Address(), wsfm, wsend);
rg_i += 1;
}
}
else
{
object[,] arr = rng_add.Value;
for (int i = 1; i <= arr.GetLength(0); i++)
{
if (arr[i, 1] == null)
{
arr[i, 1] = "错误";
continue;
}
string cardNumber = arr[i, 1].ToString().Replace("'","");
try
{
System.Text.RegularExpressions.Match mc = rg.Match(cardNumber);
if (mc.Success)
{
int oddSum = 0;
int evenSum = 0;
List<char> list = cardNumber.ToCharArray().Reverse().ToList();
for (int j = 1; j < list.Count + 1; j++)
{
if (!char.IsDigit(list[j - 1]))
{
arr[i, 1] = "错误";
continue;
}
int item = (int)char.GetNumericValue(list[j - 1]);
if (j % 2 == 0)
{
int num = item * 2;
evenSum += num > 9 ? num.ToString().ToCharArray().Sum<char>(ch =>
{
return (int)char.GetNumericValue(ch);
}) : num;
}
else
{
oddSum += item;
}
}
arr[i, 1] = (oddSum + evenSum) % 10 == 0 ? "正确" : "错误";
}
else
{
arr[i, 1] = "错误";
}
}
catch (Exception ex)
{
MessageBox.Show("异常字段：【" + cardNumber + "】,原因:" + ex.Message,"程序运行异常");
}
}
rng_tqsv.Resize[arr.GetLength(0), 1].Value = arr;
}
sw.Stop();
MessageBox.Show("程序运行完毕：" + sw.Elapsed,"提示");
this.Text = "验证银行卡号";
this.TopMost = true;
this.TopMost = false;
}
private void c_exit_btn_Click(object sender, EventArgs e)
{
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
string fileName = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "Image\\原图\\银行卡校验.png";
System.Diagnostics.Process.Start(fileName);
}
private void button2_Click(object sender, EventArgs e)
{
System.Diagnostics.Process.Start("http://www.xxzizhu.com/index.php?ac=article&at=read&did=4882");
}
}
}
