コード例 #1
0
 /// <summary>
 /// 设置
 /// </summary>
 /// <param name="_UserInfo">实体类</param>
 /// <returns></returns>
 public static Boolean Set(DingDanLogsInfo _DingDanLogsInfo)
 {
     SqlParameter[] parm ={
                              new SqlParameter("D_SN",_DingDanLogsInfo.D_SN),
                              new SqlParameter("D_DingDanSN",_DingDanLogsInfo.D_DingDanSN),
                              new SqlParameter("D_DingDanShuoMing",_DingDanLogsInfo.D_DingDanShuoMing),
                              new SqlParameter("D_AddIP",_DingDanLogsInfo.D_AddIP),
                              new SqlParameter("D_AddDate",_DingDanLogsInfo.D_AddDate),
                           };
     SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "DingDanLogs_Set", parm);
     return true;
 }
コード例 #2
0
        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="_UserInfo">实体类</param>
        /// <returns></returns>
        public static Int32 Add(DingDanLogsInfo _DingDanLogsInfo)
        {
            SqlParameter[] parm ={
                                     new SqlParameter("D_DingDanSN",_DingDanLogsInfo.D_DingDanSN),
                                     new SqlParameter("D_DingDanShuoMing",_DingDanLogsInfo.D_DingDanShuoMing),
                                     new SqlParameter("D_AddIP",_DingDanLogsInfo.D_AddIP),
                                     new SqlParameter("D_AddDate",_DingDanLogsInfo.D_AddDate),
                                  };

            Int32 D_SN = Int32.Parse(SqlHelper.ExecuteScalar(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "DingDanLogs_Add", parm).ToString());
            return D_SN;
        }
コード例 #3
0
 /// <summary>
 /// 获取
 /// </summary>
 /// <param name="_D_SN">SN</param>
 /// <returns></returns>
 public static DingDanLogsInfo Get(Int32 _D_SN)
 {
     DingDanLogsInfo _DingDanLogsInfo = new DingDanLogsInfo();
     SqlParameter[] parm = { new SqlParameter("D_SN", _D_SN), };
     using (SqlDataReader _SDR = SqlHelper.ExecuteReader(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "DingDanLogs_Get", parm))
     {
         if (_SDR.Read())
         {
             _DingDanLogsInfo.D_SN = Convert.ToInt32(_SDR["D_SN"]);
             _DingDanLogsInfo.D_DingDanSN = Convert.ToInt32(_SDR["D_DingDanSN"]);
             _DingDanLogsInfo.D_DingDanShuoMing = Convert.ToString(_SDR["D_DingDanShuoMing"]);
             _DingDanLogsInfo.D_AddIP = Convert.ToString(_SDR["D_AddIP"]);
             _DingDanLogsInfo.D_AddDate = Convert.ToDateTime(_SDR["D_AddDate"]);
         }
         _SDR.Close();
         _SDR.Dispose();
     }
     return _DingDanLogsInfo;
 }
コード例 #4
0
 /// <summary>
 /// 设置
 /// </summary>
 /// <param name="_UserInfo">实体类</param>
 /// <returns></returns>
 public static Boolean Set(DingDanLogsInfo _DingDanLogsInfo)
 {
     return DingDanLogsData.Set(_DingDanLogsInfo);
 }
コード例 #5
0
 /// <summary>
 /// 添加
 /// </summary>
 /// <param name="_UserInfo">实体类</param>
 /// <returns></returns>
 public static Int32 Add(DingDanLogsInfo _DingDanLogsInfo)
 {
     return DingDanLogsData.Add(_DingDanLogsInfo);
 }