public ActionResult ArticleEdit(int id)//此处id表示ArticleID
{
HttpCookie cookie = Request.Cookies["Employer"];
if (cookie != null)
{
string EmployerAccount = cookie.Values["EmployerAccount"];
DataTable temparticle = TempArticle.GetTempArticleByArticleID(id, EmployerAccount);
if (temparticle.Rows.Count > 0)//该文章已经被编辑过，存在于TempArticle里面
{
//重定向TempArticleEdit
return(RedirectToAction("TempArticleEdit", new { id = temparticle.Rows[0]["TempArticleID"] }));
}
else
{
ViewBag.flag = true; //文章是否存在的标志
DataTable article = Article.GetArticleByArticleIDAndEditorAccount(id, EmployerAccount); //得到Article表文章
if (article != null && article.Rows.Count > 0)
{
ViewBag.Article = article;
//显示大型招聘会选项
int typeid = Convert.ToInt32(article.Rows[0]["TypeID"]);
ViewBag.typename = ArticleType.GetTypeNameByTypeID(typeid);
if (typeid == 1)//专场招聘
{
//获取时间和地点
ViewBag.PlaceList = Article.GetPlaceListSecondById(Convert.ToInt32(article.Rows[0]["PlaceSecondID"]));
ViewBag.PlaceListFirst = Article.GetPlaceListFirst();
}
if (typeid == 2)//双选会
{
DataTable bigarticleTable2 = Article.SelectArticleFromArticle(2, DateTime.Now);
ViewBag.bigarticleTable2 = bigarticleTable2;
ViewBag.BigArticleID = Article.GetBigArticleByArticleID(Convert.ToInt32(article.Rows[0]["ArticleID"]));
}
else if (typeid == 3)//组团招聘
{
DataTable bigarticleTable3 = Article.SelectArticleFromArticle(3, DateTime.Now);
ViewBag.bigarticleTable3 = bigarticleTable3;
ViewBag.BigArticleID = Article.GetBigArticleByArticleID(Convert.ToInt32(article.Rows[0]["ArticleID"]));
}
//其他类型的文章不用管
//需求部分
ViewBag.DemandInfos = DemandInfo.GetDemandInfoByArticleID(id);
}
else
{
ViewBag.flag = false;
} //文章不存在
}
}
else
{
ViewBag.flag = false;
} //cookie不存在
return(View());
}
public DemandScalarDialog(App game, DemandType type, int otherPlayer, string template = "dialogRequestScalar")
: base(game, template)
{
this._otherPlayer = otherPlayer;
this._type = type;
this._demand = new DemandInfo();
this._demand.InitiatingPlayer = game.LocalPlayer.ID;
this._demand.ReceivingPlayer = this._otherPlayer;
this._demand.State = AgreementState.Unrequested;
this._demand.Type = type;
}
protected void finesSelectedChanged(object sender, EventArgs e)
{
// Get the currently selected row using the SelectedRow property.
GridViewRow row = carFinesInfoList.SelectedRow;
DemandInfo demandInfo = new DemandInfo();
demandInfo.payTicketNo = row.Cells[2].Text.ToString();
demandInfo.finesStyle = row.Cells[3].Text;
demandInfo.finesMemoy = row.Cells[4].Text;
demandInfo.dePoint = row.Cells[5].Text;
demandInfo.carNo = carNo_label.Text;
Session.Add("demandInfo", demandInfo);
Response.Redirect("PayFinesWeb.aspx", true);
}
/// <summary>
/// 确认上线
/// </summary>
/// <param name="objDemand"></param>
/// <returns></returns>
public int UpLineDemand(DemandInfo objDemand)
{
string sql = $"update DemandInfo set Publisher=@Publisher,ScheduleTime=@ScheduleTime,UpTime=@UpTime where DemandId=@DemandId";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@Publisher", objDemand.Publisher),
new SqlParameter("@ScheduleTime", objDemand.ScheduleTime),
new SqlParameter("@UpTime", objDemand.UpTime),
new SqlParameter("@DemandId", objDemand.DemandId),
};
return(SQLHelper.Update(sql, paras));
}
public ActionResult ModifyDemandInfo(DemandInfo objDemand)
{
//DemandInfo objDemand = new DemandInfo()
//{
// DemandId = Convert.ToInt32(Request.Params["DemandId"]),
// ProductId = Convert.ToInt32(Request.Params["ProductId"]),
// SubmissionDepartment = Request.Params["SubmissionDepartment"],
// RequirementDescription = Request.Params["RequirementDescription"],
// EmergencyId = Convert.ToInt32(Request.Params["EmergencyId"]),
// Modifier = Request.Params["Modifier"],
// ModificationTime = DateTime.Now
//};
objDemand.Modifier = Convert.ToInt32(Session["UserId"]);
objDemand.ModificationTime = DateTime.Now;
if (string.IsNullOrEmpty(objDemand.SubmissionDepartment))
{
ViewBag.Mess = "请填写提交部门";
}
else if (string.IsNullOrEmpty(objDemand.RequirementDescription))
{
ViewBag.Mess = "请填写需求描述";
}
else
{
//调用业务逻辑
int result = new BLL.DemandManager().ModifyDemandInfoByDemandId(objDemand);
//保存数据
if (result > 0)
{
return(Content("<script>alert('修改成功！');document.location='" + Url.Action("Index", "Demand") + "';</script>"));
}
else
{
return(Content("<script>alert('修改失败！');document.location='" + Url.Action("Index", "Demand") + "';</script>"));
}
}
//if (string.IsNullOrEmpty(objDemand.SubmissionDepartment))
//{
// ViewBag.Mess = "提交部门不能为空";
//}
//else if (string.IsNullOrEmpty(objDemand.RequirementDescription))
//{
// ViewBag.Mess = "需求描述不能为空";
//}
//else
//{
//}
return(View("ModifyDemandInfo"));
}
/// <summary>
/// 认领需求
/// </summary>
/// <param name="objDemand"></param>
/// <returns></returns>
public int ConfirmDemand(DemandInfo objDemand)
{
string sql = $"update DemandInfo set PlanContent=@PlanContent,ExpectedOnlineTime=@ExpectedOnlineTime,ConfirmationPerson=@ConfirmationPerson,ConfirmTime=@ConfirmTime where DemandId=@DemandId";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@PlanContent", objDemand.PlanContent),
new SqlParameter("@ExpectedOnlineTime", objDemand.ExpectedOnlineTime),
new SqlParameter("@ConfirmationPerson", objDemand.ConfirmationPerson),
new SqlParameter("@ConfirmTime", objDemand.ConfirmTime),
new SqlParameter("@DemandId", objDemand.DemandId)
};
return(SQLHelper.Update(sql, paras));
}
/// <summary>
/// 发布需求
/// </summary>
/// <param name="objDemand"></param>
/// <returns></returns>
public int AddDemandInfo(DemandInfo objDemand)
{
string sql = $"insert into DemandInfo(ProductId,SubmissionDepartment,RequirementDescription,EmergencyId,Founder,CreationTime) values(@ProductId,@SubmissionDepartment,@RequirementDescription,@EmergencyId,@Founder,@CreationTime)";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@ProductId", objDemand.ProductId),
new SqlParameter("@SubmissionDepartment", objDemand.SubmissionDepartment),
new SqlParameter("@RequirementDescription", objDemand.RequirementDescription),
new SqlParameter("@EmergencyId", objDemand.EmergencyId),
new SqlParameter("@Founder", objDemand.Founder),
new SqlParameter("@CreationTime", objDemand.CreationTime)
};
return(SQLHelper.Update(sql, paras));
}
/// <summary>
/// 根据需求详情ID编号修改需求
/// </summary>
/// <param name="objDemand"></param>
/// <returns></returns>
public int ModifyDemandInfoByDemandId(DemandInfo objDemand)
{
string sql = $"update DemandInfo set [ProductId]=@ProductId, [SubmissionDepartment]=@SubmissionDepartment, [RequirementDescription]=@RequirementDescription, [EmergencyId]=@EmergencyId,Modifier=@Modifier,ModificationTime=@ModificationTime where DemandId=@DemandId";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@ProductId", objDemand.ProductId),
new SqlParameter("@SubmissionDepartment", objDemand.SubmissionDepartment),
new SqlParameter("@RequirementDescription", objDemand.RequirementDescription),
new SqlParameter("@EmergencyId", objDemand.EmergencyId),
new SqlParameter("@Modifier", objDemand.Modifier),
new SqlParameter("@ModificationTime", objDemand.ModificationTime),
new SqlParameter("@DemandId", objDemand.DemandId)
};
return(SQLHelper.Update(sql, paras));
}
public ActionResult UpLineDemand(DemandInfo objDemand)
{
//获取数据
objDemand.Publisher = Convert.ToInt32(Session["UserId"]);
objDemand.ScheduleTime = DateTime.Now;
//调用业务逻辑
int result = new BLL.DemandManager().UpLineDemand(objDemand);
if (result > 0)
{
return(Content("<script>alert('确认成功！');document.location='" + Url.Action("Index", "Demand") + "';</script>"));
}
else
{
return(Content("<script>alert('确认失败！');document.location='" + Url.Action("Index", "Demand") + "';</script>"));
}
}
public DemandSystemSelectDialog(App game, DemandType type, int otherPlayer, string template = "dialogRequestSystemSelect")
: base(game, template)
{
this._otherPlayer = otherPlayer;
this._type = type;
this._demand = new DemandInfo();
this._demand.InitiatingPlayer = game.LocalPlayer.ID;
this._demand.ReceivingPlayer = this._otherPlayer;
this._demand.State = AgreementState.Unrequested;
this._demand.Type = type;
this._crits = new GameObjectSet(game);
this._sky = new Sky(game, SkyUsage.StarMap, 0);
this._crits.Add((IGameObject)this._sky);
this._starmap = new StarMap(game, game.Game, this._sky);
this._crits.Add((IGameObject)this._starmap);
this._starmap.SetCamera(game.Game.StarMapCamera);
}
public ActionResult PublishDemandInfo(DemandInfo objDemand)
{
//接收数据
//DemandInfo objDemand = new DemandInfo()
//{
// ProductId = Convert.ToInt32(Request.Params["ProductId"]),
// SubmissionDepartment = Request.Params["SubmissionDepartment"],
// RequirementDescription = Request.Params["RequirementDescription"],
// EmergencyId = Convert.ToInt32(Request["EmergencyId"]),
// Founder = Request.Params["Founder"],
// CreationTime = DateTime.Now,
// UserId = Convert.ToInt32(Request.Params["UserId"])
//};
objDemand.Founder = Convert.ToInt32(Session["UserId"]);
objDemand.CreationTime = DateTime.Now;
ViewBag.SubmissionDepartment = objDemand.SubmissionDepartment;
ViewBag.RequirementDescription = objDemand.RequirementDescription;
if (string.IsNullOrEmpty(objDemand.SubmissionDepartment))
{
ViewBag.Mess = "请填写提交部门";
}
else if (string.IsNullOrEmpty(objDemand.RequirementDescription))
{
ViewBag.Mess = "请填写需求描述";
}
else
{
//调用业务逻辑
int result = new BLL.DemandManager().PublishDemandInfo(objDemand);
//保存数据
if (result > 0)
{
return(Content("<script>alert('发布成功！');document.location='" + Url.Action("Index", "Demand") + "';</script>"));
}
else
{
return(Content("<script>alert('发布失败！');document.location='" + Url.Action("Index", "Demand") + "';</script>"));
}
}
return(View("AddDemandInfo"));
}
protected override void OnPanelMessage(string panelName, string msgType, string[] msgParams)
{
if (msgType == "button_clicked")
{
if (panelName == "btnFinishRequest")
{
this._app.GameDatabase.SpendDiplomacyPoints(this._app.GameDatabase.GetPlayerInfo(this._app.LocalPlayer.ID), this._app.GameDatabase.GetPlayerFactionID(this._otherPlayer), this._app.AssetDatabase.GetDiplomaticDemandPointCost(this._type));
this._app.GameDatabase.InsertDemand(this._demand);
this._app.UI.CloseDialog((Dialog)this, true);
}
else
{
if (!(panelName == "btnCancel"))
{
return;
}
this._demand = (DemandInfo)null;
this._app.UI.CloseDialog((Dialog)this, true);
}
}
else if (msgType == "slider_value")
{
if (!(panelName == "sldValue"))
{
return;
}
this._demand.DemandValue = float.Parse(msgParams[0]);
this._app.UI.SetText("txtValue", msgParams[0]);
}
else
{
int result;
if (!(msgType == "text_changed") || !int.TryParse(msgParams[0], out result))
{
return;
}
this._demand.DemandValue = (float)result;
this._app.UI.SetSliderValue("sldValue", result);
}
}
protected override void OnPanelMessage(string panelName, string msgType, string[] msgParams)
{
if (msgType == "button_clicked")
{
if (panelName == "btnFinishRequest")
{
this._app.GameDatabase.SpendDiplomacyPoints(this._app.GameDatabase.GetPlayerInfo(this._app.LocalPlayer.ID), this._app.GameDatabase.GetPlayerFactionID(this._otherPlayer), this._app.AssetDatabase.GetDiplomaticDemandPointCost(this._type));
this._app.GameDatabase.InsertDemand(this._demand);
this._app.UI.CloseDialog((Dialog)this, true);
}
else
{
if (!(panelName == "btnCancel"))
{
return;
}
this._demand = (DemandInfo)null;
this._app.UI.CloseDialog((Dialog)this, true);
}
}
else
{
if (!(msgType == "list_sel_changed") || !(panelName == "lstItems"))
{
return;
}
if (this._starmap.Systems.Reverse.ContainsKey((int)this._demand.DemandValue))
{
this._starmap.PostSetProp("ProvinceSystemSelectEffect", (object)false, (object)this._starmap.Systems.Reverse[(int)this._demand.DemandValue]);
}
this._demand.DemandValue = float.Parse(msgParams[0]);
if (!this._starmap.Systems.Reverse.ContainsKey((int)this._demand.DemandValue))
{
return;
}
this._starmap.SetFocus((IGameObject)this._starmap.Systems.Reverse[(int)this._demand.DemandValue]);
this._starmap.PostSetProp("ProvinceSystemSelectEffect", (object)true, (object)this._starmap.Systems.Reverse[(int)this._demand.DemandValue]);
this._app.Game.StarMapSelectedObject = (object)this._starmap.Systems.Reverse[(int)this._demand.DemandValue];
}
}
public ActionResult ConfirmDemandInfo(DemandInfo objDemand)
{
//根据需求编号获取需求数据
var old = objDemand;
objDemand = new BLL.DemandManager().GetDemandDetailByDemandId(objDemand.DemandId);
objDemand.PlanContent = old.PlanContent;
objDemand.ExpectedOnlineTime = old.ExpectedOnlineTime;
//保存数据
//ViewBag.PlanContent = objDemand.PlanContent;
//ViewBag.ExpectedOnlineTime = objDemand.ExpectedOnlineTime;
if (string.IsNullOrEmpty(objDemand.PlanContent))
{
ViewBag.M = "上线计划内容不能为空";
}
else if (objDemand.ExpectedOnlineTime == null)
{
ViewBag.M = "请选择预计上线时间";
}
else
{
objDemand.ConfirmationPerson = Convert.ToInt32(Session["UserId"]);
objDemand.ConfirmTime = DateTime.Now;
//调用业务逻辑
int result = new BLL.DemandManager().ConfirmDemand(objDemand);
if (result > 0)
{
return(Content("<script>alert('认领成功！');document.location='" + Url.Action("Index", "Demand") + "';</script>"));
}
else
{
return(Content("<script>alert('认领失败！');document.location='" + Url.Action("Index", "Demand") + "';</script>"));
}
}
return(View("ConfrimDemand", objDemand));
}
public DemandRequestedDialog(App game, DemandInfo di, string template = "dialogRequested")
: base(game, template)
{
this._demand = di;
}
/// <summary>
/// 根据需求详情ID编号修改需求
/// </summary>
/// <param name="objDemand"></param>
/// <returns></returns>
public int ModifyDemandInfoByDemandId(DemandInfo objDemand)
{
return(new DAL.DemandService().ModifyDemandInfoByDemandId(objDemand));
}
/// <summary>
/// 认领需求
/// </summary>
/// <param name="objDemand"></param>
/// <returns></returns>
public int ConfirmDemand(DemandInfo objDemand)
{
return(new DAL.DemandService().ConfirmDemand(objDemand));
}
/// <summary>
/// 发布需求
/// </summary>
/// <param name="objDemand"></param>
/// <returns></returns>
public int PublishDemandInfo(DemandInfo objDemand)
{
return(new DAL.DemandService().AddDemandInfo(objDemand));
}
/// <summary>
/// 根据需求编号查询需求详情
/// </summary>
/// <param name="DemandId">需求编号</param>
/// <returns></returns>
public DemandInfo GetDemandDetailByConfirmationPerson(int DemandInfoId)
{
string sql = @"select d.[DemandId],d.ProductId,p.ProductName,d.[SubmissionDepartment],d.[RequirementDescription],
d.EmergencyId, e.EmergencyName, d.Founder,u.UserName, d.[CreationTime],
d.Modifier,ModifierName=(SELECT ur.UserName FROM Users AS ur WHERE ur.UserId=d.Modifier), d.ModificationTime,
d.ConfirmationPerson, ConfirmationName=(SELECT ur.UserName FROM Users AS ur WHERE ur.UserId=d.ConfirmationPerson),
d.ConfirmTime, d.ExpectedOnlineTime, d.PlanContent,
d.Publisher,Upline=(SELECT ur.UserName FROM Users AS ur WHERE ur.UserId=d.Publisher),
d.ScheduleTime, d.UpTime from DemandInfo AS d
left join EmergencyDegree AS e on d.EmergencyId = e.EmergencyId
left join Products AS p on d.ProductId = p.ProductId
left join Users AS u on d.Founder = u.UserId
where [ConfirmationPerson]=@DemandInfoId";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@DemandInfoId", DemandInfoId)
};
SqlDataReader objReader = SQLHelper.GetReader(sql, paras);
DemandInfo demand = null;
if (objReader.Read())
{
//DemandInfo entity = new DemandInfo();
//demand = entity;
//entity.DemandId = Convert.ToInt32(objReader["DemandId"]);
//entity.ProductId = Convert.ToInt32(objReader["ProductId"]);
//if (objReader["DemandId"] is DBNull){
// entity.ModificationTime = null;
//}
//else
//{
// entity.ModificationTime = Convert.ToDateTime(objReader["DemandId"]);
//}
//if (objReader["ProductId"] is DBNull)
//{
// entity.ModificationTime = null;
//}
//else
//{
// entity.ModificationTime = Convert.ToDateTime(objReader["ProductId"]);
//}
demand = new DemandInfo()
{
DemandId = ConvertInt(objReader["DemandId"].ToString()), //需求详情编号
ProductId = ConvertInt(objReader["ProductId"].ToString()), //产品编号
ProductName = objReader["ProductName"]?.ToString(), //产品名称
SubmissionDepartment = objReader["SubmissionDepartment"]?.ToString(), //提交部门
RequirementDescription = objReader["RequirementDescription"]?.ToString(), //需求描述
EmergencyId = ConvertInt(objReader["EmergencyId"].ToString()), //紧急程度编号
EmergencyName = objReader["EmergencyName"]?.ToString(), //紧急程度名称
Founder = ConvertInt(objReader["Founder"].ToString()), //创建人编号
UserName = objReader["UserName"]?.ToString(), //创建人
CreationTime = (objReader["CreationTime"]?.ToString()).ConvertReaderDateTime(), //创建时间
Modifier = ConvertInt(objReader["Modifier"].ToString()), //修改人编号
ModifierName = objReader["ModifierName"]?.ToString(), //修改人
ModificationTime = (objReader["ModificationTime"]?.ToString()).ConvertReaderDateTime(), //修改时间
ConfirmationPerson = ConvertInt(objReader["ConfirmationPerson"].ToString()), //确认人编号
ConfirmationName = objReader["ConfirmationName"]?.ToString(), //确认人
ConfirmTime = (objReader["ConfirmTime"]?.ToString()).ConvertReaderDateTime(), //确认时间
ExpectedOnlineTime = (objReader["ExpectedOnlineTime"]?.ToString()).ConvertReaderDateTime(), //预计上线时间
PlanContent = objReader["PlanContent"]?.ToString(), //上线计划内容
Publisher = ConvertInt(objReader["Publisher"].ToString()), //发布人编号
Upline = objReader["Upline"]?.ToString(), //发布人
ScheduleTime = (objReader["ScheduleTime"]?.ToString()).ConvertReaderDateTime(), //发布时间
UpTime = (objReader["UpTime"]?.ToString()).ConvertReaderDateTime(), //上线时间
};
}
objReader.Close();
return(demand);
}
/// <summary>
/// 组装客户信息
/// </summary>
/// <param name="Mobile">手机号</param>
/// <param name="IDNumber">身份证号</param>
/// <param name="Tag">输出的客户信息</param>
/// <returns>组装结果</returns>
private int AssembleCustomerInfo(String Mobile, String IDNumber, out PersonTag Tag)
{
Tag = new PersonTag();
Tag.TradeInfos = new List <TradeInfo>();
Tag.DemandInfos = new List <DemandInfo>();
DataSet ResultSet = new DataSet();
//按给定的Mobile和IDNumber查询客户信息
try
{
ResultSet = new DbHelperSQLP(ConnStringCustomerInfo).RunProcedure("P_QueryCustomerInfo",
new IDataParameter[] { new SqlParameter("@Mobile", Mobile), new SqlParameter("@IDNumber", IDNumber) }
, "noname");
}
catch (Exception)
{
Tag = null;
return(-1);
}
//没有查到
if (ResultSet.Tables[0].Rows.Count == 0 &&
ResultSet.Tables[1].Rows.Count == 0 &&
ResultSet.Tables[2].Rows.Count == 0 &&
ResultSet.Tables[3].Rows.Count == 0)
{
Tag = null;
return(-3);
}
Tag.Mobile = Mobile;
Tag.IDNumber = IDNumber;
//同时提供手机号和身份证号时
if (!String.IsNullOrEmpty(IDNumber) && !String.IsNullOrEmpty(Mobile))
{
//检查同时提供手机号和身份证号时,是否与库中数据匹配
bool MobileMatchesIDNumber = false;
for (int i = 0; i < ResultSet.Tables[1].Rows.Count; i++)
{
String CheckStringMobile = ResultSet.Tables[1].Rows[i]["mobile"].ToString();
String CheckStringIDNumber = ResultSet.Tables[1].Rows[i]["id_number"].ToString();
if (CheckStringMobile.Length == 11 && CheckStringIDNumber.Length >= 15 &&
CheckStringMobile == Mobile && CheckStringIDNumber == IDNumber)
{
MobileMatchesIDNumber = true;
break;
}
}
if (MobileMatchesIDNumber == false)
{
return(-2);
}
}
if (String.IsNullOrWhiteSpace(Mobile))
{
Tag.Mobile = GetSpecificInfoFromDataset(ResultSet,
1, "mobile", DataSetResultQueryType.MostOccuredValue);
}
if (String.IsNullOrWhiteSpace(IDNumber))
{
Tag.IDNumber = GetSpecificInfoFromDataset(ResultSet,
1, "id_number", DataSetResultQueryType.MostOccuredValue);
}
Tag.Name = GetSpecificInfoFromDataset(ResultSet,
1, "customer_name", DataSetResultQueryType.MostOccuredValue);
Tag.Sex = GetSpecificInfoFromDataset(ResultSet,
1, "sex", DataSetResultQueryType.MostOccuredValue);
if (String.IsNullOrWhiteSpace(Tag.Sex) && !String.IsNullOrWhiteSpace(Tag.IDNumber))
{
Tag.Sex = GetSexFromIDNumber(Tag.IDNumber);
}
Tag.Age = "";
if (!String.IsNullOrWhiteSpace(Tag.IDNumber))
{
int IDNumberAge = GetAgeFromIDNumber(Tag.IDNumber);
if (IDNumberAge >= 0)
{
Tag.Age = IDNumberAge.ToString();
}
}
Tag.RegisterCity = GetSpecificInfoFromDataset(ResultSet,
1, "census_register", DataSetResultQueryType.MostOccuredValue);
Tag.Profession = GetSpecificInfoFromDataset(ResultSet,
3, "industry", DataSetResultQueryType.CommaSeparatedValues, 2);
Tag.Interests = GetSpecificInfoFromDataset(ResultSet,
3, "tags", DataSetResultQueryType.CommaSeparatedValues, 3);
Tag.FamilyIncome = GetSpecificInfoFromDataset(ResultSet,
3, "family_income", DataSetResultQueryType.MostOccuredValue);
Tag.Marriage = GetSpecificInfoFromDataset(ResultSet,
3, "marry", DataSetResultQueryType.MostOccuredValue);
Tag.FamilyStatus = GetSpecificInfoFromDataset(ResultSet,
3, "family_structure", DataSetResultQueryType.MostOccuredValue);
Tag.ChildrenStatus = GetSpecificInfoFromDataset(ResultSet,
3, "children_info", DataSetResultQueryType.MostOccuredValue);
//解析家庭
if (ResultSet.Tables[2].Rows.Count > 1)
{
//载入性别年龄
List <int> Ages = new List <int>();
List <String> Sexes = new List <string>();
for (int i = 0; i < ResultSet.Tables[2].Rows.Count; i++)
{
int Age = GetAgeFromIDNumber(ResultSet.Tables[2].Rows[i]["id_number"].ToString());
String Sex = GetSexFromIDNumber(ResultSet.Tables[2].Rows[i]["id_number"].ToString());
if (Age >= 0 && (Sex == "男" || Sex == "女"))
{
Ages.Add(Age);
Sexes.Add(Sex);
}
}
////2异性一代人 异性且年龄差＜18
////2同性一代人 同性且年龄差＜18
////2两代人 年龄差≥18
////3一代人 年龄极差＜18
////3两代人 年龄极差≥18且存在两个年龄相差＜18
////3三代人 任意两年龄极差≥18
////4一代人 年龄极差＜18
////4两代人 年龄极差≥18且任意年龄值的min{ 该年龄值与两个极值的差值的绝对值}＜18
////4三代人 年龄极差≥18且存在一个年龄值min{ 该年龄值与两个极值的差值的绝对值}≥18
//// 且存在一个年龄值min{ 该年龄值与其他三个的差值的绝对值}＜18
////4四代人 任意两年龄极差≥18 任意两年龄极差≥18
////≥5 署名人数≥5
//2人情况
if (Ages.Count == 2)
{
if (Math.Abs(Ages[0] - Ages[1]) < 18)
{
if (Sexes[0] != Sexes[1])
{
Tag.FamilyStatus = "2人,异性,一代人";
if (Math.Abs(Ages[0] - Ages[1]) <= 5)
{
Tag.Marriage = "已婚";
}
}
else
{
Tag.FamilyStatus = "2人,同性,一代人";
}
}
else
{
Tag.FamilyStatus = "2人,两代人";
if (Ages[0] < 18 || Ages[1] < 18)
{
Tag.FamilyStatus += ",有未成年子女";
}
}
}
int MaxAge = Ages.Max();
int MinAge = Ages.Min();
//3人情况
if (Ages.Count == 3)
{
if (MaxAge - MinAge < 18)
{
Tag.FamilyStatus = "3人,一代人";
}
if (MaxAge - MinAge >= 18)
{
for (int i = 0; i < Ages.Count; i++)
{
if (Math.Abs(Ages[0] - Ages[1]) < 18 ||
Math.Abs(Ages[1] - Ages[2]) < 18 ||
Math.Abs(Ages[0] - Ages[2]) < 18)
{
Tag.FamilyStatus = "3人,两代人";
if (MinAge < 18)
{
Tag.FamilyStatus += ",有未成年子女";
}
}
}
}
if (Math.Abs(Ages[0] - Ages[1]) >= 18 &&
Math.Abs(Ages[2] - Ages[1]) >= 18 &&
Math.Abs(Ages[0] - Ages[2]) >= 18)
{
Tag.FamilyStatus = "3人,三代人";
if (MinAge < 18)
{
Tag.FamilyStatus += ",有未成年子女";
}
}
}
//4人情况
if (Ages.Count == 4)
{
if (MaxAge - MinAge < 18)
{
Tag.FamilyStatus = "4人,一代人";
}
//排序,从小到大
List <int> SortedAges = Ages.ToList <int>();
SortedAges.Sort();
if (SortedAges[3] - SortedAges[0] >= 18 &&
SortedAges[3] - SortedAges[2] < 18 &&
SortedAges[1] - SortedAges[0] < 18)
{
Tag.FamilyStatus = "4人,两代人";
}
if (SortedAges[3] - SortedAges[0] >= 18 && (
(SortedAges[3] - SortedAges[2] < 18 && SortedAges[2] - SortedAges[1] >= 18 &&
SortedAges[1] - SortedAges[0] >= 18) ||
(SortedAges[3] - SortedAges[2] >= 18 && SortedAges[2] - SortedAges[1] >= 18 &&
SortedAges[1] - SortedAges[0] < 18)))
{
Tag.FamilyStatus = "4人,三代人";
}
if (SortedAges[3] - SortedAges[2] >= 18 && SortedAges[2] - SortedAges[1] >= 18 &&
SortedAges[1] - SortedAges[0] >= 18)
{
Tag.FamilyStatus = "4人,四代人";
}
}
if (Ages.Count > 5)
{
Tag.FamilyStatus = "多人共同居住";
}
}
//需求和成交记录
for (int i = 0; i < ResultSet.Tables[0].Rows.Count; i++)
{
DemandInfo DI = new DemandInfo();
DateTime DemandTime;
if (DateTime.TryParse(ResultSet.Tables[0].Rows[i]["demand_time"].ToString(), out DemandTime) == false)
{
continue;
}
//保护最近180天需求数据
//if ((DateTime.Now - DemandTime).TotalDays <= 180)
//{
// continue;
//}
DI.DemandDate = DemandTime.ToString("yyyy-MM-dd");
DI.DemandCity = ResultSet.Tables[0].Rows[i]["city"].ToString();
DI.DemandGrade = ResultSet.Tables[0].Rows[i]["buy_grade"].ToString();
DI.DemandProject = ResultSet.Tables[0].Rows[i]["project_name"].ToString();
DI.DemandPurpose = ResultSet.Tables[0].Rows[i]["buy_purpose"].ToString();
//查重
bool IsExisted = false;
for (int j = 0; j < Tag.DemandInfos.Count; j++)
{
if (Tag.DemandInfos[j].DemandCity == DI.DemandCity &&
Tag.DemandInfos[j].DemandDate == DI.DemandDate &&
Tag.DemandInfos[j].DemandGrade == DI.DemandGrade &&
Tag.DemandInfos[j].DemandProject == DI.DemandProject &&
Tag.DemandInfos[j].DemandPurpose == DI.DemandPurpose)
{
IsExisted = true;
break;
}
}
if (!IsExisted)
{
Tag.DemandInfos.Add(DI);
}
}
for (int i = 0; i < ResultSet.Tables[1].Rows.Count; i++)
{
TradeInfo TI = new TradeInfo();
DateTime TradeTime;
if (DateTime.TryParse(ResultSet.Tables[1].Rows[i]["trade_date"].ToString(), out TradeTime) == false)
{
continue;
}
//保护最近720天成交数据
//if ((DateTime.Now - TradeTime).TotalDays <= 720)
//{
// continue;
//}
TI.TradeDate = TradeTime.ToString("yyyy-MM-dd");
TI.TradeCity = ResultSet.Tables[1].Rows[i]["trade_city"].ToString();
TI.TradeGrade = ResultSet.Tables[1].Rows[i]["trade_project_grade"].ToString();
TI.TradeProject = ResultSet.Tables[1].Rows[i]["trade_project_name"].ToString();
TI.TradePurpose = ResultSet.Tables[1].Rows[i]["trade_project_purpose"].ToString();
bool IsExisted = false;
for (int j = 0; j < Tag.TradeInfos.Count; j++)
{
if (Tag.TradeInfos[j].TradeCity == TI.TradeCity &&
Tag.TradeInfos[j].TradeDate == TI.TradeDate &&
Tag.TradeInfos[j].TradeGrade == TI.TradeGrade &&
Tag.TradeInfos[j].TradeProject == TI.TradeProject &&
Tag.TradeInfos[j].TradePurpose == TI.TradePurpose)
{
IsExisted = true;
break;
}
}
if (!IsExisted)
{
Tag.TradeInfos.Add(TI);
}
}
return(0);
}
/// <summary>
/// 确认上线
/// </summary>
/// <param name="objDemand"></param>
/// <returns></returns>
public int UpLineDemand(DemandInfo objDemand)
{
return(new DAL.DemandService().UpLineDemand(objDemand));
}
