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