コード例 #1
0
        /// <summary>
        /// 获取
        /// </summary>
        /// <param name="_F_SN">SN</param>
        /// <returns></returns>
        public static FangXingInfo Get(Int32 _F_SN)
        {
            FangXingInfo _FangXingInfo = new FangXingInfo();

            SqlParameter[] parm = { new SqlParameter("F_SN", _F_SN), };
            using (SqlDataReader _SDR = SqlHelper.ExecuteReader(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "FangXing_Get", parm))
            {
                if (_SDR.Read())
                {
                    _FangXingInfo.F_SN               = Convert.ToInt32(_SDR["F_SN"]);
                    _FangXingInfo.F_SuoShuBuMenSN    = Convert.ToInt32(_SDR["F_SuoShuBuMenSN"]);
                    _FangXingInfo.F_SuoShuXiTongSN   = Convert.ToInt32(_SDR["F_SuoShuXiTongSN"]);
                    _FangXingInfo.F_SuoShuBingGuanSN = Convert.ToInt32(_SDR["F_SuoShuBingGuanSN"]);
                    _FangXingInfo.F_Name             = Convert.ToString(_SDR["F_Name"]);
                    _FangXingInfo.F_Detail           = Convert.ToString(_SDR["F_Detail"]);
                    _FangXingInfo.F_ZhengJianJiaGe   = Convert.ToDouble(_SDR["F_ZhengJianJiaGe"]);
                    _FangXingInfo.F_ChuangWei1JiaGe  = Convert.ToDouble(_SDR["F_ChuangWei1JiaGe"]);
                    _FangXingInfo.F_ChuangWei2JiaGe  = Convert.ToDouble(_SDR["F_ChuangWei2JiaGe"]);
                    _FangXingInfo.F_ChuangWei3JiaGe  = Convert.ToDouble(_SDR["F_ChuangWei3JiaGe"]);
                    _FangXingInfo.F_ChuangWei4JiaGe  = Convert.ToDouble(_SDR["F_ChuangWei4JiaGe"]);
                    _FangXingInfo.F_ChuangWei5JiaGe  = Convert.ToDouble(_SDR["F_ChuangWei5JiaGe"]);
                    _FangXingInfo.F_ShiFouShanChu    = Convert.ToBoolean(_SDR["F_ShiFouShanChu"]);
                    _FangXingInfo.F_AddDate          = Convert.ToDateTime(_SDR["F_AddDate"]);
                }
                _SDR.Close();
                _SDR.Dispose();
            }
            return(_FangXingInfo);
        }
コード例 #2
0
    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);
    }
コード例 #3
0
 /// <summary>
 /// 添加
 /// </summary>
 /// <param name="_UserInfo">实体类</param>
 /// <returns></returns>
 public static Boolean Add(FangXingInfo _FangXingInfo)
 {
     SqlParameter[] parm =
     {
         new SqlParameter("F_SuoShuBuMenSN",    _FangXingInfo.F_SuoShuBuMenSN),
         new SqlParameter("F_SuoShuXiTongSN",   _FangXingInfo.F_SuoShuXiTongSN),
         new SqlParameter("F_SuoShuBingGuanSN", _FangXingInfo.F_SuoShuBingGuanSN),
         new SqlParameter("F_Name",             _FangXingInfo.F_Name),
         new SqlParameter("F_Detail",           _FangXingInfo.F_Detail),
         new SqlParameter("F_ZhengJianJiaGe",   _FangXingInfo.F_ZhengJianJiaGe),
         new SqlParameter("F_ChuangWei1JiaGe",  _FangXingInfo.F_ChuangWei1JiaGe),
         new SqlParameter("F_ChuangWei2JiaGe",  _FangXingInfo.F_ChuangWei2JiaGe),
         new SqlParameter("F_ChuangWei3JiaGe",  _FangXingInfo.F_ChuangWei3JiaGe),
         new SqlParameter("F_ChuangWei4JiaGe",  _FangXingInfo.F_ChuangWei4JiaGe),
         new SqlParameter("F_ChuangWei5JiaGe",  _FangXingInfo.F_ChuangWei5JiaGe),
         new SqlParameter("F_ShiFouShanChu",    _FangXingInfo.F_ShiFouShanChu),
         new SqlParameter("F_AddDate",          _FangXingInfo.F_AddDate),
     };
     SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "FangXing_Add", parm);
     return(true);
 }
コード例 #4
0
ファイル: MyFangXing.cs プロジェクト: ichoukou/DingFangXiTong
 /// <summary>
 /// 设置
 /// </summary>
 /// <param name="_UserInfo">实体类</param>
 /// <returns></returns>
 public static Boolean Set(FangXingInfo _FangXingInfo)
 {
     return(FangXingData.Set(_FangXingInfo));
 }
コード例 #5
0
ファイル: MyFangXing.cs プロジェクト: ichoukou/DingFangXiTong
 /// <summary>
 /// 添加
 /// </summary>
 /// <param name="_UserInfo">实体类</param>
 /// <returns></returns>
 public static Boolean Add(FangXingInfo _FangXingInfo)
 {
     return(FangXingData.Add(_FangXingInfo));
 }