private void ShowInfo(int _id)
{
BLL.member_exit bll = new BLL.member_exit();
Model.member_exit model = bll.GetModel(_id);
ddlTown.SelectedValue = model.town.ToString();
ddlVillage.SelectedValue = model.village.ToString();
txtAddress.Text = model.address;
txtNo.Text = model.no;
txtNo.ReadOnly = true;
txtName.Text = model.name;
rblGender.SelectedValue = model.gender.ToString();
txtBirthday.Text = model.birthday.ToString();
ddlEducation.SelectedValue = model.education;
txtIdCard.Text = model.id_card;
txtAmount.Text = model.amount.ToString();
for (int i = 1; i < model.family.Count + 1; i++)
{
TextBox txtFamilyName = FindControl("txtFamilyName" + i) as TextBox;
DropDownList ddlFamilyGender = FindControl("ddlFamilyGender" + i) as DropDownList;
TextBox txtFamilyRel = FindControl("txtFamilyRel" + i) as TextBox;
TextBox txtFamilyBir = FindControl("txtFamilyBir" + i) as TextBox;
DropDownList ddlFamilyEdu = FindControl("ddlFamilyEdu" + i) as DropDownList;
var current = model.family[i - 1];
txtFamilyName.Text = current.name;
ddlFamilyGender.SelectedValue = current.gender;
txtFamilyRel.Text = current.relationship;
txtFamilyBir.Text = current.birthday;
ddlFamilyEdu.SelectedValue = current.education;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.member_exit GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from member_exit ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Model.member_exit model = new Model.member_exit();
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(Model.member_exit model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
#region 添加主表数据====================
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into member_exit(");
strSql.Append("no,town,village,address,name,gender,birthday,education,id_card,amount,add_time,status)");
strSql.Append(" values (");
strSql.Append("@no,@town,@village,@address,@name,@gender,@birthday,@education,@id_card,@amount,@add_time,@status)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@no", SqlDbType.NVarChar, 50),
new SqlParameter("@town", SqlDbType.NVarChar, 50),
new SqlParameter("@village", SqlDbType.NVarChar, 50),
new SqlParameter("@address", SqlDbType.NVarChar, 50),
new SqlParameter("@name", SqlDbType.NVarChar, 50),
new SqlParameter("@gender", SqlDbType.NVarChar, 50),
new SqlParameter("@birthday", SqlDbType.NVarChar, 50),
new SqlParameter("@education", SqlDbType.NVarChar, 50),
new SqlParameter("@id_card", SqlDbType.NVarChar, 50),
new SqlParameter("@amount", SqlDbType.Decimal, 9),
new SqlParameter("@add_time", SqlDbType.DateTime),
new SqlParameter("@status", SqlDbType.TinyInt)
};
parameters[0].Value = model.no;
parameters[1].Value = model.town;
parameters[2].Value = model.village;
parameters[3].Value = model.address;
parameters[4].Value = model.name;
parameters[5].Value = model.gender;
parameters[6].Value = model.birthday;
parameters[7].Value = model.education;
parameters[8].Value = model.id_card;
parameters[9].Value = model.amount;
parameters[10].Value = model.add_time;
parameters[11].Value = model.status;
//添加主表数据
object obj = DbHelperSQL.GetSingle(conn, trans, strSql.ToString(), parameters); //带事务
model.id = Convert.ToInt32(obj);
#endregion
#region 添加家庭成员====================
if (model.family != null)
{
StringBuilder strSql3;
foreach (Model.member_exit_family modelt in model.family)
{
strSql3 = new StringBuilder();
strSql3.Append("insert into member_exit_family(");
strSql3.Append("member_id,name,gender,relationship,birthday,education)");
strSql3.Append(" values (");
strSql3.Append("@member_id,@name,@gender,@relationship,@birthday,@education)");
SqlParameter[] parameters3 =
{
new SqlParameter("@member_id", SqlDbType.Int, 4),
new SqlParameter("@name", SqlDbType.NVarChar, 50),
new SqlParameter("@gender", SqlDbType.NVarChar, 50),
new SqlParameter("@relationship", SqlDbType.NVarChar, 50),
new SqlParameter("@birthday", SqlDbType.NVarChar, 50),
new SqlParameter("@education", SqlDbType.NVarChar, 50)
};
parameters3[0].Value = model.id;
parameters3[1].Value = modelt.name;
parameters3[2].Value = modelt.gender;
parameters3[3].Value = modelt.relationship;
parameters3[4].Value = modelt.birthday;
parameters3[4].Value = modelt.education;
DbHelperSQL.GetSingle(conn, trans, strSql3.ToString(), parameters3); //带事务
}
}
#endregion
trans.Commit();
}
catch
{
trans.Rollback();
return(0);
}
}
}
return(model.id);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.member_exit DataRowToModel(DataRow row)
{
Model.member_exit model = new Model.member_exit();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["no"] != null)
{
model.no = row["no"].ToString();
}
if (row["town"] != null)
{
model.town = row["town"].ToString();
}
if (row["village"] != null)
{
model.village = row["village"].ToString();
}
if (row["address"] != null)
{
model.address = row["address"].ToString();
}
if (row["name"] != null)
{
model.name = row["name"].ToString();
}
if (row["gender"] != null)
{
model.gender = row["gender"].ToString();
}
if (row["birthday"] != null)
{
model.birthday = row["birthday"].ToString();
}
if (row["education"] != null)
{
model.education = row["education"].ToString();
}
if (row["id_card"] != null)
{
model.id_card = row["id_card"].ToString();
}
if (row["amount"] != null && row["amount"].ToString() != "")
{
model.amount = decimal.Parse(row["amount"].ToString());
}
if (row["add_time"] != null && row["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(row["add_time"].ToString());
}
if (row["status"] != null && row["status"].ToString() != "")
{
model.status = int.Parse(row["status"].ToString());
}
model.family = new member_exit_family().GetList(model.id, 0);
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.member_exit model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
#region 修改主表数据==========================
StringBuilder strSql = new StringBuilder();
strSql.Append("update member_exit set ");
strSql.Append("no=@no,");
strSql.Append("town=@town,");
strSql.Append("village=@village,");
strSql.Append("address=@address,");
strSql.Append("name=@name,");
strSql.Append("gender=@gender,");
strSql.Append("birthday=@birthday,");
strSql.Append("education=@education,");
strSql.Append("id_card=@id_card,");
strSql.Append("amount=@amount,");
strSql.Append("add_time=@add_time,");
strSql.Append("status=@status");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@no", SqlDbType.NVarChar, 50),
new SqlParameter("@town", SqlDbType.NVarChar, 50),
new SqlParameter("@village", SqlDbType.NVarChar, 50),
new SqlParameter("@address", SqlDbType.NVarChar, 50),
new SqlParameter("@name", SqlDbType.NVarChar, 50),
new SqlParameter("@gender", SqlDbType.NVarChar, 50),
new SqlParameter("@birthday", SqlDbType.NVarChar, 50),
new SqlParameter("@education", SqlDbType.NVarChar, 50),
new SqlParameter("@id_card", SqlDbType.NVarChar, 50),
new SqlParameter("@amount", SqlDbType.Decimal, 9),
new SqlParameter("@add_time", SqlDbType.DateTime),
new SqlParameter("@status", SqlDbType.TinyInt),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.no;
parameters[1].Value = model.town;
parameters[2].Value = model.village;
parameters[3].Value = model.address;
parameters[4].Value = model.name;
parameters[5].Value = model.gender;
parameters[6].Value = model.birthday;
parameters[7].Value = model.education;
parameters[8].Value = model.id_card;
parameters[9].Value = model.amount;
parameters[10].Value = model.add_time;
parameters[11].Value = model.status;
parameters[12].Value = model.id;
DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);
#endregion
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.member_exit model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.member_exit model)
{
return(dal.Add(model));
}
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);
}
