/// <summary> /// 获得数据列表 /// </summary> public List <Model.member_exit_family> GetList(int account_id, int Top) { List <Model.member_exit_family> modelList = new List <Model.member_exit_family>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select "); if (Top > 0) { strSql.Append(" top " + Top.ToString()); } strSql.Append(" id,member_id,name,gender,relationship,birthday,education "); strSql.Append(" FROM member_exit_family "); strSql.Append(" where member_id=" + account_id); DataTable dt = DbHelperSQL.Query(strSql.ToString()).Tables[0]; int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.member_exit_family model; for (int n = 0; n < rowsCount; n++) { model = new Model.member_exit_family(); if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } if (dt.Rows[n]["member_id"] != null && dt.Rows[n]["member_id"].ToString() != "") { model.member_id = int.Parse(dt.Rows[n]["member_id"].ToString()); } if (dt.Rows[n]["name"] != null && dt.Rows[n]["name"].ToString() != "") { model.name = dt.Rows[n]["name"].ToString(); } if (dt.Rows[n]["gender"] != null && dt.Rows[n]["gender"].ToString() != "") { model.gender = dt.Rows[n]["gender"].ToString(); } if (dt.Rows[n]["relationship"] != null && dt.Rows[n]["relationship"].ToString() != "") { model.relationship = dt.Rows[n]["relationship"].ToString(); } if (dt.Rows[n]["birthday"] != null && dt.Rows[n]["birthday"].ToString() != "") { model.birthday = dt.Rows[n]["birthday"].ToString(); } if (dt.Rows[0]["education"].ToString() != "") { model.education = dt.Rows[n]["education"].ToString(); } modelList.Add(model); } } return(modelList); }
private bool DoEdit(int _id) { bool result = false; BLL.member_exit bll = new BLL.member_exit(); Model.member_exit model = bll.GetModel(_id); model.town = ddlTown.SelectedValue.ToString(); model.village = ddlVillage.SelectedValue.ToString(); model.address = txtAddress.Text.Trim(); model.no = txtNo.Text.Trim(); model.name = txtName.Text.Trim(); model.gender = rblGender.SelectedValue.ToString(); model.birthday = txtBirthday.Text.Trim(); model.education = ddlEducation.SelectedValue.ToString(); model.id_card = txtIdCard.Text.Trim(); model.amount = Utils.StrToDecimal(txtAmount.Text, 0); model.add_time = Utils.StrToDateTime(txtAddTime.Text.Trim()); if (model.town == "0") { JscriptMsg("请填写所属乡镇!", ""); return(false); } if (model.village == "0") { JscriptMsg("请填写所属村庄!", ""); return(false); } if (string.IsNullOrEmpty(model.no)) { JscriptMsg("请填写会员编号!", ""); return(false); } if (string.IsNullOrEmpty(model.name)) { JscriptMsg("请填写姓名!", ""); return(false); } List <Model.member_exit_family> ls = new List <Model.member_exit_family>(); var familyModel = new Model.member_exit_family(); if (!string.IsNullOrEmpty(txtFamilyName1.Text.Trim())) { familyModel.name = txtFamilyName1.Text.Trim(); familyModel.gender = ddlFamilyGender1.SelectedValue.ToString(); familyModel.relationship = txtFamilyRel1.Text.Trim(); familyModel.birthday = txtFamilyBir1.Text.Trim(); familyModel.education = ddlFamilyEdu1.SelectedValue.ToString(); ls.Add(familyModel); } if (!string.IsNullOrEmpty(txtFamilyName2.Text.Trim())) { familyModel.name = txtFamilyName2.Text.Trim(); familyModel.gender = ddlFamilyGender2.SelectedValue.ToString(); familyModel.relationship = txtFamilyRel2.Text.Trim(); familyModel.birthday = txtFamilyBir2.Text.Trim(); familyModel.education = ddlFamilyEdu2.SelectedValue.ToString(); ls.Add(familyModel); } if (!string.IsNullOrEmpty(txtFamilyName3.Text.Trim())) { familyModel.name = txtFamilyName3.Text.Trim(); familyModel.gender = ddlFamilyGender3.SelectedValue.ToString(); familyModel.relationship = txtFamilyRel3.Text.Trim(); familyModel.birthday = txtFamilyBir3.Text.Trim(); familyModel.education = ddlFamilyEdu3.SelectedValue.ToString(); ls.Add(familyModel); } model.family = ls; if (bll.Update(model)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改协会会员:" + model.no); //记录日志 result = true; } return(result); }