/// <summary>
/// 获取
/// </summary>
/// <param name="_C_SN">SN</param>
/// <returns></returns>
public static ChuangWeiKuCunInfo Get(Int32 _C_SN)
{
ChuangWeiKuCunInfo _ChuangWeiKuCunInfo = new ChuangWeiKuCunInfo();
SqlParameter[] parm = { new SqlParameter("C_SN", _C_SN), };
using (SqlDataReader _SDR = SqlHelper.ExecuteReader(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "ChuangWeiKuCun_Get", parm))
{
if (_SDR.Read())
{
_ChuangWeiKuCunInfo.C_SN = Convert.ToInt32(_SDR["C_SN"]);
_ChuangWeiKuCunInfo.C_SuoShuBuMenSN = Convert.ToInt32(_SDR["C_SuoShuBuMenSN"]);
_ChuangWeiKuCunInfo.C_SuoShuXiTongSN = Convert.ToInt32(_SDR["C_SuoShuXiTongSN"]);
_ChuangWeiKuCunInfo.C_BingGuanSN = Convert.ToInt32(_SDR["C_BingGuanSN"]);
_ChuangWeiKuCunInfo.C_FangXingSN = Convert.ToInt32(_SDR["C_FangXingSN"]);
_ChuangWeiKuCunInfo.C_FangJianSN = Convert.ToInt32(_SDR["C_FangJianSN"]);
_ChuangWeiKuCunInfo.C_ChuangWeiHao = Convert.ToInt32(_SDR["C_ChuangWeiHao"]);
_ChuangWeiKuCunInfo.C_RuZhuStartDate = Convert.ToDateTime(_SDR["C_RuZhuStartDate"]);
_ChuangWeiKuCunInfo.C_TuiFangEndDate = Convert.ToDateTime(_SDR["C_TuiFangEndDate"]);
_ChuangWeiKuCunInfo.C_ChuangWei1JiaGe = Convert.ToDouble(_SDR["C_ChuangWei1JiaGe"]);
_ChuangWeiKuCunInfo.C_ChuangWei2JiaGe = Convert.ToDouble(_SDR["C_ChuangWei2JiaGe"]);
_ChuangWeiKuCunInfo.C_ChuangWei3JiaGe = Convert.ToDouble(_SDR["C_ChuangWei3JiaGe"]);
_ChuangWeiKuCunInfo.C_ChuangWei4JiaGe = Convert.ToDouble(_SDR["C_ChuangWei4JiaGe"]);
_ChuangWeiKuCunInfo.C_ChuangWei5JiaGe = Convert.ToDouble(_SDR["C_ChuangWei5JiaGe"]);
_ChuangWeiKuCunInfo.C_BaoLiuZhuangTai = Convert.ToInt32(_SDR["C_BaoLiuZhuangTai"]);
_ChuangWeiKuCunInfo.C_ShiFouShanChu = Convert.ToBoolean(_SDR["C_ShiFouShanChu"]);
_ChuangWeiKuCunInfo.C_AddDate = Convert.ToDateTime(_SDR["C_AddDate"]);
}
_SDR.Close();
_SDR.Dispose();
}
return _ChuangWeiKuCunInfo;
}
//点击拆房时候执行的操作
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(ChuangWeiKuCunInfo _ChuangWeiKuCunInfo)
{
SqlParameter[] parm ={
new SqlParameter("C_SuoShuBuMenSN",_ChuangWeiKuCunInfo.C_SuoShuBuMenSN),
new SqlParameter("C_SuoShuXiTongSN",_ChuangWeiKuCunInfo.C_SuoShuXiTongSN),
new SqlParameter("C_BingGuanSN",_ChuangWeiKuCunInfo.C_BingGuanSN),
new SqlParameter("C_FangXingSN",_ChuangWeiKuCunInfo.C_FangXingSN),
new SqlParameter("C_FangJianSN",_ChuangWeiKuCunInfo.C_FangJianSN),
new SqlParameter("C_ChuangWeiHao",_ChuangWeiKuCunInfo.C_ChuangWeiHao),
new SqlParameter("C_RuZhuStartDate",_ChuangWeiKuCunInfo.C_RuZhuStartDate),
new SqlParameter("C_TuiFangEndDate",_ChuangWeiKuCunInfo.C_TuiFangEndDate),
new SqlParameter("C_ChuangWei1JiaGe",_ChuangWeiKuCunInfo.C_ChuangWei1JiaGe),
new SqlParameter("C_ChuangWei2JiaGe",_ChuangWeiKuCunInfo.C_ChuangWei2JiaGe),
new SqlParameter("C_ChuangWei3JiaGe",_ChuangWeiKuCunInfo.C_ChuangWei3JiaGe),
new SqlParameter("C_ChuangWei4JiaGe",_ChuangWeiKuCunInfo.C_ChuangWei4JiaGe),
new SqlParameter("C_ChuangWei5JiaGe",_ChuangWeiKuCunInfo.C_ChuangWei5JiaGe),
new SqlParameter("C_BaoLiuZhuangTai",_ChuangWeiKuCunInfo.C_BaoLiuZhuangTai),
new SqlParameter("C_ShiFouShanChu",_ChuangWeiKuCunInfo.C_ShiFouShanChu),
new SqlParameter("C_AddDate",_ChuangWeiKuCunInfo.C_AddDate),
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "ChuangWeiKuCun_Add", parm);
return true;
}
