/// <summary>
/// 增加一行基本表信息
/// </summary>
/// <param name="Base">基本表信息实体类</param>
/// <returns>成功返回BaseId 否则返回0</returns>
public static int AddBase(BaseEntity Base, string TableName)
{
int iExecute = 0;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BaseInfo(");
strSql.Append("Fid,Name,IdCard,Home,StreetId,CommunityId,Bz_Master,Bz_DiBao,AppId_DiBao)");
strSql.Append(" values (");
strSql.Append("@Fid,@Name,@IdCard,@Home,@StreetId,@CommunityId,@Bz_Master,@Bz_DiBao,@AppId_DiBao)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Fid", SqlDbType.Int),
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@IdCard", SqlDbType.NVarChar,50),
new SqlParameter("@Home", SqlDbType.NVarChar,50),
new SqlParameter("@StreetId", SqlDbType.Int),
new SqlParameter("@CommunityId", SqlDbType.Int),
new SqlParameter("@Bz_Master", SqlDbType.Int),
new SqlParameter("@Bz_DiBao", SqlDbType.Int),
new SqlParameter("@AppId_DiBao", SqlDbType.Int)
};
parameters[0].Value = Base.Fid;
parameters[1].Value = Base.Name;
parameters[2].Value = Base.IdCard;
parameters[3].Value = Base.Home;
parameters[4].Value = Base.StreetId;
parameters[5].Value = Base.CommunityId;
parameters[6].Value = Base.Bz_Master;
parameters[7].Value = Base.Bz_DiBao;
parameters[8].Value = Base.AppId_DiBao;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj != null)
{
iExecute = Convert.ToInt32(obj);
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "Controler.Ctrl_Approve.AddUser:" + e.Message);
}
return iExecute;
}
/// <summary>
/// 添加信息至基本表
/// </summary>
/// <returns></returns>
private bool AddBaseInfo()
{
bool bz = true;
BaseEntity Base = new BaseEntity();
DataTable dt = CopyFormData();
DataSet ds = new DataSet();
ds.Merge(dt);
int MasterId = int.Parse(drpMaster.SelectedValue) - 1;//获取户主所在行Id
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Base.Fid = int.Parse(hdFid.Value);
Base.StreetId = int.Parse(drpStreet.SelectedValue);
Base.CommunityId = int.Parse(drpCommunity.SelectedValue);
Base.Home = txtHome.Text;
Base.Bz_DiBao = 1;
if (i == MasterId)
Base.Bz_Master = 1;
else
Base.Bz_Master = 0;
Base.Name = ds.Tables[0].Rows[i]["Name"].ToString();
Base.AppId_DiBao =int.Parse(ds.Tables[0].Rows[i]["ID"].ToString());
Base.IdCard = ds.Tables[0].Rows[i]["IdCard"].ToString();
Base.AppId_DiBao = int.Parse(ds.Tables[0].Rows[i]["DiBaoId"].ToString());
if (Ctrl_Base.AddBaseWithReady(Base, "DiBao", 0, true) == 0)
bz = false;
}
return bz;
}
/// <summary>
/// 增加一行基本表信息并将户主信息写入项目待入库表
/// </summary>
/// <param name="Base">基本表信息实体类</param>
/// <returns>成功返回1 否则返回0</returns>
public static int AddBaseWithReady(BaseEntity Base, string TableName, int Bz_Cz, bool IsDiBao)
{
int iExecute = 0;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BaseInfo(");
strSql.Append("Fid,Name,IdCard,Home,StreetId,CommunityId,Bz_Master,Bz_DiBao,AppId_DiBao,Bz_DiShouRu,AppId_DiShouRu,Bz_TempHelp,AppId_TempHelp)");
strSql.Append(" values (");
strSql.Append("@Fid,@Name,@IdCard,@Home,@StreetId,@CommunityId,@Bz_Master,@Bz_DiBao,@AppId_DiBao,@Bz_DiShouRu,@AppId_DiShouRu,@Bz_TempHelp,@AppId_TempHelp)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Fid", SqlDbType.Int),
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@IdCard", SqlDbType.NVarChar,50),
new SqlParameter("@Home", SqlDbType.NVarChar,50),
new SqlParameter("@StreetId", SqlDbType.Int),
new SqlParameter("@CommunityId", SqlDbType.Int),
new SqlParameter("@Bz_Master", SqlDbType.Int),
new SqlParameter("@Bz_DiBao", SqlDbType.Int),
new SqlParameter("@AppId_DiBao", SqlDbType.Int),
new SqlParameter("@Bz_DiShouRu", SqlDbType.Int),
new SqlParameter("@AppId_DiShouRu", SqlDbType.Int),
new SqlParameter("@Bz_TempHelp", SqlDbType.Int),
new SqlParameter("@AppId_TempHelp", SqlDbType.Int)
};
parameters[0].Value = Base.Fid;
parameters[1].Value = Base.Name;
parameters[2].Value = Base.IdCard;
parameters[3].Value = Base.Home;
parameters[4].Value = Base.StreetId;
parameters[5].Value = Base.CommunityId;
parameters[6].Value = Base.Bz_Master;
parameters[7].Value = Base.Bz_DiBao;
parameters[8].Value = Base.AppId_DiBao;
parameters[9].Value = Base.Bz_DiShouRu;
parameters[10].Value = Base.AppId_DiShouRu;
parameters[11].Value = Base.Bz_TempHelp;
parameters[12].Value = Base.AppId_TempHelp;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj != null)
{
iExecute = Convert.ToInt32(obj);
}
if (Base.Bz_Master == 1)//如果录入的是户主
{
string sql = "";
if (IsDiBao)
sql = "insert into " + TableName + "_Ready (BaseFid,Bz_Cz) values (" + Base.Fid + "," + Bz_Cz + ")";
else
sql = "insert into " + TableName + "_Ready (BaseFid) values (" + Base.Fid + ")";
DbHelperSQL.ExecuteSql(sql);
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "Controler.Ctrl_Approve.AddUser:" + e.Message);
}
return iExecute;
}
/// <summary>
/// 获取家庭基本信息
/// </summary>
/// <param name="Fid">家庭Id</param>
/// <returns></returns>
public static BaseEntity GetBaseFamilyInfo(int Fid)
{
BaseEntity BaseInfo = new BaseEntity();
DataSet ds = new DataSet();
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,Fid,Bz_DiBao");
strSql.Append(" from BaseInfo");
strSql.Append(" where Bz_Master=1 and Fid=" + Fid);
ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
BaseInfo.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["Fid"] != null && ds.Tables[0].Rows[0]["Fid"].ToString() != "")
{
BaseInfo.Fid = int.Parse(ds.Tables[0].Rows[0]["Fid"].ToString());
}
//if (ds.Tables[0].Rows[0]["Reason_Community"] != null && ds.Tables[0].Rows[0]["Reason_Community"].ToString() != "")
//{
// BaseInfo.Reason_Community = ds.Tables[0].Rows[0]["Reason_Community"].ToString();
//}
//if (ds.Tables[0].Rows[0]["Reason_Office"] != null && ds.Tables[0].Rows[0]["Reason_Office"].ToString() != "")
//{
// BaseInfo.Reason_Office = ds.Tables[0].Rows[0]["Reason_Office"].ToString();
//}
//if (ds.Tables[0].Rows[0]["Reason_Civil"] != null && ds.Tables[0].Rows[0]["Reason_Civil"].ToString() != "")
//{
// BaseInfo.Reason_Civil = ds.Tables[0].Rows[0]["Reason_Civil"].ToString();
//}
//if (ds.Tables[0].Rows[0]["Bz_Result_Community"] != null && ds.Tables[0].Rows[0]["Bz_Result_Community"].ToString() != "")
//{
// BaseInfo.Bz_Result_Community = int.Parse(ds.Tables[0].Rows[0]["Bz_Result_Community"].ToString());
//}
//if (ds.Tables[0].Rows[0]["Bz_Result_Office"] != null && ds.Tables[0].Rows[0]["Bz_Result_Office"].ToString() != "")
//{
// BaseInfo.Bz_Result_Office = int.Parse(ds.Tables[0].Rows[0]["Bz_Result_Office"].ToString());
//}
//if (ds.Tables[0].Rows[0]["Bz_Result_Civil"] != null && ds.Tables[0].Rows[0]["Bz_Result_Civil"].ToString() != "")
//{
// BaseInfo.Bz_Result_Civil = int.Parse(ds.Tables[0].Rows[0]["Bz_Result_Civil"].ToString());
//}
if (ds.Tables[0].Rows[0]["Bz_DiBao"] != null && ds.Tables[0].Rows[0]["Bz_DiBao"].ToString() != "")
{
BaseInfo.Bz_DiBao = int.Parse(ds.Tables[0].Rows[0]["Bz_DiBao"].ToString());
}
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\GetPageUserInfoList" + e.Message);
}
return BaseInfo;
}
/// <summary>
/// 保存按钮点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
TempHelp_Info tempHelpInfo = new TempHelp_Info();
tempHelpInfo.Name = txtName.Text;
tempHelpInfo.IdCard = txtIdCard.Text;
tempHelpInfo.Bz_Approver = cbApprover.Checked ? 1 : 0;
tempHelpInfo.Bz_BaoZhang = cbBaoZhang.Checked ? 1 : 0;
// tempHelpInfo.Bz_Cz = cbCz.Checked ? 1 : 0;
tempHelpInfo.Bz_Master = cbMaster.Checked ? 1 : 0;
tempHelpInfo.StreetId = int.Parse(drpStreet.SelectedValue);
tempHelpInfo.CommunityId = int.Parse(drpCommunity.SelectedValue);
tempHelpInfo.Address = txtAddress.Text;
tempHelpInfo.Home = txtHome.Text;
tempHelpInfo.Tel1 = txtTel1.Text;
tempHelpInfo.Tel2 = txtTel2.Text;
tempHelpInfo.House = txtHouse.Text;
tempHelpInfo.Square = txtSquare.Text;
tempHelpInfo.Sex = drpSex.SelectedItem.Text;
tempHelpInfo.Birth = DateTime.Parse(txtBirth.Text);
tempHelpInfo.ClassId = int.Parse(drpClass.SelectedValue);
tempHelpInfo.JobId = int.Parse(drpJob.SelectedValue);
tempHelpInfo.Health = txtHealth.Text;
tempHelpInfo.Car = txtCar.Text;
tempHelpInfo.Bz_Retire = cbRetire.Checked ? 1 : 0;
tempHelpInfo.AppReason = txtAppReason.Value.ToString();
int MyId;
if (!int.TryParse(txtFamNum.Text.ToString(), out MyId))
{
MessageBox.Show(this, "手动户编号不能为空");
return;
}
else
{
tempHelpInfo.MyFid = MyId;
}
if (cbRetire.Checked)
{
if (txtRetire.Text == "")
{
MessageBox.Show(this, "已退休人员的退休日期不能为空！");
return;
}
tempHelpInfo.RetireTime = DateTime.Parse(txtRetire.Text);
}
else
{
tempHelpInfo.RetireTime = null;
}
tempHelpInfo.Bz_Dead = cbDead.Checked ? 1 : 0;
if (cbDead.Checked)
{
if (txtDead.Text == "")
{
MessageBox.Show(this, "已死亡人员的死亡日期不能为空！");
return;
}
tempHelpInfo.DeadTime = DateTime.Parse(txtDead.Text);
}
else
{
tempHelpInfo.DeadTime = null;
}
tempHelpInfo.Wage = txtWage.Text;
DateTime oneTime = new DateTime();
if (DateTime.TryParse(txtOneTime.Text, out oneTime))
{
tempHelpInfo.OneTime = oneTime;
}
else
{
tempHelpInfo.OneTime = DateTime.Now;
}
if (txtMoney.Text == "")
{
tempHelpInfo.Money = 0;
}
else
{
tempHelpInfo.Money = decimal.Parse(txtMoney.Text);
}
tempHelpInfo.State = cbState.Checked ? 0 : 1;
if (hdId.Value == "0")//添加
{
if (hdDiBaoId.Value != "0")//如果是待入库表添加
{
tempHelpInfo.BaseId = int.Parse(hdBaseId.Value);
tempHelpInfo.Fid = int.Parse(hdFid.Value);
if (Ctrl_Ass_TempHelp.AddTempHelpInfo(tempHelpInfo) > 0)
{
Ctrl_Base.UpdateBaseInfoWithTableName(tempHelpInfo.BaseId, "TempHelp", 2);
MessageBox.ShowAndRedirect(this, "添加成功！", ViewState["BackUrl"].ToString());
}
else
MessageBox.Show(this, "添加失败！");
}
else//直接添加
{
if (hdFid.Value == "0")//添加一户
{
//写入基本表
BaseEntity BaseInfo = new BaseEntity();
BaseInfo.AppId_TempHelp = 0;//非审批途径进入基本表
BaseInfo.Bz_TempHelp = 2;//更改低保标记为在发
BaseInfo.Bz_Master = cbMaster.Checked ? 1 : 0;
BaseInfo.CommunityId = int.Parse(drpCommunity.SelectedValue);
BaseInfo.Home = txtHome.Text;
BaseInfo.IdCard = txtIdCard.Text;
BaseInfo.Name = txtName.Text;
BaseInfo.StreetId = int.Parse(drpStreet.SelectedValue);
BaseInfo.Fid = Ctrl_Counter.GetCounter_Fid();//获取Fid
tempHelpInfo.Fid = BaseInfo.Fid;
tempHelpInfo.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
tempHelpInfo.BaseId = CommonHelp.AddBase(BaseInfo, "TempHelp");//信息写入基本表并返回基本表Id
if (Ctrl_Ass_TempHelp.AddTempHelpInfo(tempHelpInfo) > 0)
{
Ctrl_Base.UpdateBaseInfoWithTableName(tempHelpInfo.BaseId, "TempHelp", 2);
//MessageBox.ShowAndRedirect(this, "添加成功！是否继续添加家庭成员？", ViewState["BackUrl"].ToString());
//if (tempHelpInfo.Fid > 0)
//{
// Page.ClientScript.RegisterStartupScript(this.GetType(), "js", "fnAddFamConfirm(" + tempHelpInfo.Fid + ",'" + ViewState["BackUrl"].ToString() + "');", true);
//}
MessageBox.ShowAndRedirect(this, "添加成功", "TempHelp_Fam.aspx?Fid=" + tempHelpInfo.Fid);
}
else
MessageBox.Show(this, "添加失败！");
}
else
{
//写入基本表
BaseEntity BaseInfo = new BaseEntity();
BaseInfo.AppId_TempHelp = 0;//非审批途径进入基本表
BaseInfo.Bz_DiBao = 2;//更改低保标记为在发
BaseInfo.Bz_Master = cbMaster.Checked ? 1 : 0;
BaseInfo.CommunityId = int.Parse(drpCommunity.SelectedValue);
BaseInfo.Home = txtHome.Text;
BaseInfo.IdCard = txtIdCard.Text;
BaseInfo.Name = txtName.Text;
BaseInfo.StreetId = int.Parse(drpStreet.SelectedValue);
BaseInfo.Fid = int.Parse(hdFid.Value);
tempHelpInfo.BaseId = Ctrl_Base.AddBase(BaseInfo, "TempHelpInfo");//信息写入基本表并返回基本表Id
tempHelpInfo.Fid = int.Parse(hdFid.Value);
if (Ctrl_Ass_TempHelp.AddTempHelpInfo(tempHelpInfo) > 0)
{
Ctrl_Base.UpdateBaseInfoWithTableName(tempHelpInfo.BaseId, "TempHelp", 2);
MessageBox.ShowAndRedirect(this, "添加成功！", ViewState["BackUrl"].ToString());
// Response.Write("<Script Language='JavaScript'>if ( window.confirm('添加成功，继续添加')) { window.location.href='" + ViewState["BackUrl"].ToString() +"' } else {window.location.href='" + ViewState["BackUrl"].ToString() + "' };</script>"); //如果成功则继续添加，不成功则返回页面主页（相应户为单位）
}
else
MessageBox.Show(this, "添加失败！");
}
}
}
else//修改
{
tempHelpInfo.Id = int.Parse(hdId.Value);
tempHelpInfo.BaseId = int.Parse(hdBaseId.Value);
tempHelpInfo.Fid = int.Parse(hdFid.Value);
if (cbState.Checked && txtStopReason.Enabled)//如果停发
{
if (string.IsNullOrEmpty(txtStopReason.Text))
{
MessageBox.Show(this, "停发原因不能为空！");
return;
}
Ctrl_Ass_TempHelp.AddStopReason(tempHelpInfo.Id, txtStopReason.Text);
}
if (Ctrl_Ass_TempHelp.UpdateTempHelp(tempHelpInfo))
MessageBox.ShowAndRedirect(this, "修改成功！", ViewState["BackUrl"].ToString());
else
MessageBox.Show(this, "修改失败！");
}
}
/// <summary>
/// 保存按钮点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
DiBao_Info DiBaoInfo = new DiBao_Info();
DiBaoInfo.Name = txtName.Text;
DiBaoInfo.IdCard = txtIdCard.Text;
DiBaoInfo.Bz_Approver = cbApprover.Checked ? 1 : 0;
DiBaoInfo.Bz_BaoZhang = cbBaoZhang.Checked ? 1 : 0;
DiBaoInfo.Bz_Cz = cbCz.Checked ? 1 : 0;
DiBaoInfo.Bz_Master = cbMaster.Checked ? 1 : 0;
DiBaoInfo.StreetId = int.Parse(drpStreet.SelectedValue);
DiBaoInfo.CommunityId = int.Parse(drpCommunity.SelectedValue);
DiBaoInfo.Address = txtAddress.Text;
DiBaoInfo.Home = txtHome.Text;
DiBaoInfo.Tel1 = txtTel1.Text;
DiBaoInfo.Tel2 = txtTel2.Text;
DiBaoInfo.House = txtHouse.Text;
DiBaoInfo.Square = txtSquare.Text;
DiBaoInfo.Sex = drpSex.SelectedItem.Text;
DiBaoInfo.Birth = DateTime.Parse(txtBirth.Text);
DiBaoInfo.TypeId = int.Parse(drpType.SelectedValue);
DiBaoInfo.ClassId = int.Parse(drpClass.SelectedValue);
DiBaoInfo.JobId = int.Parse(drpJob.SelectedValue);
DiBaoInfo.Health = txtHealth.Text;
DiBaoInfo.Car = txtCar.Text;
DiBaoInfo.Bank = txtBank.Text;
DiBaoInfo.Bz_Retire = cbRetire.Checked ? 1 : 0;
DiBaoInfo.AppReason = txtAppReason.Value;
DiBaoInfo.MyFid = int.Parse(txtFamNum.Text);
if (cbRetire.Checked)
{
if (txtRetire.Text == "")
{
MessageBox.Show(this, "已退休人员的退休日期不能为空！");
return;
}
DiBaoInfo.RetireTime = DateTime.Parse(txtRetire.Text);
}
else
{
DiBaoInfo.RetireTime = null;
}
DiBaoInfo.Bz_Dead = cbDead.Checked ? 1 : 0;
if (cbDead.Checked)
{
if (txtDead.Text == "")
{
MessageBox.Show(this, "已死亡人员的死亡日期不能为空！");
return;
}
DiBaoInfo.DeadTime = DateTime.Parse(txtDead.Text);
}
else
{
DiBaoInfo.DeadTime = null;
}
#region 判断时间输入是否合乎要求（在日历控件不好使的情况下判断）
DateTime lTime;
DateTime nTime;
if (DateTime.TryParse(txtCheckTime.Text, out lTime))
{
DiBaoInfo.CheckTime = lTime;
}
else
{
MessageBox.Show(this, "上次检查时间不正确");
return;
}
if (DateTime.TryParse(txtNextTime.Text, out nTime))
{
DiBaoInfo.NextTime = nTime;
}
else
{
MessageBox.Show(this, "下次检查时间不正确");
return;
}
#endregion
DiBaoInfo.Wage = txtWage.Text;
DiBaoInfo.Wage1 = txtWage1.Text;
DiBaoInfo.Wage2 = txtWage2.Text;
DiBaoInfo.Wage3 = txtWage3.Text;
DiBaoInfo.Wage4 = txtWage4.Text;
DiBaoInfo.Wage5 = txtWage5.Text;
DiBaoInfo.Wage6 = txtWage6.Text;
DiBaoInfo.OneMoney = txtOneMoney.Text;
DiBaoInfo.OneMonth = txtOneMonth.Text;
DiBaoInfo.OneTime = null;//农村低保不含此项，赋null值
if (txtMoney.Text == "")
{
DiBaoInfo.Money = 0;
}
else
{
DiBaoInfo.Money = decimal.Parse(txtMoney.Text);
}
DiBaoInfo.State = cbState.Checked ? 0 : 1;
if (hdId.Value == "0")//添加
{
if (hdDiBaoId.Value != "0")//如果是待入库表添加
{
DiBaoInfo.BaseId = int.Parse(hdBaseId.Value);
DiBaoInfo.Fid = int.Parse(hdFid.Value);
if (Ctrl_Ass_DiBao.AddDiBao(DiBaoInfo) > 0)
{
Ctrl_Base.UpdateBaseInfoWithTableName(DiBaoInfo.BaseId, "DiBao", 2);
MessageBox.ShowAndRedirect(this, "添加成功！", ViewState["BackUrl"].ToString());
}
else
MessageBox.Show(this, "添加失败！");
}
else//直接添加
{
if (hdFid.Value == "0")//添加一户
{
//写入基本表
BaseEntity BaseInfo = new BaseEntity();
BaseInfo.AppId_DiShouRu = 0;//非审批途径进入基本表
BaseInfo.Bz_DiBao = 2;//更改低保标记为在发
BaseInfo.Bz_Master = cbMaster.Checked ? 1 : 0;
BaseInfo.CommunityId = int.Parse(drpCommunity.SelectedValue);
BaseInfo.Home = txtHome.Text;
BaseInfo.IdCard = txtIdCard.Text;
BaseInfo.Name = txtName.Text;
BaseInfo.StreetId = int.Parse(drpStreet.SelectedValue);
BaseInfo.Fid = Ctrl_Counter.GetCounter_Fid();//获取Fid
DiBaoInfo.Fid = BaseInfo.Fid;
DiBaoInfo.BaseId = Ctrl_Base.AddBase(BaseInfo, "DiBao");//信息写入基本表并返回基本表Id
if (Ctrl_Ass_DiBao.AddDiBao(DiBaoInfo) > 0)
{
Ctrl_Base.UpdateBaseInfoWithTableName(DiBaoInfo.BaseId, "DiBao", 2);
MessageBox.ShowAndRedirect(this, "添加成功！", "DiBao_Fam_Nc.aspx?Fid=" + DiBaoInfo.Fid);
}
else
MessageBox.Show(this, "添加失败！");
}
else
{
//写入基本表
BaseEntity BaseInfo = new BaseEntity();
BaseInfo.AppId_DiShouRu = 0;//非审批途径进入基本表
BaseInfo.Bz_DiBao = 2;//更改低保标记为在发
BaseInfo.Bz_Master = cbMaster.Checked ? 1 : 0;
BaseInfo.CommunityId = int.Parse(drpCommunity.SelectedValue);
BaseInfo.Home = txtHome.Text;
BaseInfo.IdCard = txtIdCard.Text;
BaseInfo.Name = txtName.Text;
BaseInfo.StreetId = int.Parse(drpStreet.SelectedValue);
BaseInfo.Fid = int.Parse(hdFid.Value);
DiBaoInfo.BaseId = Ctrl_Base.AddBase(BaseInfo, "DiBao");//信息写入基本表并返回基本表Id
DiBaoInfo.Fid = int.Parse(hdFid.Value);
if (Ctrl_Ass_DiBao.AddDiBao(DiBaoInfo) > 0)
{
Ctrl_Base.UpdateBaseInfoWithTableName(DiBaoInfo.BaseId, "DiBao", 2);
//MessageBox.ShowAndRedirect(this, "添加成功！", ViewState["BackUrl"].ToString());
if (DiBaoInfo.Fid > 0)
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "js", "fnAddFamConfirm(" + DiBaoInfo.Fid + ",'" + ViewState["BackUrl"].ToString() + "');", true);
MessageBox.ShowAndRedirect(this, "添加成功！", ViewState["BackUrl"].ToString());
// Response.Write("<Script Language='JavaScript'>if ( window.confirm('添加成功，继续添加')) { window.location.href='" + ViewState["BackUrl"].ToString() +"' } else {window.location.href='" + ViewState["BackUrl"].ToString() + "' };</script>");//如果成功则继续添加，不成功则返回页面主页（相应户为单位）
}
}
else
MessageBox.Show(this, "添加失败！");
}
}
}
else//修改
{
DiBaoInfo.Id = int.Parse(hdId.Value);
DiBaoInfo.BaseId = int.Parse(hdBaseId.Value);
DiBaoInfo.Fid = int.Parse(hdFid.Value);
if (cbState.Checked && txtStopReason.Enabled)//如果停发
{
Ctrl_Ass_DiBao.AddStopReason(DiBaoInfo.Id, txtStopReason.Text);
}
if (Ctrl_Ass_DiBao.UpdateDiBao(DiBaoInfo))
MessageBox.ShowAndRedirect(this, "修改成功！", ViewState["BackUrl"].ToString());
else
MessageBox.Show(this, "修改失败！");
}
}
