public async Task <IActionResult> Modify(Txry_Person person) { string sql = @"Update Txry_Person Set Person_Name = :person_name, Sex = :sex, Age = :age, Phone = :phone, Id_Card_Number = :id_card_number, National = :national, Political_Landscape = :political_landscape, Long_Term_Residence = :long_term_residence, Domicile_Place = :domicile_place, Special_Person = :special_person, Health = :health, e_i_Address = :e_i_address, Medical_i_Address = :medical_i_address, Is_Gsbx = :is_gsbx, Living_Situation = :living_situation, Spouse_Name = :spouse_name, Spouse_Health = :spouse_health, Spouse_Phone = :spouse_phone, Family_Major_Person_Name = :family_major_person_name, Family_Major_p_Relationship = :family_major_p_relationship, Family_Major_Person_Address = :family_major_person_address, Family_Major_Person_Phone = :family_major_person_phone, Registered_Image_First = :registered_image_first, Registered_Image_Self = :registered_image_self, Status = 1, Emergency_Person = :emergency_person, Emergency_Phone = :emergency_phone, Emergency_Address = :emergency_address, Transfer_Type = :transfer_type Where Person_Id = :person_id"; OracleParameter[] sp = { data.MakeInParam(":person_name", person.PERSON_NAME ?? ""), data.MakeInParam(":sex", person.SEX ?? ""), data.MakeInParam(":age", person.AGE ?? ""), data.MakeInParam(":phone", person.PHONE ?? ""), data.MakeInParam(":id_card_number", person.ID_CARD_NUMBER ?? ""), data.MakeInParam(":national", person.NATIONAL ?? ""), data.MakeInParam(":political_landscape", person.POLITICAL_LANDSCAPE ?? ""), data.MakeInParam(":long_term_residence", person.LONG_TERM_RESIDENCE ?? ""), data.MakeInParam(":domicile_place", person.DOMICILE_PLACE ?? ""), data.MakeInParam(":special_person", person.SPECIAL_PERSON ?? ""), data.MakeInParam(":health", person.HEALTH ?? ""), data.MakeInParam(":e_i_address", person.E_I_ADDRESS ?? ""), data.MakeInParam(":medical_i_address", person.MEDICAL_I_ADDRESS ?? ""), data.MakeInParam(":is_gsbx", person.IS_GSBX ?? ""), data.MakeInParam(":living_situation", person.LIVING_SITUATION ?? ""), data.MakeInParam(":spouse_name", person.SPOUSE_NAME ?? ""), data.MakeInParam(":spouse_health", person.SPOUSE_HEALTH ?? ""), data.MakeInParam(":spouse_phone", person.SPOUSE_PHONE ?? ""), data.MakeInParam(":family_major_person_name", person.FAMILY_MAJOR_PERSON_NAME ?? ""), data.MakeInParam(":family_major_p_relationship", person.FAMILY_MAJOR_P_RELATIONSHIP ?? ""), data.MakeInParam(":family_major_person_address", person.FAMILY_MAJOR_PERSON_ADDRESS ?? ""), data.MakeInParam(":family_major_person_phone", person.FAMILY_MAJOR_PERSON_PHONE ?? ""), data.MakeInParam(":registered_image_first", person.REGISTERED_IMAGE_FIRST ?? ""), data.MakeInParam(":registered_image_self", person.REGISTERED_IMAGE_SELF ?? ""), data.MakeInParam(":emergency_person", person.EMERGENCY_PERSON ?? ""), data.MakeInParam(":emergency_phone", person.EMERGENCY_PHONE ?? ""), data.MakeInParam(":emergency_address", person.EMERGENCY_ADDRESS ?? ""), data.MakeInParam(":transfer_type", person.TRANSFER_TYPE ?? ""), data.MakeInParam(":person_id", person.PERSON_ID ?? "") }; bool flag = await data.DoSqlByParam(sql, sp); //var json = flag == true ? new { code = 0, msg = "核验成功" } : new { code = 1, msg = "核验失败,请联系管理员" }; return(Json(flag == true ? new { code = 0, msg = "核验成功" } : new { code = 1, msg = "核验失败,请联系管理员" })); }
public async Task <IActionResult> Login(Txry_Person person) { #region sql string sql = @"select PERSON_ID, PERSON_NAME, SEX, AGE, PHONE, ID_CARD_NUMBER, NATIONAL, POLITICAL_LANDSCAPE, LONG_TERM_RESIDENCE, DOMICILE_PLACE, SPECIAL_PERSON, HEALTH, E_I_ADDRESS, MEDICAL_I_ADDRESS, IS_GSBX, LIVING_SITUATION, SPOUSE_NAME, SPOUSE_HEALTH, SPOUSE_PHONE, FAMILY_MAJOR_PERSON_NAME, FAMILY_MAJOR_P_RELATIONSHIP, FAMILY_MAJOR_PERSON_ADDRESS, FAMILY_MAJOR_PERSON_PHONE, STATUS, EMERGENCY_PERSON, EMERGENCY_PHONE, EMERGENCY_ADDRESS, TRANSFER_TYPE from txry_person t Where t.person_name=:person_name And t.id_card_number=:id_card_number"; #endregion OracleParameter[] p = { data.MakeInParam(":person_name", person.PERSON_NAME ?? ""), data.MakeInParam(":id_card_number", person.ID_CARD_NUMBER ?? "") }; try { DataSet ds = await data.GetDataSetByParam(sql, p); if (ds.Tables[0].Rows.Count > 0) { //if (ds.Tables[0].Rows[0]["STATUS"].ToString() !="2") //{ string json = "[" + JsonTools.DataTableToJson(ds.Tables[0]) + "]"; return(Json(new { code = 0, msg = "已查询到数据", count = ds.Tables[0].Rows.Count, data = json.ToJson() })); //} //else //{ // return Json(new { code = 2, msg = "信息已通过复核,无法再进行修改" }); //} } else { return(Json(new { code = 1, msg = "检索不到你的身份信息,请与员工服务中心联系,联系电话:8798509、8788390。" })); } } catch (System.Exception ex) { return(Json(new { code = 1, msg = ex.Message })); } }