//性别
public Ctxt Ifsex(object str)
{
Ctxt ctxt = new Ctxt();
if (str == null || string.IsNullOrEmpty(str.ToString()))
{
ctxt.txt = "1";
ctxt.count = 1;
}
else
{
if (str.ToString().Trim() == "男")
{
ctxt.txt = "1";
}
else if (str.ToString().Trim() == "女")
{
ctxt.txt = "2";
}
else
{
ctxt.txt = str.ToString().Trim();
}
ctxt.count = 0;
}
return(ctxt);
}
/// <summary>
/// Process a delete request.
/// </summary>
/// <param name="toDelete">Delete reqeuest</param>
public async Task DeleteAsync(Delete toDelete)
{
var totalTimer = ScopeTiming.StartTiming();
try
{
int tableId = await Tables.GetIdAsync(Ctxt, toDelete.table, noCreate : true, noException : true).ConfigureAwait(false);
if (tableId < 0)
{
return;
}
foreach (var val in toDelete.values)
{
long valueId = await Values.GetIdAsync(Ctxt, val).ConfigureAwait(false);
string sql = $"DELETE FROM items WHERE valueid = {valueId} AND tableid = {tableId}";
Ctxt.AddPostOp(sql);
}
await Ctxt.ProcessPostOpsAsync().ConfigureAwait(false);
}
finally
{
ScopeTiming.RecordScope("Cmd.Delete", totalTimer);
}
}
// newProgs returns a new Progs for fn.
// worker indicates which of the backend workers will use the Progs.
private static ref Progs newProgs(ref Node fn, long worker)
{
ptr <Progs> pp = @new <Progs>();
if (Ctxt.CanReuseProgs())
{
var sz = len(sharedProgArray) / nBackendWorkers;
pp.progcache = sharedProgArray[sz * worker..sz * (worker + 1L)];
static public void Parse(string comment, string culture, PresetTag preset)
{
Ctxt ctxt = new Ctxt {
preset = preset, culture = culture
};
CommentParser.Parse(comment, ctxt.Handler);
}
/// <summary>
/// Query for the metadata for a set of items.
/// </summary>
/// <param name="request">NoSQL query for items to get</param>
/// <returns>Metadata of found items</returns>
public async Task <GetResponse> QueryGetAsync(QueryGetRequest request)
{
var totalTimer = ScopeTiming.StartTiming();
try
{
var itemValues = new Dictionary <long, object>();
{
Select select = new Select();
select.select = new List <string> {
"id", "value"
};
select.from = request.from;
select.where = request.where;
select.orderBy = request.orderBy;
select.limit = request.limit;
select.cmdParams = request.cmdParams;
using (var reader = await Ctxt.ExecSelectAsync(select).ConfigureAwait(false))
{
while (await reader.ReadAsync().ConfigureAwait(false))
{
itemValues.Add(reader.GetInt64(0), reader.GetValue(1));
}
}
}
var responses = new List <Dictionary <string, object> >(itemValues.Count);
foreach (var itemId in itemValues.Keys)
{
var metaIds = await Items.GetItemDataAsync(Ctxt, itemId).ConfigureAwait(false);
var metaStrings = await NameValues.GetMetadataValuesAsync(Ctxt, metaIds).ConfigureAwait(false);
metaStrings["id"] = (double)itemId;
metaStrings["value"] = itemValues[itemId];
responses.Add(metaStrings);
}
GetResponse response = new GetResponse()
{
metadata = responses
};
return(response);
}
finally
{
ScopeTiming.RecordScope("Cmd.QueryGet", totalTimer);
}
}
//投保类型
public Ctxt Iftbtype(object str)
{
Ctxt ctxt = new Ctxt();
if (str == null || string.IsNullOrEmpty(str.ToString()))
{
ctxt.txt = "1";
ctxt.count = 1;
}
else
{
ctxt.txt = str.ToString().Trim();
ctxt.count = 0;
}
return(ctxt);
}
//日期处理
public Ctxt IfdateY4md(object str)
{
DateTime result;
Ctxt ctxt = new Ctxt();
if (str == null || string.IsNullOrEmpty(str.ToString()))
{
ctxt.txt = str.ToString();
ctxt.count = 1;
}
else
{
if (str.ToString().Length != 8)
{
ctxt.txt = str.ToString();
ctxt.count = 1;
}
else if (!DateTime.TryParse(str.ToString().Substring(0, 4) + "-" + str.ToString().Substring(4, 2) + "-" + str.ToString().Substring(6, 2) + " 00:00:00", out result))
{
ctxt.txt = str.ToString();
ctxt.count = 1;
}
if (str.ToString().Length == 8 && tools.IsNum(str.ToString()))
{
ctxt.txt = str.ToString();
ctxt.count = 0;
}
else
{
//if (tools.IsDate(str.ToString()))
//{
// DateTime dt = Convert.ToDateTime(str.ToString());
// ctxt.txt = string.Format("{0:yyyyMMdd}", dt);
// ctxt.count = 0;
//}
//else
//{
ctxt.txt = str.ToString();
ctxt.count = 1;
//}
}
}
return(ctxt);
}
//根据关卡分类
public static Ptxt Classify_pass(string text)
{
Ptxt temp;
string [] ClueArray;
ClueArray = SplitWithString(text, "***"); //根据线索分割字符串，此处选择空行区分每一线索
temp.ctxt = new List <Ctxt>();
for (int i = 0; i < ClueArray.Length - 1; i++)
{
Ctxt tempctxt = Classify_clue(ClueArray [i]);
temp.ctxt.Add(tempctxt);
}
temp.cnum = ClueArray.Length - 2;
return(temp);
}
//身份证判断
public Ctxt Ifid(object str)
{
Ctxt ctxt = new Ctxt();
if (str == null || string.IsNullOrEmpty(str.ToString()))
{
ctxt.txt = "";
ctxt.count = 0;
}
else
{
if (CheckIDCard(str.ToString().Trim()))
{
ctxt.txt = str.ToString().Trim();
ctxt.count = 0;
}
else
{
ctxt.txt = str.ToString().Trim();
ctxt.count = 1;
}
}
return(ctxt);
}
//投保人电话号码
public Ctxt Iftelphone(object str)
{
Ctxt ctxt = new Ctxt();
if (str == null || string.IsNullOrEmpty(str.ToString()))
{
ctxt.txt = "";
ctxt.count = 1;
}
else
{
if (IsValidPhoneAndMobile(str.ToString()))
{
ctxt.txt = str.ToString().Trim();
ctxt.count = 0;
}
else
{
ctxt.txt = str.ToString().Trim();
ctxt.count = 1;
}
}
return(ctxt);
}
protected void Page_Load(object sender, EventArgs e)
{
// tools.setIP("学平险校验");
var v_operno = "";
if (string.IsNullOrEmpty(Request["opid"]))
{
if (Session["operTime"] == null)
{
Response.Write("<Script language=JavaScript>alert('请从学平险数据校验系统欢迎页登录');window.location.href='http://10.187.23.2:8081/newland/tuanxian/compare_list.aspx';</Script>");
Response.End();
}
else
{
v_operno = Session["operTime"].ToString().Trim();
}
}
else
{
Session["operTime"] = Request["opid"].Trim();
v_operno = Request["opid"].Trim();
}
var sqlstr = "select * from chq_tx_xpxfan order by fan";
Fandt = DbHelperInfor76.DbHelperInfor.ExecuteDataTable(sqlstr);
if (Request.IsPostBack())
{
mainKg = true; //总控制
#region 导入
if (Request["isok"] == "开始")
{
HttpPostedFile f = this.Request.Files[0];
string fname = f.FileName;
/* startIndex */
int index = fname.LastIndexOf(".") + 1;
/* length */
int len = fname.Length - index;
fname = DateTime.Now.ToFileTime().ToString() + "." + fname.Substring(index, len);
fname = this.Server.MapPath("/newland/tuanxian/fileup/" + fname);
/* save to server */
//Response.Write(this.Server.MapPath("/cqtb/kp/2015mzkp/file/" + fname));
f.SaveAs(fname);
var v_oldname = ExcelHelper.GetSheetNames(fname);
if (v_oldname.IndexOf("Sheet1") < 0)
{
//删除文件
FuncDelfuile(fname);
Response.Write("<script language='javascript'> alert('Excel文件标签1名称不为Sheet1，请核实，或重新下载标准模板！');history.back() </script>");
Response.End();
}
DataTable dt = new DataTable();
dt = ExcelHelper.InputFromExcel(fname, "Sheet1");
var v_agex = 0;
var v_agey = 99;
var v_fan = Request["sele_fan"].Trim();
if (v_fan != "0")
{
sqlstr = "select agex,agey from chq_tx_xpxfan where fan='" + v_fan + "'";
var agedt = DbHelperInfor76.DbHelperInfor.ExecuteDataTable(sqlstr);
if (agedt != null)
{
v_agex = Convert.ToInt32(agedt.Rows[0]["agex"].ToString());
v_agey = Convert.ToInt32(agedt.Rows[0]["agey"].ToString());
}
}
//Response.Write(DateTime.ParseExact("20150306","yyyyMMdd",null));
xpx xpxM = new xpx();
Ctxt ctxt = new Ctxt();
Mydt = new DataTable();
Mydt.Columns.Add("apname", typeof(string));
Mydt.Columns.Add("pname", typeof(string));
Mydt.Columns.Add("pid", typeof(string));
Mydt.Columns.Add("school", typeof(string));
Mydt.Columns.Add("bclass", typeof(string));
Mydt.Columns.Add("bthdate", typeof(string));
Mydt.Columns.Add("payseq", typeof(string));
Mydt.Columns.Add("begdate", typeof(string));
Mydt.Columns.Add("enddate", typeof(string));
Mydt.Columns.Add("prelname", typeof(string));
Mydt.Columns.Add("sex", typeof(string));
Mydt.Columns.Add("tbtype", typeof(string));
Mydt.Columns.Add("telno", typeof(string));
Mydt.Columns.Add("apid", typeof(string));
Mydt.Columns.Add("bz", typeof(string));
int x0 = 0;
int x1 = 0;
int x2 = 0;
int x3 = 0;
int x4 = 0;
int x5 = 0;
int x6 = 0;
int x7 = 0;
int x8 = 0;
int x9 = 0;
int x10 = 0;
int x11 = 0;
int x12 = 0;
int x13 = 0;
int xfan = 0;
int xid = 0;
int xadd = 0;
int xaddd = 0;
int xadddd = 0;
for (int i = 1; i < dt.Rows.Count; i++)
{
xpxM.bz = "";
//投保人
ctxt = Ifempty(dt.Rows[i][0]);
if (ctxt.txt.ToString().Trim().Replace(" ", "").IndexOf("家长") >= 0)
{
xpxM.bz += "投保人姓名出错<br>";
x0++;
}
xpxM.apname = ctxt.txt;
x0 += ctxt.count;
xpxM.bz += ctxt.count > 0 ? "投保人为空<br>" : "";
//被保人
ctxt = Ifempty(dt.Rows[i][1]);
xpxM.pname = ctxt.txt;
x1 += ctxt.count;
xpxM.bz += ctxt.count > 0 ? "被保人为空<br>" : "";
//被保人身份证
ctxt = Ifid(dt.Rows[i][2]);
//if (string.IsNullOrEmpty(ctxt.txt) || ctxt.txt == "")
//{
// x2 ++;
// xpxM.bz += "被保人身份证为空<br>";
//}
xpxM.pid = ctxt.txt;
x2 += ctxt.count;
xpxM.bz += ctxt.count > 0 ? "被保人身份证有误<br>" : "";
if (dt.Rows[i][2] != null && dt.Rows[i][1] != null)
{
N2n n2n = new N2n();
n2n = Ifname2name(dt.Rows[i][2], dt.Rows[i][1]);
if (n2n.isok)
{
xpxM.bz += "被保人姓名:" + n2n.sysname + "与导入不符<br>";
x2 += 1;
}
}
//学校
ctxt = Ifempty(dt.Rows[i][3]);
xpxM.school = ctxt.txt;
x3 += ctxt.count;
xpxM.bz += ctxt.count > 0 ? "学校为空<br>" : "";
//班级
ctxt = Ifempty(dt.Rows[i][4]);
xpxM.bclass = ctxt.txt;
x4 += ctxt.count;
//被保人生日
ctxt = IfdateY4md(dt.Rows[i][5]);
xpxM.bthdate = ctxt.txt;
x5 += ctxt.count;
xpxM.bz += ctxt.count > 0 ? "被保人生日有误<br>" : "";
if (!IfFan(dt.Rows[i][5], dt.Rows[i][7], v_agex, v_agey))
{
xpxM.bz += "被保人年龄不在投保范围<br>";
xfan++;
}
if (!AgeDaYu18(dt.Rows[i][13].ToString().Trim().Substring(6, 8), dt.Rows[i][7]))
{
xpxM.bz += "投保人年龄小于18岁<br>";
xadd++;
}
if ((dt.Rows[i][0].ToString().Trim() == dt.Rows[i][1].ToString().Trim()) && (dt.Rows[i][2].ToString().Trim() != dt.Rows[i][13].ToString().Trim()))
{
xpxM.bz += "投保或被保人姓名输入重复<br>";
xaddd++;
}
if ((dt.Rows[i][0].ToString().Trim() != dt.Rows[i][1].ToString().Trim()) && (dt.Rows[i][2].ToString().Trim() == dt.Rows[i][13].ToString().Trim()))
{
xpxM.bz += "投保或被保人身份证输入重复<br>";
xadddd++;
}
if (dt.Rows[i][2].ToString() != "" || !string.IsNullOrEmpty(dt.Rows[i][2].ToString()))
{
if (dt.Rows[i][2].ToString().Trim().Substring(6, 8) != dt.Rows[i][5].ToString().Trim())
{
xpxM.bz += "被保人出生日期与身份证不同<br>";
xid++;
}
}
//受益人
ctxt = Ifempty(dt.Rows[i][6]);
xpxM.payseq = ctxt.txt;
x6 += ctxt.count;
//保险起期
ctxt = IfdateY4md(dt.Rows[i][7]);
xpxM.begdate = ctxt.txt;
x7 += ctxt.count;
xpxM.bz += ctxt.count > 0 ? "保险起期为空<br>" : "";
//保险止期
ctxt = IfdateY4md(dt.Rows[i][8]);
xpxM.enddate = ctxt.txt;
x8 += ctxt.count;
//投保人与被保人关系
ctxt = Ifempty(dt.Rows[i][9]);
xpxM.prelname = ctxt.txt;
x9 += ctxt.count;
//性别
ctxt = Ifempty(dt.Rows[i][10]);
xpxM.sex = ctxt.txt;
x10 += ctxt.count;
//投保类型
ctxt = Iftbtype(dt.Rows[i][11]);
xpxM.tbtype = ctxt.txt;
x11 += ctxt.count;
//投保人电话号码
ctxt = Iftelphone(dt.Rows[i][12]);
xpxM.telno = ctxt.txt;
x12 += ctxt.count;
xpxM.bz += ctxt.count > 0 ? "投保人电话号码有误<br>" : "";
//投保人身份证号码
ctxt = Ifid(dt.Rows[i][13]);
xpxM.apid = ctxt.txt;
x13 += ctxt.count;
xpxM.bz += ctxt.count > 0 ? "投保人身份证号码有误<br>" : "";
if (dt.Rows[i][13] != null && dt.Rows[i][0] != null)
{
N2n n2n = new N2n();
n2n = Ifname2name(dt.Rows[i][13], dt.Rows[i][0]);
if (n2n.isok)
{
xpxM.bz += "投保人姓名:" + n2n.sysname + "与导入不符<br>";
x13 += 1;
}
}
DataRow row = Mydt.NewRow();
row["apname"] = xpxM.apname;
row["pname"] = xpxM.pname;
row["pid"] = xpxM.pid;
row["school"] = xpxM.school;
row["bclass"] = xpxM.bclass;
row["bthdate"] = xpxM.bthdate;
row["payseq"] = xpxM.payseq;
row["begdate"] = xpxM.begdate;
row["enddate"] = xpxM.enddate;
row["prelname"] = xpxM.prelname;
row["sex"] = xpxM.sex;
row["tbtype"] = xpxM.tbtype;
row["telno"] = xpxM.telno;
row["apid"] = xpxM.apid;
row["bz"] = xpxM.bz;
Mydt.Rows.Add(row);
}
//删除文件
FuncDelfuile(fname);
if (x0 > 0)
{
mainKg = false;
message += "投保人信息有误 ｜ ";
}
if (x1 > 0)
{
mainKg = false;
message += "被保人有空 ｜ ";
}
if (x2 > 0)
{
mainKg = false;
message += "被保人身份证号有误 ｜ ";
}
if (x3 > 0)
{
mainKg = false;
message += "学校有空 ｜ ";
}
if (x5 > 0)
{
mainKg = false;
message += "被保人生日有误或为空 ｜ ";
}
if (x7 > 0)
{
mainKg = false;
message += "保险起期为空 ｜ ";
}
if (x12 > 0)
{
mainKg = false;
message += "投保人电话有误或为空 ｜ ";
}
if (x13 > 0)
{
mainKg = false;
message += "被保人身份证号有误 ｜ ";
}
if (xfan > 0)
{
mainKg = false;
message += "被保人年龄不在投保范围 ｜ ";
}
if (xadd > 0)
{
mainKg = false;
message += "投保人年龄小于18岁 ｜ ";
}
if (xaddd > 0)
{
mainKg = false;
message += "投保或被保人姓名输入重复 ｜ ";
}
if (xadddd > 0)
{
mainKg = false;
message += "投保或被保人身份证输入重复 ｜ ";
}
if (xid > 0)
{
mainKg = false;
message += "被保人出生日期与身份证不同 ｜ ";
}
if (mainKg)
{
message += "通过";
}
//if (message != "通过")
//{
// ExcelHelper.ExportExcelDT(Mydt, "参考错误提示模板");
//}
}
#endregion
}
}
/// <summary>
/// This is the main UPSERT method to populate the database.
/// </summary>
/// <param name="define">Info about metadata to apply to the key</param>
public async Task DefineAsync(Define define)
{
var totalTimer = ScopeTiming.StartTiming();
try
{
var localTimer = ScopeTiming.StartTiming();
bool isKeyNumeric = !(define.key is string);
int tableId = await Tables.GetIdAsync(Ctxt, define.table, isKeyNumeric).ConfigureAwait(false);
long valueId = await Values.GetIdAsync(Ctxt, define.key).ConfigureAwait(false);
long itemId = await Items.GetIdAsync(Ctxt, tableId, valueId).ConfigureAwait(false);
ScopeTiming.RecordScope("Define.Setup", localTimer);
if (define.metadata != null)
{
// name => nameid
var nameValueIds = new Dictionary <int, long>();
foreach (var kvp in define.metadata)
{
bool isMetadataNumeric = !(kvp.Value is string);
int nameId = await Names.GetIdAsync(Ctxt, tableId, kvp.Key, isMetadataNumeric).ConfigureAwait(false);
if (kvp.Value == null) // erase value
{
nameValueIds[nameId] = -1;
continue;
}
bool isNameNumeric = await Names.GetNameIsNumericAsync(Ctxt, nameId).ConfigureAwait(false);
bool isValueNumeric = !(kvp.Value is string);
if (isValueNumeric != isNameNumeric)
{
throw
new MetaStringsException
(
$"Data numeric does not match name: {kvp.Key}" +
$"\n - value is numeric: {isValueNumeric} - {kvp.Value}" +
$"\n - name is numeric: {isNameNumeric}"
);
}
nameValueIds[nameId] =
await Values.GetIdAsync(Ctxt, kvp.Value).ConfigureAwait(false);
}
ScopeTiming.RecordScope("Define.NameIds", localTimer);
Items.SetItemData(Ctxt, itemId, nameValueIds);
ScopeTiming.RecordScope("Define.ItemsCommit", localTimer);
}
await Ctxt.ProcessPostOpsAsync().ConfigureAwait(false);
ScopeTiming.RecordScope("Define.PostOps", localTimer);
}
#if !DEBUG
catch
{
Ctxt.ClearPostOps();
throw;
}
#endif
finally
{
ScopeTiming.RecordScope("Define", totalTimer);
}
}
