/// <summary> /// 获取 /// </summary> /// <param name="_F_SN">SN</param> /// <returns></returns> public static FangJianInfo Get(Int32 _F_SN) { FangJianInfo _FangJianInfo = new FangJianInfo(); SqlParameter[] parm = { new SqlParameter("F_SN", _F_SN), }; using (SqlDataReader _SDR = SqlHelper.ExecuteReader(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "FangJian_Get", parm)) { if (_SDR.Read()) { _FangJianInfo.F_SN = Convert.ToInt32(_SDR["F_SN"]); _FangJianInfo.F_SuoShuFangXingSN = Convert.ToInt32(_SDR["F_SuoShuFangXingSN"]); _FangJianInfo.F_FangJianHao = Convert.ToString(_SDR["F_FangJianHao"]); _FangJianInfo.F_ZhengJianJiaGe = Convert.ToDouble(_SDR["F_ZhengJianJiaGe"]); _FangJianInfo.F_ChuangWei1JiaGe = Convert.ToDouble(_SDR["F_ChuangWei1JiaGe"]); _FangJianInfo.F_ChuangWei2JiaGe = Convert.ToDouble(_SDR["F_ChuangWei2JiaGe"]); _FangJianInfo.F_ChuangWei3JiaGe = Convert.ToDouble(_SDR["F_ChuangWei3JiaGe"]); _FangJianInfo.F_ChuangWei4JiaGe = Convert.ToDouble(_SDR["F_ChuangWei4JiaGe"]); _FangJianInfo.F_ChuangWei5JiaGe = Convert.ToDouble(_SDR["F_ChuangWei5JiaGe"]); _FangJianInfo.F_Detail = Convert.ToString(_SDR["F_Detail"]); _FangJianInfo.F_AddDate = Convert.ToDateTime(_SDR["F_AddDate"]); _FangJianInfo.F_ShiFouShanChu = Convert.ToBoolean(_SDR["F_ShiFouShanChu"]); } _SDR.Close(); _SDR.Dispose(); } return _FangJianInfo; }
/// <summary> /// 添加 /// </summary> /// <param name="_UserInfo">实体类</param> /// <returns></returns> public static Boolean Add(FangJianInfo _FangJianInfo) { SqlParameter[] parm ={ new SqlParameter("F_SuoShuFangXingSN",_FangJianInfo.F_SuoShuFangXingSN), new SqlParameter("F_FangJianHao",_FangJianInfo.F_FangJianHao), new SqlParameter("F_ZhengJianJiaGe",_FangJianInfo.F_ZhengJianJiaGe), new SqlParameter("F_ChuangWei1JiaGe",_FangJianInfo.F_ChuangWei1JiaGe), new SqlParameter("F_ChuangWei2JiaGe",_FangJianInfo.F_ChuangWei2JiaGe), new SqlParameter("F_ChuangWei3JiaGe",_FangJianInfo.F_ChuangWei3JiaGe), new SqlParameter("F_ChuangWei4JiaGe",_FangJianInfo.F_ChuangWei4JiaGe), new SqlParameter("F_ChuangWei5JiaGe",_FangJianInfo.F_ChuangWei5JiaGe), new SqlParameter("F_Detail",_FangJianInfo.F_Detail), new SqlParameter("F_AddDate",_FangJianInfo.F_AddDate), new SqlParameter("F_ShiFouShanChu",_FangJianInfo.F_ShiFouShanChu), }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "FangJian_Add", parm); return true; }
/// <summary> /// 添加 /// </summary> /// <param name="_UserInfo">实体类</param> /// <returns></returns> public static Boolean Add(FangJianInfo _FangJianInfo) { return FangJianData.Add(_FangJianInfo); }
/// <summary> /// 设置 /// </summary> /// <param name="_UserInfo">实体类</param> /// <returns></returns> public static Boolean Set(FangJianInfo _FangJianInfo) { return FangJianData.Set(_FangJianInfo); }
protected void AddFangJian(object sender, EventArgs e) { //首先获取每一个房间号 HashSet<string> FangJianHaos = DelSpiltChar(Texx_FangJianHao.Text); foreach(string FangJianHao in FangJianHaos){ FangJianInfo _FangJianInfo = new FangJianInfo(); _FangJianInfo.F_AddDate = DateTime.Now; _FangJianInfo.F_ZhengJianJiaGe = Convert.ToDouble(Texx_FangJianJiaGe.Text); _FangJianInfo.F_ChuangWei1JiaGe = Convert.ToDouble(Texx_ChuangWei1JiaGe.Text); _FangJianInfo.F_ChuangWei2JiaGe = Convert.ToDouble(Texx_ChuangWei2JiaGe.Text); _FangJianInfo.F_ChuangWei3JiaGe = Convert.ToDouble(Texx_ChuangWei3JiaGe.Text); _FangJianInfo.F_ChuangWei4JiaGe = Convert.ToDouble(Texx_ChuangWei4JiaGe.Text); _FangJianInfo.F_ChuangWei5JiaGe = Convert.ToDouble(Texx_ChuangWei5JiaGe.Text); _FangJianInfo.F_Detail = Texx_FangJianBeiZhu.Text; _FangJianInfo.F_FangJianHao = FangJianHao; _FangJianInfo.F_SuoShuFangXingSN = Convert.ToInt32(Texx_FangXing.Text); MyFangJian.Add(_FangJianInfo); } RegisterClientScriptBlock("", "<script>alert('操作成功!'); </script>"); CleartextBoxes(this); }