protected void AddFangXing(object sender, EventArgs e)
{
FangXingInfo _FangXingInfo = new FangXingInfo();
_FangXingInfo.F_AddDate = DateTime.Now;
_FangXingInfo.F_ZhengJianJiaGe = Convert.ToDouble(Texx_FangXingJiaGe.Text);
_FangXingInfo.F_ChuangWei1JiaGe = Convert.ToDouble(Texx_ChuangWei1JiaGe.Text);
_FangXingInfo.F_ChuangWei2JiaGe = Convert.ToDouble(Texx_ChuangWei2JiaGe.Text);
_FangXingInfo.F_ChuangWei3JiaGe = Convert.ToDouble(Texx_ChuangWei3JiaGe.Text);
_FangXingInfo.F_ChuangWei4JiaGe = Convert.ToDouble(Texx_ChuangWei4JiaGe.Text);
_FangXingInfo.F_ChuangWei5JiaGe = Convert.ToDouble(Texx_ChuangWei5JiaGe.Text);
_FangXingInfo.F_Detail = Texx_FangXingDetail.Text;
_FangXingInfo.F_Name = Texx_FangXingName.Text;
_FangXingInfo.F_SuoShuBingGuanSN = Convert.ToInt32(Texx_BingGuan.Text);
int DingFangXiTongSN = Convert.ToInt32(Texx_DingFangXiTong.Text);
DingFangXiTongInfo _DingFangXiTongInfo = MyDingFangXiTong.Get(DingFangXiTongSN);
_FangXingInfo.F_SuoShuXiTongSN = _DingFangXiTongInfo.D_SN;
_FangXingInfo.F_SuoShuBuMenSN = _DingFangXiTongInfo.D_SuoShuBuMenSN;
MyFangXing.Add(_FangXingInfo);
RegisterClientScriptBlock("", "<script>alert('操作成功！'); </script>");
CleartextBoxes(this);
}
protected void AddDingFangXiTong(object sender, EventArgs e)
{
DingFangXiTongInfo _DingFangXiTongInfo = new DingFangXiTongInfo();
_DingFangXiTongInfo.D_AddDate = DateTime.Now;
_DingFangXiTongInfo.D_BanJiSNs = Texx_BanJiSNs.Text;
_DingFangXiTongInfo.D_Name = Texx_DingFangXiTongName.Text;
_DingFangXiTongInfo.D_SuoShuBuMenSN = Convert.ToInt32(Texx_BuMenSN.Text);
MyDingFangXiTong.Add(_DingFangXiTongInfo);
RegisterClientScriptBlock("", "<script>alert('操作成功！'); window.location.href='AddDingFangXiTong.aspx'</script>");
Texx_BuMenSN.Text = "";
Texx_BanJiSNs.Text = "";
}
/// <summary>
/// 添加
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Boolean Add(DingFangXiTongInfo _DingFangXiTongInfo)
{
SqlParameter[] parm ={
new SqlParameter("D_SuoShuBuMenSN",_DingFangXiTongInfo.D_SuoShuBuMenSN),
new SqlParameter("D_Name",_DingFangXiTongInfo.D_Name),
new SqlParameter("D_BanJiSNs",_DingFangXiTongInfo.D_BanJiSNs),
new SqlParameter("D_AddDate",_DingFangXiTongInfo.D_AddDate),
new SqlParameter("D_ShiFouShanChu",_DingFangXiTongInfo.D_ShiFouShanChu),
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "DingFangXiTong_Add", parm);
return true;
}
protected void AddDingFangXiTong(object sender, EventArgs e)
{
DingFangXiTongInfo _DingFangXiTongInfo = new DingFangXiTongInfo();
_DingFangXiTongInfo.D_AddDate = DateTime.Now;
_DingFangXiTongInfo.D_BanJiSNs = Texx_BanJiSNs.Text;
_DingFangXiTongInfo.D_Name = Texx_DingFangXiTongName.Text;
_DingFangXiTongInfo.D_SuoShuBuMenSN = Convert.ToInt32(Texx_BuMenSN.Text);
MyDingFangXiTong.Add(_DingFangXiTongInfo);
RegisterClientScriptBlock("", "<script>alert('操作成功！'); window.location.href='AddDingFangXiTong.aspx'</script>");
Texx_BuMenSN.Text = "";
Texx_BanJiSNs.Text = "";
}
/// <summary>
/// 添加
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Boolean Add(DingFangXiTongInfo _DingFangXiTongInfo)
{
SqlParameter[] parm =
{
new SqlParameter("D_SuoShuBuMenSN", _DingFangXiTongInfo.D_SuoShuBuMenSN),
new SqlParameter("D_Name", _DingFangXiTongInfo.D_Name),
new SqlParameter("D_BanJiSNs", _DingFangXiTongInfo.D_BanJiSNs),
new SqlParameter("D_AddDate", _DingFangXiTongInfo.D_AddDate),
new SqlParameter("D_ShiFouShanChu", _DingFangXiTongInfo.D_ShiFouShanChu),
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "DingFangXiTong_Add", parm);
return(true);
}
protected void AddBinGuan(object sender, EventArgs e)
{
BingGuanInfo _BingGuanInfo = new BingGuanInfo();
int DingFangXiTongSN = Convert.ToInt32(Texx_DingFangXiTong.Text);
DingFangXiTongInfo _DingFangXiTongInfo = MyDingFangXiTong.Get(DingFangXiTongSN);
_BingGuanInfo.B_SuoShuDingFangXiTongSN = _DingFangXiTongInfo.D_SN;
_BingGuanInfo.B_SuoShuBuMenSN = _DingFangXiTongInfo.D_SuoShuBuMenSN;
_BingGuanInfo.B_Name = Texx_BingGuanName.Text;
_BingGuanInfo.B_AddDate = DateTime.Now;
_BingGuanInfo.B_Address = Texx_Address.Text;
_BingGuanInfo.B_Phone = Texx_Phone.Text;
MyBingGuan.Add(_BingGuanInfo);
RegisterClientScriptBlock("", "<script>alert('操作成功！'); window.location.href='AddBingGuan.aspx'</script>");
}
/// <summary>
/// 获取
/// </summary>
/// <param name="_D_SN">SN</param>
/// <returns></returns>
public static DingFangXiTongInfo Get(Int32 _D_SN)
{
DingFangXiTongInfo _DingFangXiTongInfo = new DingFangXiTongInfo();
SqlParameter[] parm = { new SqlParameter("D_SN", _D_SN), };
using (SqlDataReader _SDR = SqlHelper.ExecuteReader(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "DingFangXiTong_Get", parm))
{
if (_SDR.Read())
{
_DingFangXiTongInfo.D_SN = Convert.ToInt32(_SDR["D_SN"]);
_DingFangXiTongInfo.D_SuoShuBuMenSN = Convert.ToInt32(_SDR["D_SuoShuBuMenSN"]);
_DingFangXiTongInfo.D_Name = Convert.ToString(_SDR["D_Name"]);
_DingFangXiTongInfo.D_BanJiSNs = Convert.ToString(_SDR["D_BanJiSNs"]);
_DingFangXiTongInfo.D_AddDate = Convert.ToDateTime(_SDR["D_AddDate"]);
_DingFangXiTongInfo.D_ShiFouShanChu = Convert.ToBoolean(_SDR["D_ShiFouShanChu"]);
}
_SDR.Close();
_SDR.Dispose();
}
return _DingFangXiTongInfo;
}
protected void AddBingGuan(object sender, EventArgs e)
{
BingGuanInfo _BingGuanInfo = new BingGuanInfo();
_BingGuanInfo.B_AddDate = DateTime.Now;
_BingGuanInfo.B_Address = Texx_Address.Text;
_BingGuanInfo.B_Name = Texx_Name.Text;
_BingGuanInfo.B_Phone = Texx_Phone.Text;
Int32 XiTongSN = Convert.ToInt32(Texx_DingFangXiTong.Text);
DingFangXiTongInfo _DingFangXiTongInfo = MyDingFangXiTong.Get(XiTongSN);
_BingGuanInfo.B_SuoShuDingFangXiTongSN = XiTongSN;
_BingGuanInfo.B_SuoShuBuMenSN = _DingFangXiTongInfo.D_SuoShuBuMenSN;
MyBingGuan.Add(_BingGuanInfo);
RegisterClientScriptBlock("", "<script>alert('操作成功！'); </script>");
CleartextBoxes(this);
}
/// <summary>
/// 获取
/// </summary>
/// <param name="_D_SN">SN</param>
/// <returns></returns>
public static DingFangXiTongInfo Get(Int32 _D_SN)
{
DingFangXiTongInfo _DingFangXiTongInfo = new DingFangXiTongInfo();
SqlParameter[] parm = { new SqlParameter("D_SN", _D_SN), };
using (SqlDataReader _SDR = SqlHelper.ExecuteReader(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "DingFangXiTong_Get", parm))
{
if (_SDR.Read())
{
_DingFangXiTongInfo.D_SN = Convert.ToInt32(_SDR["D_SN"]);
_DingFangXiTongInfo.D_SuoShuBuMenSN = Convert.ToInt32(_SDR["D_SuoShuBuMenSN"]);
_DingFangXiTongInfo.D_Name = Convert.ToString(_SDR["D_Name"]);
_DingFangXiTongInfo.D_BanJiSNs = Convert.ToString(_SDR["D_BanJiSNs"]);
_DingFangXiTongInfo.D_AddDate = Convert.ToDateTime(_SDR["D_AddDate"]);
_DingFangXiTongInfo.D_ShiFouShanChu = Convert.ToBoolean(_SDR["D_ShiFouShanChu"]);
}
_SDR.Close();
_SDR.Dispose();
}
return(_DingFangXiTongInfo);
}
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(DingFangXiTongInfo _DingFangXiTongInfo)
{
return(DingFangXiTongData.Set(_DingFangXiTongInfo));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Boolean Add(DingFangXiTongInfo _DingFangXiTongInfo)
{
return(DingFangXiTongData.Add(_DingFangXiTongInfo));
}
/// <summary>
/// 设置
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Boolean Set(DingFangXiTongInfo _DingFangXiTongInfo)
{
return DingFangXiTongData.Set(_DingFangXiTongInfo);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Boolean Add(DingFangXiTongInfo _DingFangXiTongInfo)
{
return DingFangXiTongData.Add(_DingFangXiTongInfo);
}