/// <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);
}
