public static DataTable B(string f, decimal SN, string k, SetPos s)
{
string Message = "";
var dt = new DataTable();
dt.Columns.Add("身份证号", System.Type.GetType("System.String"));
dt.Columns.Add("报名序号", System.Type.GetType("System.String"));
dt.Columns.Add("教育年份", System.Type.GetType("System.String"));
dt.Columns.Add("手机", System.Type.GetType("System.String"));
dt.Columns.Add("状态");
string SQL = "select * from [sheet1$]";
var dataSet = E.ExcuteDataset(f, SQL);
DataTable dt2 = dataSet.Tables[0];
int Max = dt2.Rows.Count;
for (int i = 0; i < dt2.Rows.Count; i++)
{
try
{
var dr = dt2.Rows[i];
Message = string.Format("正在处理：{0}",dr["报名序号"].ToString());
s(i, Max, false, Message, dt);
if (dr["身份证号"] != DBNull.Value && dr["报名序号"] != DBNull.Value)
{
var m = new SR.M1();
m.IDCard = dr["身份证号"].ToString();
m.IDSN = dr["报名序号"].ToString();
m.Year = Convert.ToInt32(dr["教育年份"].ToString());
m.sType = string.Empty;
m.Phone = dr["手机"].ToString();
m.Name = string.Empty;
m.SN = SN;
m.Type = 1;
var r1 = I.S(m, k);
var row = dt.NewRow();
row["身份证号"] = dr["身份证号"].ToString().Trim();
row["报名序号"] = dr["报名序号"].ToString().Trim();
row["教育年份"] = dr["教育年份"].ToString().Trim();
row["手机"] = dr["手机"].ToString().Trim();
row["状态"] = U.N2S(r1.Code);
dt.Rows.Add(row);
if (r1.Code != 0)
{
log.Info("{0},{1}", r1.Code, r1.Message);
}
}
Thread.Sleep(300);
}
catch (Exception ex1)
{
log.Info("{0},{1}", ex1.Message, ex1.StackTrace);
}
}
Message = "完成";
s(Max, Max, true, Message, dt);
return dt;
}
public static R A(string f,decimal SN,string k)
{
var r = new R();
string SQL = "select * from [sheet1$]";
var dr = E.ExcuteReader(f, SQL);
while (dr.Read())
{
try
{
if (dr["身份证号"] != DBNull.Value && dr["报名序号"] != DBNull.Value)
{
var m = new SR.M1();
m.IDCard = dr["身份证号"].ToString();
m.IDSN = dr["报名序号"].ToString();
m.Year = Convert.ToInt32(dr["教育年份"].ToString());
m.sType = string.Empty;
m.Phone = string.Empty;
m.Name = string.Empty;
m.SN = SN;
m.Type = 1;
var r1 = I.S(m, k);
log.Info("{0},{1}", r1.Code, r1.Message);
}
}
catch (Exception ex1)
{
log.Info("{0},{1}", ex1.Message, ex1.StackTrace);
}
}
dr.Close();
dr.Dispose();
return r;
}