示例#1
0
 /// <summary>
 /// lay ban ghi cuoi cung
 /// </summary>
 public Entities.KiemKeKho sp_LayBang_TheoTenBang(Entities.TruyenGiaTri chuyen)
 {
     Entities.KiemKeKho giatri = new Entities.KiemKeKho();
     try
     {
         string sql = "exec sp_LayBang_TheoTenBang @table,@values";
         conn = new Connection();
         cn   = conn.openConnection();
         cmd  = new SqlCommand(sql, cn);
         cmd.Parameters.Add("table", SqlDbType.NVarChar, 100).Value = chuyen.Giatritruyen;
         cmd.Parameters.Add("values", SqlDbType.NVarChar, 50).Value = chuyen.Giatrithuhai;
         dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
         while (dr.Read())
         {
             giatri.PhieuKiemKeKhoID = int.Parse(dr[0].ToString());
             giatri.MaKiemKe         = dr[1].ToString();
             giatri.NgayKiemKe       = DateTime.Parse(dr[2].ToString());
             giatri.MaKho            = dr[3].ToString();
             giatri.GhiChu           = dr[4].ToString();
             giatri.Deleted          = Boolean.Parse(dr[5].ToString());
         }
     }
     catch (Exception ex)
     { string s = ex.Message.ToString(); giatri = null; }
     finally
     {
         cmd.Connection.Dispose();
         cn.Close();
         conn.closeConnection();
     }
     return(giatri);
 }
