/// <summary>
/// 获取
/// </summary>
/// <param name="_F_SN">SN</param>
/// <returns></returns>
public static FangJianTianKuCunInfo Get(Int32 _F_SN)
{
FangJianTianKuCunInfo _FangJianTianKuCunInfo = new FangJianTianKuCunInfo();
SqlParameter[] parm = { new SqlParameter("F_SN", _F_SN), };
using (SqlDataReader _SDR = SqlHelper.ExecuteReader(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "FangJianTianKuCun_Get", parm))
{
if (_SDR.Read())
{
_FangJianTianKuCunInfo.F_SN = Convert.ToInt32(_SDR["F_SN"]);
_FangJianTianKuCunInfo.F_SuoShuBuMenSN = Convert.ToInt32(_SDR["F_SuoShuBuMenSN"]);
_FangJianTianKuCunInfo.F_SuoShuXiTongSN = Convert.ToInt32(_SDR["F_SuoShuXiTongSN"]);
_FangJianTianKuCunInfo.F_BingGuanSN = Convert.ToInt32(_SDR["F_BingGuanSN"]);
_FangJianTianKuCunInfo.F_FangXingSN = Convert.ToInt32(_SDR["F_FangXingSN"]);
_FangJianTianKuCunInfo.F_FangJianSN = Convert.ToInt32(_SDR["F_FangJianSN"]);
_FangJianTianKuCunInfo.F_RuZhuStartDate = Convert.ToDateTime(_SDR["F_RuZhuStartDate"]);
_FangJianTianKuCunInfo.F_TuiFangEndDate = Convert.ToDateTime(_SDR["F_TuiFangEndDate"]);
_FangJianTianKuCunInfo.F_ZhengJianJiaGe = Convert.ToDouble(_SDR["F_ZhengJianJiaGe"]);
_FangJianTianKuCunInfo.F_BaoLiuZhuangTai = Convert.ToInt32(_SDR["F_BaoLiuZhuangTai"]);
_FangJianTianKuCunInfo.F_ShiFouShanChu = Convert.ToBoolean(_SDR["F_ShiFouShanChu"]);
_FangJianTianKuCunInfo.F_AddDate = Convert.ToDateTime(_SDR["F_AddDate"]);
}
_SDR.Close();
_SDR.Dispose();
}
return(_FangJianTianKuCunInfo);
}
//点击拆房时候执行的操作
protected void Butn_ChaiFang_Click(object sender, EventArgs e)
{
for (int g = 0; g < this.Griw_List.Rows.Count; g++)
{
CheckBox _CheckBox = (CheckBox)this.Griw_List.Rows[g].FindControl("Chex_Selete");
if (_CheckBox.Checked)
{
//获取要删除的SN，并将其是否删除状态置为1
Label SN = (Label)this.Griw_List.Rows[g].FindControl("Labl_CSN");
FangJianTianKuCunInfo _FangJianTianKuCunInfo = MyFangJianTianKuCun.Get(Convert.ToInt32(SN.Text));
int FangJianNum = Convert.ToInt32(Texx_FangJianNum.Text);
for (int i = 1; i <= FangJianNum; i++)
{
ChuangWeiKuCunInfo _ChuangWeiKuCunInfo = new ChuangWeiKuCunInfo();
_ChuangWeiKuCunInfo.C_AddDate = DateTime.Now;
_ChuangWeiKuCunInfo.C_BaoLiuZhuangTai = _FangJianTianKuCunInfo.F_BaoLiuZhuangTai;
_ChuangWeiKuCunInfo.C_ChuangWei1JiaGe = Convert.ToDouble(Texx_MeiJianJianGe.Text);
_ChuangWeiKuCunInfo.C_BingGuanSN = _FangJianTianKuCunInfo.F_BingGuanSN;
_ChuangWeiKuCunInfo.C_FangJianSN = _FangJianTianKuCunInfo.F_FangJianSN;
_ChuangWeiKuCunInfo.C_RuZhuStartDate = _FangJianTianKuCunInfo.F_RuZhuStartDate;
_ChuangWeiKuCunInfo.C_TuiFangEndDate = _FangJianTianKuCunInfo.F_TuiFangEndDate;
_ChuangWeiKuCunInfo.C_SuoShuXiTongSN = _FangJianTianKuCunInfo.F_SuoShuXiTongSN;
_ChuangWeiKuCunInfo.C_SuoShuBuMenSN = _FangJianTianKuCunInfo.F_SuoShuBuMenSN;
_ChuangWeiKuCunInfo.C_FangXingSN = _FangJianTianKuCunInfo.F_FangXingSN;
_ChuangWeiKuCunInfo.C_ChuangWeiHao = i;
MyChuangWeiKuCun.Add(_ChuangWeiKuCunInfo);
}
_FangJianTianKuCunInfo.F_ShiFouShanChu = true;
MyFangJianTianKuCun.Set(_FangJianTianKuCunInfo);
}
}
KuCunTianDataBind();
}
/// <summary>
/// 添加
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Boolean Add(FangJianTianKuCunInfo _FangJianTianKuCunInfo)
{
SqlParameter[] parm =
{
new SqlParameter("F_SuoShuBuMenSN", _FangJianTianKuCunInfo.F_SuoShuBuMenSN),
new SqlParameter("F_SuoShuXiTongSN", _FangJianTianKuCunInfo.F_SuoShuXiTongSN),
new SqlParameter("F_BingGuanSN", _FangJianTianKuCunInfo.F_BingGuanSN),
new SqlParameter("F_FangXingSN", _FangJianTianKuCunInfo.F_FangXingSN),
new SqlParameter("F_FangJianSN", _FangJianTianKuCunInfo.F_FangJianSN),
new SqlParameter("F_RuZhuStartDate", _FangJianTianKuCunInfo.F_RuZhuStartDate),
new SqlParameter("F_TuiFangEndDate", _FangJianTianKuCunInfo.F_TuiFangEndDate),
new SqlParameter("F_ZhengJianJiaGe", _FangJianTianKuCunInfo.F_ZhengJianJiaGe),
new SqlParameter("F_BaoLiuZhuangTai", _FangJianTianKuCunInfo.F_BaoLiuZhuangTai),
new SqlParameter("F_ShiFouShanChu", _FangJianTianKuCunInfo.F_ShiFouShanChu),
new SqlParameter("F_AddDate", _FangJianTianKuCunInfo.F_AddDate),
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "FangJianTianKuCun_Add", parm);
return(true);
}
protected void AddFangJianTianKuCun(object sender, EventArgs e)
{
FangJianTianKuCunInfo _FangJianTianKuCunInfo = new FangJianTianKuCunInfo();
_FangJianTianKuCunInfo.F_AddDate = DateTime.Now;
_FangJianTianKuCunInfo.F_BaoLiuZhuangTai = Convert.ToInt32(Texx_BaoLiuZhuangTai.Text);
_FangJianTianKuCunInfo.F_BingGuanSN = Convert.ToInt32(Texx_BingGuan.Text);
_FangJianTianKuCunInfo.F_FangJianSN = Convert.ToInt32(Texx_FangJian.Text);
_FangJianTianKuCunInfo.F_FangXingSN = Convert.ToInt32(Texx_FangXing.Text);
int DingFangXiTongSN = Convert.ToInt32(Texx_DingFangXiTong.Text);
DingFangXiTongInfo _DingFangXiTongInfo = MyDingFangXiTong.Get(DingFangXiTongSN);
_FangJianTianKuCunInfo.F_SuoShuXiTongSN = _DingFangXiTongInfo.D_SN;
_FangJianTianKuCunInfo.F_SuoShuBuMenSN = _DingFangXiTongInfo.D_SuoShuBuMenSN;
_FangJianTianKuCunInfo.F_ZhengJianJiaGe = Convert.ToDouble(Texx_FangJianJiaGe.Text);
_FangJianTianKuCunInfo.F_TuiFangEndDate = DateTime.Parse(Texx_TuiFangEndDate.Text);
_FangJianTianKuCunInfo.F_RuZhuStartDate = DateTime.Parse(Texx_RuZhuStartDate.Text);
MyFangJianTianKuCun.Add(_FangJianTianKuCunInfo);
RegisterClientScriptBlock("", "<script>alert('操作成功！'); </script>");
}
/// <summary>
/// 设置
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Boolean Set(FangJianTianKuCunInfo _FangJianTianKuCunInfo)
{
return(FangJianTianKuCunData.Set(_FangJianTianKuCunInfo));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Boolean Add(FangJianTianKuCunInfo _FangJianTianKuCunInfo)
{
return(FangJianTianKuCunData.Add(_FangJianTianKuCunInfo));
}
