/// <summary> /// 得到一个对象实体 /// </summary> public big_data.Model.Userinfoty GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 UserInfoUUID,ID,IsDeleted,AddTime,AddPeople,RealName,UserIdCard,Wechat,Phone,Email,Sex,Address,DepartmentUUID,Birth,IdentityCard,Residence,Domicile,Nation,Education,QianYiSTime,QianYiETime,Settled,Occupation,DyStaues,Politics,position,Evaluate,OrganizationUuid,JoinArmy,ArmyTime,SettledTime,TownUuid,Defense,Category,Partybranch,JoinDate,Work,Age,Household,Relation,HouseholderName from Userinfoty "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; big_data.Model.Userinfoty model = new big_data.Model.Userinfoty(); DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(big_data.Model.Userinfoty model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Userinfoty("); strSql.Append("UserInfoUUID,IsDeleted,AddTime,AddPeople,RealName,UserIdCard,Wechat,Phone,Email,Sex,Address,DepartmentUUID,Birth,IdentityCard,Residence,Domicile,Nation,Education,QianYiSTime,QianYiETime,Settled,Occupation,DyStaues,Politics,position,Evaluate,OrganizationUuid,JoinArmy,ArmyTime,SettledTime,TownUuid,Defense,Category,Partybranch,JoinDate,Work,Age,Household,Relation,HouseholderName)"); strSql.Append(" values ("); strSql.Append("@UserInfoUUID,@IsDeleted,@AddTime,@AddPeople,@RealName,@UserIdCard,@Wechat,@Phone,@Email,@Sex,@Address,@DepartmentUUID,@Birth,@IdentityCard,@Residence,@Domicile,@Nation,@Education,@QianYiSTime,@QianYiETime,@Settled,@Occupation,@DyStaues,@Politics,@position,@Evaluate,@OrganizationUuid,@JoinArmy,@ArmyTime,@SettledTime,@TownUuid,@Defense,@Category,@Partybranch,@JoinDate,@Work,@Age,@Household,@Relation,@HouseholderName)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserInfoUUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@IsDeleted", SqlDbType.Int, 4), new SqlParameter("@AddTime", SqlDbType.NVarChar, 255), new SqlParameter("@AddPeople", SqlDbType.NVarChar, 255), new SqlParameter("@RealName", SqlDbType.NVarChar, 255), new SqlParameter("@UserIdCard", SqlDbType.NVarChar, 255), new SqlParameter("@Wechat", SqlDbType.NVarChar, 255), new SqlParameter("@Phone", SqlDbType.NVarChar, 255), new SqlParameter("@Email", SqlDbType.NVarChar, 255), new SqlParameter("@Sex", SqlDbType.NVarChar, 255), new SqlParameter("@Address", SqlDbType.NVarChar, 255), new SqlParameter("@DepartmentUUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@Birth", SqlDbType.NVarChar, 255), new SqlParameter("@IdentityCard", SqlDbType.NVarChar, 255), new SqlParameter("@Residence", SqlDbType.NVarChar, 255), new SqlParameter("@Domicile", SqlDbType.NVarChar, 255), new SqlParameter("@Nation", SqlDbType.NVarChar, 255), new SqlParameter("@Education", SqlDbType.NVarChar, 255), new SqlParameter("@QianYiSTime", SqlDbType.NVarChar, 255), new SqlParameter("@QianYiETime", SqlDbType.NVarChar, 255), new SqlParameter("@Settled", SqlDbType.NVarChar, 255), new SqlParameter("@Occupation", SqlDbType.NVarChar, 255), new SqlParameter("@DyStaues", SqlDbType.NVarChar, 255), new SqlParameter("@Politics", SqlDbType.NVarChar, 255), new SqlParameter("@position", SqlDbType.NVarChar, 255), new SqlParameter("@Evaluate", SqlDbType.NVarChar, 255), new SqlParameter("@OrganizationUuid", SqlDbType.NVarChar, 255), new SqlParameter("@JoinArmy", SqlDbType.NVarChar, 255), new SqlParameter("@ArmyTime", SqlDbType.NVarChar, 255), new SqlParameter("@SettledTime", SqlDbType.NVarChar, 255), new SqlParameter("@TownUuid", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@Defense", SqlDbType.NVarChar, 255), new SqlParameter("@Category", SqlDbType.NVarChar, 255), new SqlParameter("@Partybranch", SqlDbType.NVarChar, 255), new SqlParameter("@JoinDate", SqlDbType.NVarChar, 255), new SqlParameter("@Work", SqlDbType.NVarChar, 255), new SqlParameter("@Age", SqlDbType.Int, 4), new SqlParameter("@Household", SqlDbType.NVarChar, 255), new SqlParameter("@Relation", SqlDbType.NVarChar, 100), new SqlParameter("@HouseholderName", SqlDbType.NVarChar, 100) }; parameters[0].Value = Guid.NewGuid(); parameters[1].Value = model.IsDeleted; parameters[2].Value = model.AddTime; parameters[3].Value = model.AddPeople; parameters[4].Value = model.RealName; parameters[5].Value = model.UserIdCard; parameters[6].Value = model.Wechat; parameters[7].Value = model.Phone; parameters[8].Value = model.Email; parameters[9].Value = model.Sex; parameters[10].Value = model.Address; parameters[11].Value = Guid.NewGuid(); parameters[12].Value = model.Birth; parameters[13].Value = model.IdentityCard; parameters[14].Value = model.Residence; parameters[15].Value = model.Domicile; parameters[16].Value = model.Nation; parameters[17].Value = model.Education; parameters[18].Value = model.QianYiSTime; parameters[19].Value = model.QianYiETime; parameters[20].Value = model.Settled; parameters[21].Value = model.Occupation; parameters[22].Value = model.DyStaues; parameters[23].Value = model.Politics; parameters[24].Value = model.position; parameters[25].Value = model.Evaluate; parameters[26].Value = model.OrganizationUuid; parameters[27].Value = model.JoinArmy; parameters[28].Value = model.ArmyTime; parameters[29].Value = model.SettledTime; parameters[30].Value = Guid.NewGuid(); parameters[31].Value = model.Defense; parameters[32].Value = model.Category; parameters[33].Value = model.Partybranch; parameters[34].Value = model.JoinDate; parameters[35].Value = model.Work; parameters[36].Value = model.Age; parameters[37].Value = model.Household; parameters[38].Value = model.Relation; parameters[39].Value = model.HouseholderName; object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public big_data.Model.Userinfoty DataRowToModel(DataRow row) { big_data.Model.Userinfoty model = new big_data.Model.Userinfoty(); if (row != null) { if (row["UserInfoUUID"] != null && row["UserInfoUUID"].ToString() != "") { model.UserInfoUUID = new Guid(row["UserInfoUUID"].ToString()); } if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["IsDeleted"] != null && row["IsDeleted"].ToString() != "") { model.IsDeleted = int.Parse(row["IsDeleted"].ToString()); } if (row["AddTime"] != null) { model.AddTime = row["AddTime"].ToString(); } if (row["AddPeople"] != null) { model.AddPeople = row["AddPeople"].ToString(); } if (row["RealName"] != null) { model.RealName = row["RealName"].ToString(); } if (row["UserIdCard"] != null) { model.UserIdCard = row["UserIdCard"].ToString(); } if (row["Wechat"] != null) { model.Wechat = row["Wechat"].ToString(); } if (row["Phone"] != null) { model.Phone = row["Phone"].ToString(); } if (row["Email"] != null) { model.Email = row["Email"].ToString(); } if (row["Sex"] != null) { model.Sex = row["Sex"].ToString(); } if (row["Address"] != null) { model.Address = row["Address"].ToString(); } if (row["DepartmentUUID"] != null && row["DepartmentUUID"].ToString() != "") { model.DepartmentUUID = new Guid(row["DepartmentUUID"].ToString()); } if (row["Birth"] != null) { model.Birth = row["Birth"].ToString(); } if (row["IdentityCard"] != null) { model.IdentityCard = row["IdentityCard"].ToString(); } if (row["Residence"] != null) { model.Residence = row["Residence"].ToString(); } if (row["Domicile"] != null) { model.Domicile = row["Domicile"].ToString(); } if (row["Nation"] != null) { model.Nation = row["Nation"].ToString(); } if (row["Education"] != null) { model.Education = row["Education"].ToString(); } if (row["QianYiSTime"] != null) { model.QianYiSTime = row["QianYiSTime"].ToString(); } if (row["QianYiETime"] != null) { model.QianYiETime = row["QianYiETime"].ToString(); } if (row["Settled"] != null) { model.Settled = row["Settled"].ToString(); } if (row["Occupation"] != null) { model.Occupation = row["Occupation"].ToString(); } if (row["DyStaues"] != null) { model.DyStaues = row["DyStaues"].ToString(); } if (row["Politics"] != null) { model.Politics = row["Politics"].ToString(); } if (row["position"] != null) { model.position = row["position"].ToString(); } if (row["Evaluate"] != null) { model.Evaluate = row["Evaluate"].ToString(); } if (row["OrganizationUuid"] != null) { model.OrganizationUuid = row["OrganizationUuid"].ToString(); } if (row["JoinArmy"] != null) { model.JoinArmy = row["JoinArmy"].ToString(); } if (row["ArmyTime"] != null) { model.ArmyTime = row["ArmyTime"].ToString(); } if (row["SettledTime"] != null) { model.SettledTime = row["SettledTime"].ToString(); } if (row["TownUuid"] != null && row["TownUuid"].ToString() != "") { model.TownUuid = new Guid(row["TownUuid"].ToString()); } if (row["Defense"] != null) { model.Defense = row["Defense"].ToString(); } if (row["Category"] != null) { model.Category = row["Category"].ToString(); } if (row["Partybranch"] != null) { model.Partybranch = row["Partybranch"].ToString(); } if (row["JoinDate"] != null) { model.JoinDate = row["JoinDate"].ToString(); } if (row["Work"] != null) { model.Work = row["Work"].ToString(); } if (row["Age"] != null && row["Age"].ToString() != "") { model.Age = int.Parse(row["Age"].ToString()); } if (row["Household"] != null) { model.Household = row["Household"].ToString(); } if (row["Relation"] != null) { model.Relation = row["Relation"].ToString(); } if (row["HouseholderName"] != null) { model.HouseholderName = row["HouseholderName"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(big_data.Model.Userinfoty model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Userinfoty set "); strSql.Append("IsDeleted=@IsDeleted,"); strSql.Append("AddTime=@AddTime,"); strSql.Append("AddPeople=@AddPeople,"); strSql.Append("RealName=@RealName,"); strSql.Append("UserIdCard=@UserIdCard,"); strSql.Append("Wechat=@Wechat,"); strSql.Append("Phone=@Phone,"); strSql.Append("Email=@Email,"); strSql.Append("Sex=@Sex,"); strSql.Append("Address=@Address,"); strSql.Append("DepartmentUUID=@DepartmentUUID,"); strSql.Append("Birth=@Birth,"); strSql.Append("IdentityCard=@IdentityCard,"); strSql.Append("Residence=@Residence,"); strSql.Append("Domicile=@Domicile,"); strSql.Append("Nation=@Nation,"); strSql.Append("Education=@Education,"); strSql.Append("QianYiSTime=@QianYiSTime,"); strSql.Append("QianYiETime=@QianYiETime,"); strSql.Append("Settled=@Settled,"); strSql.Append("Occupation=@Occupation,"); strSql.Append("DyStaues=@DyStaues,"); strSql.Append("Politics=@Politics,"); strSql.Append("position=@position,"); strSql.Append("Evaluate=@Evaluate,"); strSql.Append("OrganizationUuid=@OrganizationUuid,"); strSql.Append("JoinArmy=@JoinArmy,"); strSql.Append("ArmyTime=@ArmyTime,"); strSql.Append("SettledTime=@SettledTime,"); strSql.Append("TownUuid=@TownUuid,"); strSql.Append("Defense=@Defense,"); strSql.Append("Category=@Category,"); strSql.Append("Partybranch=@Partybranch,"); strSql.Append("JoinDate=@JoinDate,"); strSql.Append("Work=@Work,"); strSql.Append("Age=@Age,"); strSql.Append("Household=@Household,"); strSql.Append("Relation=@Relation,"); strSql.Append("HouseholderName=@HouseholderName"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@IsDeleted", SqlDbType.Int, 4), new SqlParameter("@AddTime", SqlDbType.NVarChar, 255), new SqlParameter("@AddPeople", SqlDbType.NVarChar, 255), new SqlParameter("@RealName", SqlDbType.NVarChar, 255), new SqlParameter("@UserIdCard", SqlDbType.NVarChar, 255), new SqlParameter("@Wechat", SqlDbType.NVarChar, 255), new SqlParameter("@Phone", SqlDbType.NVarChar, 255), new SqlParameter("@Email", SqlDbType.NVarChar, 255), new SqlParameter("@Sex", SqlDbType.NVarChar, 255), new SqlParameter("@Address", SqlDbType.NVarChar, 255), new SqlParameter("@DepartmentUUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@Birth", SqlDbType.NVarChar, 255), new SqlParameter("@IdentityCard", SqlDbType.NVarChar, 255), new SqlParameter("@Residence", SqlDbType.NVarChar, 255), new SqlParameter("@Domicile", SqlDbType.NVarChar, 255), new SqlParameter("@Nation", SqlDbType.NVarChar, 255), new SqlParameter("@Education", SqlDbType.NVarChar, 255), new SqlParameter("@QianYiSTime", SqlDbType.NVarChar, 255), new SqlParameter("@QianYiETime", SqlDbType.NVarChar, 255), new SqlParameter("@Settled", SqlDbType.NVarChar, 255), new SqlParameter("@Occupation", SqlDbType.NVarChar, 255), new SqlParameter("@DyStaues", SqlDbType.NVarChar, 255), new SqlParameter("@Politics", SqlDbType.NVarChar, 255), new SqlParameter("@position", SqlDbType.NVarChar, 255), new SqlParameter("@Evaluate", SqlDbType.NVarChar, 255), new SqlParameter("@OrganizationUuid", SqlDbType.NVarChar, 255), new SqlParameter("@JoinArmy", SqlDbType.NVarChar, 255), new SqlParameter("@ArmyTime", SqlDbType.NVarChar, 255), new SqlParameter("@SettledTime", SqlDbType.NVarChar, 255), new SqlParameter("@TownUuid", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@Defense", SqlDbType.NVarChar, 255), new SqlParameter("@Category", SqlDbType.NVarChar, 255), new SqlParameter("@Partybranch", SqlDbType.NVarChar, 255), new SqlParameter("@JoinDate", SqlDbType.NVarChar, 255), new SqlParameter("@Work", SqlDbType.NVarChar, 255), new SqlParameter("@Age", SqlDbType.Int, 4), new SqlParameter("@Household", SqlDbType.NVarChar, 255), new SqlParameter("@Relation", SqlDbType.NVarChar, 100), new SqlParameter("@HouseholderName", SqlDbType.NVarChar, 100), new SqlParameter("@UserInfoUUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.IsDeleted; parameters[1].Value = model.AddTime; parameters[2].Value = model.AddPeople; parameters[3].Value = model.RealName; parameters[4].Value = model.UserIdCard; parameters[5].Value = model.Wechat; parameters[6].Value = model.Phone; parameters[7].Value = model.Email; parameters[8].Value = model.Sex; parameters[9].Value = model.Address; parameters[10].Value = model.DepartmentUUID; parameters[11].Value = model.Birth; parameters[12].Value = model.IdentityCard; parameters[13].Value = model.Residence; parameters[14].Value = model.Domicile; parameters[15].Value = model.Nation; parameters[16].Value = model.Education; parameters[17].Value = model.QianYiSTime; parameters[18].Value = model.QianYiETime; parameters[19].Value = model.Settled; parameters[20].Value = model.Occupation; parameters[21].Value = model.DyStaues; parameters[22].Value = model.Politics; parameters[23].Value = model.position; parameters[24].Value = model.Evaluate; parameters[25].Value = model.OrganizationUuid; parameters[26].Value = model.JoinArmy; parameters[27].Value = model.ArmyTime; parameters[28].Value = model.SettledTime; parameters[29].Value = model.TownUuid; parameters[30].Value = model.Defense; parameters[31].Value = model.Category; parameters[32].Value = model.Partybranch; parameters[33].Value = model.JoinDate; parameters[34].Value = model.Work; parameters[35].Value = model.Age; parameters[36].Value = model.Household; parameters[37].Value = model.Relation; parameters[38].Value = model.HouseholderName; parameters[39].Value = model.UserInfoUUID; parameters[40].Value = model.ID; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 匹配户籍信息和地址库 /// </summary> public void UnifiedAddressLibraryUserInfo() { DataSet dss = userinfotybll.GetList("1=1"); if (dss.Tables[0].Rows.Count > 0) { for (int i = 0; i < dss.Tables[0].Rows.Count; i++) { string mphhm = ""; string Issfpp = "0"; if (dss.Tables[0].Rows[i]["Domicile"].ToString() != "") { userinfotymodel = userinfotybll.GetModel(Convert.ToInt32(dss.Tables[0].Rows[i]["ID"].ToString())); if (dss.Tables[0].Rows[i]["Domicile"].ToString().Length >= 12) { string[] strlist = dss.Tables[0].Rows[i]["Domicile"].ToString().Split('村'); if (strlist.Length > 1) { mphhm = ToDBC(strlist[1]);//地址 } } else { mphhm = ToDBC(dss.Tables[0].Rows[i]["Domicile"].ToString());//地址 } } else { mphhm = "户籍信息中没有地址信息"; } string username = dss.Tables[0].Rows[i]["RealName"].ToString();//姓名 DataSet dssa = unifiedAddressLibrarybll.GetList("SOURCEADDRESS like '%" + mphhm + "%'"); if (dssa.Tables[0].Rows.Count > 0) { for (int i1 = 0; i1 < dssa.Tables[0].Rows.Count; i1++) { DataSet dssb = unifiedAddressLibraryUserInfobll.GetList("UnifiedAddressLibraryID=" + dssa.Tables[0].Rows[i1]["ID"]); if (dssb.Tables[0].Rows.Count > 0) { unifiedAddressLibraryUserInfomodel = unifiedAddressLibraryUserInfobll.GetModel(Convert.ToInt32(dssb.Tables[0].Rows[0]["ID"])); if (!("," + unifiedAddressLibraryUserInfomodel.UserIDList + ",").Contains("," + dss.Tables[0].Rows[i]["ID"] + ",")) { unifiedAddressLibraryUserInfomodel.UserIDList += "," + dss.Tables[0].Rows[i]["ID"].ToString(); } unifiedAddressLibraryUserInfomodel.AddTime = DateTime.Now; unifiedAddressLibraryUserInfobll.Update(unifiedAddressLibraryUserInfomodel); } else { unifiedAddressLibraryUserInfomodel.UnifiedAddressLibraryID = Convert.ToInt32(dssa.Tables[0].Rows[i1]["ID"]); unifiedAddressLibraryUserInfomodel.UserIDList = dss.Tables[0].Rows[i]["ID"].ToString(); unifiedAddressLibraryUserInfomodel.AddTime = DateTime.Now; unifiedAddressLibraryUserInfobll.Add(unifiedAddressLibraryUserInfomodel); } } Issfpp = "1"; } else { DataSet dssab = unifiedAddressLibrarybll.GetList("SOURCEADDRESS like '%" + username + "%'"); if (dssab.Tables[0].Rows.Count > 0) { for (int i1 = 0; i1 < dssab.Tables[0].Rows.Count; i1++) { DataSet dssabb = unifiedAddressLibraryUserInfobll.GetList("UnifiedAddressLibraryID=" + dssab.Tables[0].Rows[i1]["ID"]); if (dssabb.Tables[0].Rows.Count > 0) { unifiedAddressLibraryUserInfomodel = unifiedAddressLibraryUserInfobll.GetModel(Convert.ToInt32(dssabb.Tables[0].Rows[0]["ID"])); if (!("," + unifiedAddressLibraryUserInfomodel.UserIDList + ",").Contains("," + dss.Tables[0].Rows[i]["ID"] + ",")) { unifiedAddressLibraryUserInfomodel.UserIDList += "," + dss.Tables[0].Rows[i]["ID"].ToString(); } unifiedAddressLibraryUserInfomodel.AddTime = DateTime.Now; unifiedAddressLibraryUserInfobll.Update(unifiedAddressLibraryUserInfomodel); } else { unifiedAddressLibraryUserInfomodel.UnifiedAddressLibraryID = Convert.ToInt32(dssab.Tables[0].Rows[i1]["ID"]); unifiedAddressLibraryUserInfomodel.UserIDList = dss.Tables[0].Rows[i]["ID"].ToString(); unifiedAddressLibraryUserInfomodel.AddTime = DateTime.Now; unifiedAddressLibraryUserInfobll.Add(unifiedAddressLibraryUserInfomodel); } } Issfpp = "1"; } } userinfotymodel.Work = Issfpp; userinfotymodel.TownUuid = townbll.GetModel(1).TownUuid; userinfotybll.Update(userinfotymodel); } } //AlertAndStay("数据更新完成!!!"); LogHelper.WriteLog(typeof(FrmMainServer), "数据更新完成!!!"); }