示例#2
0
        /// <summary>
        /// vuong hung =================================
        /// </summary>
        /// <param name="HanhDong"></param>
        /// <param name="PhieuThuID"></param>
        public int sp_Xoa_KiemKeKho(Entities.KiemKeKho ddh)
        {
            int Trave = 0;

            try
            {
                dh  = new Constants.KiemKeKho();
                Sql = new Constants.Sql();
                string sql = Sql.sp_Xoa_KiemKeKho;
                conn = new Connection();
                cn   = conn.openConnection();
                cmd  = new SqlCommand(sql, cn);
                cmd.Parameters.Add(dh.HanhDong, SqlDbType.NVarChar, 20).Value = ddh.Hanhdong;
                cmd.Parameters.Add(dh.MaKiemKe, SqlDbType.VarChar).Value      = ddh.MaKiemKe;
                Trave = cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            { string s = ex.Message.ToString(); }
            finally
            {
                cmd.Connection.Dispose();
                cn.Close();
                conn.closeConnection();
            }
            return(Trave);
        }
示例#3
0
        /// <summary>
        /// vuong hung =================xu ly don dat hang================
        /// </summary>
        /// <returns></returns>
        public int sp_XuLy_KiemKeKho(Entities.KiemKeKho ddh)
        {
            int Trave = 0;

            try
            {
                Sql = new Constants.Sql();
                string sql = Sql.sp_XuLy_KiemKeKho;
                conn = new Connection();
                cn   = conn.openConnection();
                dh   = new Constants.KiemKeKho();
                cmd  = new SqlCommand(sql, cn);
                cmd.Parameters.Add(dh.HanhDong, SqlDbType.NVarChar, 20).Value = ddh.Hanhdong;
                cmd.Parameters.Add(dh.PhieuKiemKeKhoID, SqlDbType.Int).Value  = ddh.PhieuKiemKeKhoID;
                cmd.Parameters.Add(dh.MaKiemKe, SqlDbType.VarChar, 20).Value  = ddh.MaKiemKe;
                cmd.Parameters.Add(dh.NgayKiemKe, SqlDbType.DateTime).Value   = ddh.NgayKiemKe;
                cmd.Parameters.Add(dh.MaKho, SqlDbType.VarChar).Value         = ddh.MaKho;
                cmd.Parameters.Add(dh.GhiChu, SqlDbType.NVarChar, 100).Value  = ddh.GhiChu;
                cmd.Parameters.Add(dh.Deleted, SqlDbType.Bit).Value           = ddh.Deleted;
                Trave = cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            { string s = ex.Message.ToString(); }
            finally
            {
                cmd.Connection.Dispose();
                cn.Close();
                conn.closeConnection();
            }
            return(Trave);
        }
示例#4
0
 /// <summary>
 /// khoi tao gia tri
 /// </summary>
 public KiemKeKho()
 {
     dh         = null;
     Sql        = null;
     conn       = null;
     cmd        = null;
     arr        = null;
     dr         = null;
     dondathang = null;
     cn         = null;
 }
示例#5
0
 /// <summary>
 /// khoi tao gia tri
 /// </summary>
 public KiemKeKho()
 {
     dh = null;
     Sql = null;
     conn = null;
     cmd = null;
     arr = null;
     dr = null;
     dondathang = null;
     cn = null;
 }
示例#6
0
 /// <summary>
 /// vuong hung =================lay bang DonDatHang================
 /// </summary>
 /// <returns></returns>
 public Entities.KiemKeKho[] sp_LayBang_KiemKeKho(Entities.KiemKeKho kk)
 {
     Entities.KiemKeKho[] arrC = null;
     try
     {
         dh  = new Constants.KiemKeKho();
         Sql = new Constants.Sql();
         string sql = Sql.sp_LayBang_KiemKeKho;
         conn = new Connection();
         cn   = conn.openConnection();
         cmd  = new SqlCommand(sql, cn);
         cmd.Parameters.Add(dh.MaKiemKe, SqlDbType.VarChar, 20).Value = kk.MaKiemKe;
         dr  = cmd.ExecuteReader(CommandBehavior.CloseConnection);
         arr = new ArrayList();
         while (dr.Read())
         {
             dondathang = new Entities.KiemKeKho();
             dondathang.PhieuKiemKeKhoID = Convert.ToInt32(dr[dh.PhieuKiemKeKhoID].ToString());
             dondathang.MaKiemKe         = "" + dr[dh.MaKiemKe].ToString();
             dondathang.NgayKiemKe       = System.Convert.ToDateTime("" + dr[dh.NgayKiemKe].ToString());
             dondathang.MaKho            = dr[dh.MaKho].ToString();
             dondathang.Tenkho           = dr[dh.TenKho].ToString();
             dondathang.GhiChu           = "" + dr[dh.GhiChu].ToString();
             dondathang.Deleted          = Convert.ToBoolean(dr[dh.Deleted].ToString());
             arr.Add(dondathang);
         }
         int n = arr.Count;
         if (n == 0)
         {
             return(null);
         }
         arrC = new Entities.KiemKeKho[n];
         for (int i = 0; i < n; i++)
         {
             arrC[i] = (Entities.KiemKeKho)arr[i];
         }
     }
     catch (Exception ex)
     { string s = ex.Message.ToString(); }
     finally
     {
         cmd.Connection.Dispose();
         cn.Close();
         conn.closeConnection();
     }
     return(arrC);
 }
示例#7
0
 public Entities.KiemKeKho[] Select()
 {
     Entities.KiemKeKho[] arrC = null;
     try
     {
         dh = new Constants.KiemKeKho();
         Sql = new Constants.Sql();
         string sql = "Select * from KiemKeKho where Deleted = 0";
         conn = new Connection();
         cn = conn.openConnection();
         cmd = new SqlCommand(sql, cn);
         dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
         arr = new ArrayList();
         while (dr.Read())
         {
             dondathang = new Entities.KiemKeKho();
             dondathang.PhieuKiemKeKhoID = Convert.ToInt32(dr[dh.PhieuKiemKeKhoID].ToString());
             dondathang.MaKiemKe = "" + dr[dh.MaKiemKe].ToString();
             dondathang.NgayKiemKe = System.Convert.ToDateTime("" + dr[dh.NgayKiemKe].ToString());
             dondathang.MaKho = dr[dh.MaKho].ToString();
             dondathang.Tenkho = dr[dh.TenKho].ToString();
             dondathang.GhiChu = "" + dr[dh.GhiChu].ToString();
             dondathang.Deleted = Convert.ToBoolean(dr[dh.Deleted].ToString());
             arr.Add(dondathang);
         }
         int n = arr.Count;
         if (n == 0) { return null; }
         arrC = new Entities.KiemKeKho[n];
         for (int i = 0; i < n; i++)
         {
             arrC[i] = (Entities.KiemKeKho)arr[i];
         }
     }
     catch (Exception ex)
     { string s = ex.Message.ToString(); }
     finally
     {
         cmd.Connection.Dispose();
         cn.Close();
         conn.closeConnection();
     }
     return arrC;
 }
示例#8
0
 /// <summary>
 /// lay ban ghi cuoi cung
 /// </summary>
 public Entities.KiemKeKho sp_LayBang_TheoTenBang(Entities.TruyenGiaTri chuyen)
 {
     Entities.KiemKeKho giatri = new Entities.KiemKeKho();
     try
     {
         string sql = "exec sp_LayBang_TheoTenBang @table,@values";
         conn = new Connection();
         cn = conn.openConnection();
         cmd = new SqlCommand(sql, cn);
         cmd.Parameters.Add("table", SqlDbType.NVarChar, 100).Value = chuyen.Giatritruyen;
         cmd.Parameters.Add("values", SqlDbType.NVarChar, 50).Value = chuyen.Giatrithuhai;
         dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
         while (dr.Read())
         {
             giatri.PhieuKiemKeKhoID = int.Parse(dr[0].ToString());
             giatri.MaKiemKe = dr[1].ToString();
             giatri.NgayKiemKe = DateTime.Parse(dr[2].ToString());
             giatri.MaKho = dr[3].ToString();
             giatri.GhiChu = dr[4].ToString();
             giatri.Deleted = Boolean.Parse(dr[5].ToString());
         }
     }
     catch (Exception ex)
     { string s = ex.Message.ToString(); giatri = null; }
     finally
     {
         cmd.Connection.Dispose();
         cn.Close();
         conn.closeConnection();
     }
     return giatri;
 }