/// <summary>
/// 添加一行低保信息
/// </summary>
/// <param name="DiBaoInfo">低保信息实体</param>
/// <returns>成功返回1 否则返回0</returns>
public static int AddDiBao(DiBao_Info DiBaoInfo)
{
int iExecute = 0;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DiBao_Info (");
strSql.Append("BaseId,Fid,TypeId,Bz_Approver,Bz_Master,Bz_BaoZhang,Bz_Cz,ClassId,Name,Sex,IdCard");
strSql.Append(",Birth,StreetId,CommunityId,Address,Home,Tel1,Tel2,House,Square,Health,JobId,Wage");
strSql.Append(",Wage1,Wage2,Wage3,Wage4,Wage5,Wage6,OneMoney,OneMonth,OneTime,Car,Bank");
strSql.Append(",CheckTime,NextTime,Bz_Retire,RetireTime,Bz_Dead,DeadTime,Money,State,AppReason,MyFid");
strSql.Append(") values(");
strSql.Append("@BaseId,@Fid,@TypeId,@Bz_Approver,@Bz_Master,@Bz_BaoZhang,@Bz_Cz,@ClassId,@Name,@Sex,@IdCard");
strSql.Append(",@Birth,@StreetId,@CommunityId,@Address,@Home,@Tel1,@Tel2,@House,@Square,@Health,@JobId,@Wage");
strSql.Append(",@Wage1,@Wage2,@Wage3,@Wage4,@Wage5,@Wage6,@OneMoney,@OneMonth,@OneTime,@Car,@Bank");
strSql.Append(",@CheckTime,@NextTime,@Bz_Retire,@RetireTime,@Bz_Dead,@DeadTime,@Money,@State,@AppReason,@MyFid");
strSql.Append(");select @@IDENTITY");
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@BaseId",SqlDbType.Int),
new SqlParameter("@Fid",SqlDbType.Int),
new SqlParameter("@TypeId",SqlDbType.Int),
new SqlParameter("@Bz_Approver",SqlDbType.Int),
new SqlParameter("@Bz_Master",SqlDbType.Int),
new SqlParameter("@Bz_BaoZhang",SqlDbType.Int),
new SqlParameter("@Bz_Cz",SqlDbType.Int),
new SqlParameter("@ClassId",SqlDbType.Int),
new SqlParameter("@Name",SqlDbType.NVarChar,50),
new SqlParameter("@Sex",SqlDbType.NVarChar,50),
new SqlParameter("@IdCard",SqlDbType.NVarChar,50),
new SqlParameter("@Birth",SqlDbType.DateTime),
new SqlParameter("@StreetId",SqlDbType.Int),
new SqlParameter("@CommunityId",SqlDbType.Int),
new SqlParameter("@Address",SqlDbType.NVarChar,100),
new SqlParameter("@Home",SqlDbType.NVarChar,100),
new SqlParameter("@Tel1",SqlDbType.NVarChar,50),
new SqlParameter("@Tel2",SqlDbType.NVarChar,50),
new SqlParameter("@House",SqlDbType.NVarChar,50),
new SqlParameter("@Square",SqlDbType.NVarChar,50),
new SqlParameter("@Health",SqlDbType.NVarChar,50),
new SqlParameter("@JobId",SqlDbType.Int),
new SqlParameter("@Wage",SqlDbType.NVarChar,50),
new SqlParameter("@Wage1",SqlDbType.NVarChar,50),
new SqlParameter("@Wage2",SqlDbType.NVarChar,50),
new SqlParameter("@Wage3",SqlDbType.NVarChar,50),
new SqlParameter("@Wage4",SqlDbType.NVarChar,50),
new SqlParameter("@Wage5",SqlDbType.NVarChar,50),
new SqlParameter("@Wage6",SqlDbType.NVarChar,50),
new SqlParameter("@OneMoney",SqlDbType.NVarChar,50),
new SqlParameter("@OneMonth",SqlDbType.NVarChar,50),
new SqlParameter("@OneTime",SqlDbType.DateTime),
new SqlParameter("@Car",SqlDbType.NVarChar,50),
new SqlParameter("@Bank",SqlDbType.NVarChar,50),
new SqlParameter("@CheckTime",SqlDbType.DateTime),
new SqlParameter("@NextTime",SqlDbType.DateTime),
new SqlParameter("@Bz_Retire",SqlDbType.Int),
new SqlParameter("@RetireTime",SqlDbType.DateTime),
new SqlParameter("@Bz_Dead",SqlDbType.Int),
new SqlParameter("@DeadTime",SqlDbType.DateTime),
new SqlParameter("@Money",SqlDbType.Int),
new SqlParameter("@State",SqlDbType.Int),
new SqlParameter("@AppReason",SqlDbType.NVarChar,10000),
new SqlParameter("@MyFid",SqlDbType.Int),
};
para[0].Value = DiBaoInfo.BaseId;
para[1].Value = DiBaoInfo.Fid;
para[2].Value = DiBaoInfo.TypeId;
para[3].Value = DiBaoInfo.Bz_Approver;
para[4].Value = DiBaoInfo.Bz_Master;
para[5].Value = DiBaoInfo.Bz_BaoZhang;
para[6].Value = DiBaoInfo.Bz_Cz;
para[7].Value = DiBaoInfo.ClassId;
para[8].Value = DiBaoInfo.Name;
para[9].Value = DiBaoInfo.Sex;
para[10].Value = DiBaoInfo.IdCard;
para[11].Value = DiBaoInfo.Birth;
para[12].Value = DiBaoInfo.StreetId;
para[13].Value = DiBaoInfo.CommunityId;
para[14].Value = DiBaoInfo.Address;
para[15].Value = DiBaoInfo.Home;
para[16].Value = DiBaoInfo.Tel1;
para[17].Value = DiBaoInfo.Tel2;
para[18].Value = DiBaoInfo.House;
para[19].Value = DiBaoInfo.Square;
para[20].Value = DiBaoInfo.Health;
para[21].Value = DiBaoInfo.JobId;
para[22].Value = DiBaoInfo.Wage;
para[23].Value = DiBaoInfo.Wage1;
para[24].Value = DiBaoInfo.Wage2;
para[25].Value = DiBaoInfo.Wage3;
para[26].Value = DiBaoInfo.Wage4;
para[27].Value = DiBaoInfo.Wage5;
para[28].Value = DiBaoInfo.Wage6;
para[29].Value = DiBaoInfo.OneMoney;
para[30].Value = DiBaoInfo.OneMonth;
para[31].Value = DiBaoInfo.OneTime;
para[32].Value = DiBaoInfo.Car;
para[33].Value = DiBaoInfo.Bank;
para[34].Value = DiBaoInfo.CheckTime;
para[35].Value = DiBaoInfo.NextTime;
para[36].Value = DiBaoInfo.Bz_Retire;
para[37].Value = DiBaoInfo.RetireTime;
para[38].Value = DiBaoInfo.Bz_Dead;
para[39].Value = DiBaoInfo.DeadTime;
para[40].Value = DiBaoInfo.Money;
para[41].Value = DiBaoInfo.State;
para[42].Value = DiBaoInfo.AppReason;
para[43].Value = DiBaoInfo.MyFid;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), para);
if (obj != null)
{
iExecute = Convert.ToInt32(obj);
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\GetPageUserInfoList" + e.Message);
}
return iExecute;
}
/// <summary>
/// 更新低保人员数据
/// </summary>
/// <param name="DiBaoInfo">低保人员信息实体</param>
/// <returns>成功返回true 否则返回false</returns>
public static bool UpdateDiBao(DiBao_Info DiBaoInfo)
{
bool iExecute = false;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update DiBao_Info set ");
strSql.Append("BaseId=@BaseId,");
strSql.Append("Fid=@Fid,");
strSql.Append("TypeId=@TypeId,");
strSql.Append("Bz_Approver=@Bz_Approver,");
strSql.Append("Bz_Master=@Bz_Master,");
strSql.Append("Bz_BaoZhang=@Bz_BaoZhang,");
strSql.Append("Bz_Cz=@Bz_Cz,");
strSql.Append("ClassId=@ClassId,");
strSql.Append("Name=@Name,");
strSql.Append("Sex=@Sex,");
strSql.Append("IdCard=@IdCard,");
strSql.Append("Birth=@Birth,");
strSql.Append("StreetId=@StreetId,");
strSql.Append("CommunityId=@CommunityId,");
strSql.Append("Address=@Address,");
strSql.Append("Home=@Home,");
strSql.Append("Tel1=@Tel1,");
strSql.Append("Tel2=@Tel2,");
strSql.Append("House=@House,");
strSql.Append("Square=@Square,");
strSql.Append("Health=@Health,");
strSql.Append("JobId=@JobId,");
strSql.Append("Wage=@Wage,");
strSql.Append("Wage1=@Wage1,");
strSql.Append("Wage2=@Wage2,");
strSql.Append("Wage3=@Wage3,");
strSql.Append("Wage4=@Wage4,");
strSql.Append("Wage5=@Wage5,");
strSql.Append("Wage6=@Wage6,");
strSql.Append("OneMoney=@OneMoney,");
strSql.Append("OneMonth=@OneMonth,");
strSql.Append("OneTime=@OneTime,");
strSql.Append("Car=@Car,");
strSql.Append("Bank=@Bank,");
strSql.Append("CheckTime=@CheckTime,");
strSql.Append("NextTime=@NextTime,");
strSql.Append("Bz_Retire=@Bz_Retire,");
strSql.Append("RetireTime=@RetireTime,");
strSql.Append("Bz_Dead=@Bz_Dead,");
strSql.Append("DeadTime=@DeadTime,");
strSql.Append("Money=@Money,");
strSql.Append("State=@State, ");
strSql.Append(" MyFid=@MyFid,");
strSql.Append(" AppReason=@AppReason");
strSql.Append(" where Id=@Id");
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@BaseId",SqlDbType.Int),
new SqlParameter("@Fid",SqlDbType.Int),
new SqlParameter("@TypeId",SqlDbType.Int),
new SqlParameter("@Bz_Approver",SqlDbType.Int),
new SqlParameter("@Bz_Master",SqlDbType.Int),
new SqlParameter("@Bz_BaoZhang",SqlDbType.Int),
new SqlParameter("@Bz_Cz",SqlDbType.Int),
new SqlParameter("@ClassId",SqlDbType.Int),
new SqlParameter("@Name",SqlDbType.NVarChar,50),
new SqlParameter("@Sex",SqlDbType.NVarChar,50),
new SqlParameter("@IdCard",SqlDbType.NVarChar,50),
new SqlParameter("@Birth",SqlDbType.DateTime),
new SqlParameter("@StreetId",SqlDbType.Int),
new SqlParameter("@CommunityId",SqlDbType.Int),
new SqlParameter("@Address",SqlDbType.NVarChar,100),
new SqlParameter("@Home",SqlDbType.NVarChar,100),
new SqlParameter("@Tel1",SqlDbType.NVarChar,50),
new SqlParameter("@Tel2",SqlDbType.NVarChar,50),
new SqlParameter("@House",SqlDbType.NVarChar,50),
new SqlParameter("@Square",SqlDbType.NVarChar,50),
new SqlParameter("@Health",SqlDbType.NVarChar,50),
new SqlParameter("@JobId",SqlDbType.Int),
new SqlParameter("@Wage",SqlDbType.NVarChar,50),
new SqlParameter("@Wage1",SqlDbType.NVarChar,50),
new SqlParameter("@Wage2",SqlDbType.NVarChar,50),
new SqlParameter("@Wage3",SqlDbType.NVarChar,50),
new SqlParameter("@Wage4",SqlDbType.NVarChar,50),
new SqlParameter("@Wage5",SqlDbType.NVarChar,50),
new SqlParameter("@Wage6",SqlDbType.NVarChar,50),
new SqlParameter("@OneMoney",SqlDbType.NVarChar,50),
new SqlParameter("@OneMonth",SqlDbType.NVarChar,50),
new SqlParameter("@OneTime",SqlDbType.DateTime),
new SqlParameter("@Car",SqlDbType.NVarChar,50),
new SqlParameter("@Bank",SqlDbType.NVarChar,50),
new SqlParameter("@CheckTime",SqlDbType.DateTime),
new SqlParameter("@NextTime",SqlDbType.DateTime),
new SqlParameter("@Bz_Retire",SqlDbType.Int),
new SqlParameter("@RetireTime",SqlDbType.DateTime),
new SqlParameter("@Bz_Dead",SqlDbType.Int),
new SqlParameter("@DeadTime",SqlDbType.DateTime),
new SqlParameter("@Money",SqlDbType.Decimal),
new SqlParameter("@State",SqlDbType.Int),
new SqlParameter("@MyFid",SqlDbType.Int),
new SqlParameter("@AppReason",SqlDbType.NVarChar,5000),
new SqlParameter("@Id",SqlDbType.Int)
};
para[0].Value = DiBaoInfo.BaseId;
para[1].Value = DiBaoInfo.Fid;
para[2].Value = DiBaoInfo.TypeId;
para[3].Value = DiBaoInfo.Bz_Approver;
para[4].Value = DiBaoInfo.Bz_Master;
para[5].Value = DiBaoInfo.Bz_BaoZhang;
para[6].Value = DiBaoInfo.Bz_Cz;
para[7].Value = DiBaoInfo.ClassId;
para[8].Value = DiBaoInfo.Name;
para[9].Value = DiBaoInfo.Sex;
para[10].Value = DiBaoInfo.IdCard;
para[11].Value = DiBaoInfo.Birth;
para[12].Value = DiBaoInfo.StreetId;
para[13].Value = DiBaoInfo.CommunityId;
para[14].Value = DiBaoInfo.Address;
para[15].Value = DiBaoInfo.Home;
para[16].Value = DiBaoInfo.Tel1;
para[17].Value = DiBaoInfo.Tel2;
para[18].Value = DiBaoInfo.House;
para[19].Value = DiBaoInfo.Square;
para[20].Value = DiBaoInfo.Health;
para[21].Value = DiBaoInfo.JobId;
para[22].Value = DiBaoInfo.Wage;
para[23].Value = DiBaoInfo.Wage1;
para[24].Value = DiBaoInfo.Wage2;
para[25].Value = DiBaoInfo.Wage3;
para[26].Value = DiBaoInfo.Wage4;
para[27].Value = DiBaoInfo.Wage5;
para[28].Value = DiBaoInfo.Wage6;
para[29].Value = DiBaoInfo.OneMoney;
para[30].Value = DiBaoInfo.OneMonth;
para[31].Value = DiBaoInfo.OneTime;
para[32].Value = DiBaoInfo.Car;
para[33].Value = DiBaoInfo.Bank;
para[34].Value = DiBaoInfo.CheckTime;
para[35].Value = DiBaoInfo.NextTime;
para[36].Value = DiBaoInfo.Bz_Retire;
para[37].Value = DiBaoInfo.RetireTime;
para[38].Value = DiBaoInfo.Bz_Dead;
para[39].Value = DiBaoInfo.DeadTime;
para[40].Value = DiBaoInfo.Money;
para[41].Value = DiBaoInfo.State;
para[42].Value = DiBaoInfo.MyFid;
para[43].Value = DiBaoInfo.AppReason;
para[44].Value = DiBaoInfo.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), para);
int rowsx = DbHelperSQL.ExecuteSql("Update DiBao_Info set Money=" + DiBaoInfo.Money + ",State=" + DiBaoInfo.State + ",TypeId=" + DiBaoInfo.TypeId + " where Fid=" + DiBaoInfo.Fid);
if (rows > 0)
{
iExecute = true;
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\GetPageUserInfoList" + e.Message);
}
return iExecute;
}
/// <summary>
/// 根据低保Id获取低保信息
/// </summary>
/// <param name="Id">低保表Id</param>
/// <returns></returns>
public static DiBao_Info GetDiBaoInfoById(int Id)
{
DiBao_Info DiBaoInfo = new DiBao_Info();
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select A.Id,A.BaseId,A.Fid,A.TypeId,A.Bz_Approver,A.Bz_Master,A.Bz_BaoZhang");
strSql.Append(",A.Bz_Cz,A.ClassId,A.Name,A.Sex,A.IdCard,A.Birth,A.StreetId,A.CommunityId");
strSql.Append(",A.Address,A.Home,A.Tel1,A.Tel2,A.House,A.Square,A.Health,A.JobId,A.Money,A.Wage");
strSql.Append(",A.Wage1,A.Wage2,A.Wage3,A.Wage4,A.Wage5,A.Wage6,A.OneMoney,A.OneMonth,A.OneTime");
strSql.Append(",A.Car,A.Bank,A.CheckTime,A.NextTime,A.Bz_Retire,A.RetireTime,A.Bz_Dead,A.DeadTime,A.State,A.AppReason,A.MyFid");
//strSql.Append(",B.Name as Type,C.Name as Class,D.Name as StreetName,E.Name as CommunityName,F.Name as Job");
//strSql.Append(" FROM DiBao_Info as A left join DiBao_Type as B on A.TypeId=B.Id");
//strSql.Append(" left join DiBao_Class as C on A.ClassId=C.Id");
//strSql.Append(" left join Area_Street as D on A.StreetId=D.Id");
//strSql.Append(" left join Area_Community as E on A.CommunityId=E.Id");
//strSql.Append(" left join DiBao_Job as F on A.JobId=F.Id");
strSql.Append(" FROM DiBao_Info as A where A.Id=" + Id);
DataSet 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() != "")
{
DiBaoInfo.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["BaseId"] != null && ds.Tables[0].Rows[0]["BaseId"].ToString() != "")
{
DiBaoInfo.BaseId = int.Parse(ds.Tables[0].Rows[0]["BaseId"].ToString());
}
if (ds.Tables[0].Rows[0]["Fid"] != null && ds.Tables[0].Rows[0]["Fid"].ToString() != "")
{
DiBaoInfo.Fid = int.Parse(ds.Tables[0].Rows[0]["Fid"].ToString());
}
if (ds.Tables[0].Rows[0]["TypeId"] != null && ds.Tables[0].Rows[0]["TypeId"].ToString() != "")
{
DiBaoInfo.TypeId = int.Parse(ds.Tables[0].Rows[0]["TypeId"].ToString());
}
if (ds.Tables[0].Rows[0]["Bz_Approver"] != null && ds.Tables[0].Rows[0]["Bz_Approver"].ToString() != "")
{
DiBaoInfo.Bz_Approver = int.Parse(ds.Tables[0].Rows[0]["Bz_Approver"].ToString());
}
if (ds.Tables[0].Rows[0]["Bz_Master"] != null && ds.Tables[0].Rows[0]["Bz_Master"].ToString() != "")
{
DiBaoInfo.Bz_Master = int.Parse(ds.Tables[0].Rows[0]["Bz_Master"].ToString());
}
if (ds.Tables[0].Rows[0]["Bz_BaoZhang"] != null && ds.Tables[0].Rows[0]["Bz_BaoZhang"].ToString() != "")
{
DiBaoInfo.Bz_BaoZhang = int.Parse(ds.Tables[0].Rows[0]["Bz_BaoZhang"].ToString());
}
if (ds.Tables[0].Rows[0]["Bz_Cz"] != null && ds.Tables[0].Rows[0]["Bz_Cz"].ToString() != "")
{
DiBaoInfo.Bz_Cz = int.Parse(ds.Tables[0].Rows[0]["Bz_Cz"].ToString());
}
if (ds.Tables[0].Rows[0]["ClassId"] != null && ds.Tables[0].Rows[0]["ClassId"].ToString() != "")
{
DiBaoInfo.ClassId = int.Parse(ds.Tables[0].Rows[0]["ClassId"].ToString());
}
if (ds.Tables[0].Rows[0]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "")
{
DiBaoInfo.Name = ds.Tables[0].Rows[0]["Name"].ToString();
}
if (ds.Tables[0].Rows[0]["Sex"] != null && ds.Tables[0].Rows[0]["Sex"].ToString() != "")
{
DiBaoInfo.Sex = ds.Tables[0].Rows[0]["Sex"].ToString();
}
if (ds.Tables[0].Rows[0]["IdCard"] != null && ds.Tables[0].Rows[0]["IdCard"].ToString() != "")
{
DiBaoInfo.IdCard = ds.Tables[0].Rows[0]["IdCard"].ToString();
}
if (ds.Tables[0].Rows[0]["Birth"] != null && ds.Tables[0].Rows[0]["Birth"].ToString() != "")
{
DiBaoInfo.Birth = DateTime.Parse(ds.Tables[0].Rows[0]["Birth"].ToString());
}
if (ds.Tables[0].Rows[0]["StreetId"] != null && ds.Tables[0].Rows[0]["StreetId"].ToString() != "")
{
DiBaoInfo.StreetId = int.Parse(ds.Tables[0].Rows[0]["StreetId"].ToString());
}
if (ds.Tables[0].Rows[0]["CommunityId"] != null && ds.Tables[0].Rows[0]["CommunityId"].ToString() != "")
{
DiBaoInfo.CommunityId = int.Parse(ds.Tables[0].Rows[0]["CommunityId"].ToString());
}
if (ds.Tables[0].Rows[0]["Address"] != null && ds.Tables[0].Rows[0]["Address"].ToString() != "")
{
DiBaoInfo.Address = ds.Tables[0].Rows[0]["Address"].ToString();
}
if (ds.Tables[0].Rows[0]["Home"] != null && ds.Tables[0].Rows[0]["Home"].ToString() != "")
{
DiBaoInfo.Home = ds.Tables[0].Rows[0]["Home"].ToString();
}
if (ds.Tables[0].Rows[0]["Tel1"] != null && ds.Tables[0].Rows[0]["Tel1"].ToString() != "")
{
DiBaoInfo.Tel1 = ds.Tables[0].Rows[0]["Tel1"].ToString();
}
if (ds.Tables[0].Rows[0]["Tel2"] != null && ds.Tables[0].Rows[0]["Tel2"].ToString() != "")
{
DiBaoInfo.Tel2 = ds.Tables[0].Rows[0]["Tel2"].ToString();
}
if (ds.Tables[0].Rows[0]["House"] != null && ds.Tables[0].Rows[0]["House"].ToString() != "")
{
DiBaoInfo.House = ds.Tables[0].Rows[0]["House"].ToString();
}
if (ds.Tables[0].Rows[0]["Square"] != null && ds.Tables[0].Rows[0]["Square"].ToString() != "")
{
DiBaoInfo.Square = ds.Tables[0].Rows[0]["Square"].ToString();
}
if (ds.Tables[0].Rows[0]["Health"] != null && ds.Tables[0].Rows[0]["Health"].ToString() != "")
{
DiBaoInfo.Health = ds.Tables[0].Rows[0]["Health"].ToString();
}
if (ds.Tables[0].Rows[0]["JobId"] != null && ds.Tables[0].Rows[0]["JobId"].ToString() != "")
{
DiBaoInfo.JobId = int.Parse(ds.Tables[0].Rows[0]["JobId"].ToString());
}
if (ds.Tables[0].Rows[0]["Money"] != null && ds.Tables[0].Rows[0]["Money"].ToString() != "")
{
DiBaoInfo.Money = decimal.Parse(ds.Tables[0].Rows[0]["Money"].ToString());
}
if (ds.Tables[0].Rows[0]["Wage"] != null && ds.Tables[0].Rows[0]["Wage"].ToString() != "")
{
DiBaoInfo.Wage = ds.Tables[0].Rows[0]["Wage"].ToString();
}
if (ds.Tables[0].Rows[0]["Wage1"] != null && ds.Tables[0].Rows[0]["Wage1"].ToString() != "")
{
DiBaoInfo.Wage1 = ds.Tables[0].Rows[0]["Wage1"].ToString();
}
if (ds.Tables[0].Rows[0]["Wage2"] != null && ds.Tables[0].Rows[0]["Wage2"].ToString() != "")
{
DiBaoInfo.Wage2 = ds.Tables[0].Rows[0]["Wage2"].ToString();
}
if (ds.Tables[0].Rows[0]["Wage3"] != null && ds.Tables[0].Rows[0]["Wage3"].ToString() != "")
{
DiBaoInfo.Wage3 = ds.Tables[0].Rows[0]["Wage3"].ToString();
}
if (ds.Tables[0].Rows[0]["Wage4"] != null && ds.Tables[0].Rows[0]["Wage4"].ToString() != "")
{
DiBaoInfo.Wage4 = ds.Tables[0].Rows[0]["Wage4"].ToString();
}
if (ds.Tables[0].Rows[0]["Wage5"] != null && ds.Tables[0].Rows[0]["Wage5"].ToString() != "")
{
DiBaoInfo.Wage5 = ds.Tables[0].Rows[0]["Wage5"].ToString();
}
if (ds.Tables[0].Rows[0]["Wage6"] != null && ds.Tables[0].Rows[0]["Wage6"].ToString() != "")
{
DiBaoInfo.Wage6 = ds.Tables[0].Rows[0]["Wage6"].ToString();
}
if (ds.Tables[0].Rows[0]["OneMoney"] != null && ds.Tables[0].Rows[0]["OneMoney"].ToString() != "")
{
DiBaoInfo.OneMoney = ds.Tables[0].Rows[0]["OneMoney"].ToString();
}
if (ds.Tables[0].Rows[0]["OneMonth"] != null && ds.Tables[0].Rows[0]["OneMonth"].ToString() != "")
{
DiBaoInfo.OneMonth = ds.Tables[0].Rows[0]["OneMonth"].ToString();
}
if (ds.Tables[0].Rows[0]["OneTime"] != null && ds.Tables[0].Rows[0]["OneTime"].ToString() != "")
{
DiBaoInfo.OneTime = DateTime.Parse(ds.Tables[0].Rows[0]["OneTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Car"] != null && ds.Tables[0].Rows[0]["Car"].ToString() != "")
{
DiBaoInfo.Car = ds.Tables[0].Rows[0]["Car"].ToString();
}
if (ds.Tables[0].Rows[0]["Bank"] != null && ds.Tables[0].Rows[0]["Bank"].ToString() != "")
{
DiBaoInfo.Bank = ds.Tables[0].Rows[0]["Bank"].ToString();
}
if (ds.Tables[0].Rows[0]["CheckTime"] != null && ds.Tables[0].Rows[0]["CheckTime"].ToString() != "")
{
DiBaoInfo.CheckTime = DateTime.Parse(ds.Tables[0].Rows[0]["CheckTime"].ToString());
}
if (ds.Tables[0].Rows[0]["NextTime"] != null && ds.Tables[0].Rows[0]["NextTime"].ToString() != "")
{
DiBaoInfo.NextTime = DateTime.Parse(ds.Tables[0].Rows[0]["NextTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Bz_Retire"] != null && ds.Tables[0].Rows[0]["Bz_Retire"].ToString() != "")
{
DiBaoInfo.Bz_Retire = int.Parse(ds.Tables[0].Rows[0]["Bz_Retire"].ToString());
}
if (ds.Tables[0].Rows[0]["RetireTime"] != null && ds.Tables[0].Rows[0]["RetireTime"].ToString() != "")
{
DiBaoInfo.RetireTime = DateTime.Parse(ds.Tables[0].Rows[0]["RetireTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Bz_Dead"] != null && ds.Tables[0].Rows[0]["Bz_Dead"].ToString() != "")
{
DiBaoInfo.Bz_Dead = int.Parse(ds.Tables[0].Rows[0]["Bz_Dead"].ToString());
}
if (ds.Tables[0].Rows[0]["DeadTime"] != null && ds.Tables[0].Rows[0]["DeadTime"].ToString() != "")
{
DiBaoInfo.DeadTime = DateTime.Parse(ds.Tables[0].Rows[0]["DeadTime"].ToString());
}
if (ds.Tables[0].Rows[0]["State"] != null && ds.Tables[0].Rows[0]["State"].ToString() != "")
{
DiBaoInfo.State = int.Parse(ds.Tables[0].Rows[0]["State"].ToString());
}
if (ds.Tables[0].Rows[0]["AppReason"] != null && ds.Tables[0].Rows[0]["AppReason"].ToString() != "")
{
DiBaoInfo.AppReason = ds.Tables[0].Rows[0]["AppReason"].ToString();
}
if (ds.Tables[0].Rows[0]["MyFid"] != null && ds.Tables[0].Rows[0]["MyFid"].ToString() != "")
{
DiBaoInfo.MyFid = int.Parse(ds.Tables[0].Rows[0]["MyFid"].ToString());
}
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\GetPageUserInfoList" + e.Message);
}
return DiBaoInfo;
}
/// <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, "修改失败！");
}
}