Esempio n. 1
0
        public bool Insert(LossListDTO l)
        {
            string sql = "sp_LostList_Insert";
            List<SqlParameter> ds = new List<SqlParameter>();

            SqlParameter diengiai = new SqlParameter("@diengiai", SqlDbType.NVarChar);
            diengiai.Value=l.TenHangMuc;
            ds.Add(diengiai);

            SqlParameter soluong= new SqlParameter("@soluong", SqlDbType.Float);
            soluong.Value=l.SoLuong;
            ds.Add(soluong);

            SqlParameter donvi= new SqlParameter("@donvi", SqlDbType.Int);
            donvi.Value=l.MaDonViTinh;
            ds.Add(donvi);

            SqlParameter ghichu= new SqlParameter("@ghichu", SqlDbType.NVarChar);
            ghichu.Value=l.GhiChu;
            ds.Add(ghichu);

            SqlParameter loai= new SqlParameter("@loai", SqlDbType.Int);
            loai.Value=l.LoaiHangMuc;
            ds.Add(loai);

            SqlParameter idclaim= new SqlParameter("@idclaim", SqlDbType.VarChar);
            idclaim.Value=l.MaClaim;
            ds.Add(idclaim);
            bool kq = false;
            kq = SqlDataAcessHelper.exNonStoreParas(sql, ds);
            return kq;
        }
 protected void btnInsertItem_Click(object sender, EventArgs e)
 {
     if (this.IsPostBack)
     {
         LossListDTO l = new LossListDTO();
         LossListDAO ldao = new LossListDAO();
         string tenhangmuc = txtDescription.Text;
         if (tenhangmuc != "")
         {
             l.TenHangMuc = tenhangmuc;
             float sl = 0;
             if (txtSoLuong.Text != "" && float.TryParse(txtSoLuong.Text, out sl))
             {
                 l.SoLuong = sl;
                 l.MaDonViTinh = int.Parse(drUnit.SelectedItem.Value.ToString());
                 string ghichu = txtGhiChu.Text;
                 if (ghichu != "")
                     l.GhiChu = ghichu;
                 else
                     l.GhiChu = "";
                 l.LoaiHangMuc = int.Parse(drTypeItem.SelectedItem.Value.ToString());
                 l.MaClaim = lblIDClaim.Text;
                 bool kq = ldao.Insert(l);
                 if (kq == true)
                 {
                     int maGDV = int.Parse(Request.Cookies["MaGDV"].Value);
                     string noidung = gdv.LayTenTheoMa(maGDV) + " created item loss worksheet of case " + lblIDClaim.Text + ".";
                     SaveLogTracking(maGDV, noidung, lblIDClaim.Text);
                     LoadItem(lblIDClaim.Text);
                     ClearInputs(Page.Controls);
                 }
                 else
                     Response.Write("<script>alert('Nhập đủ các vị trí có (*)!');</script>");
             }
             else
                 Response.Write("<script>alert('Nhập sai định dạng sô!');</script>");
         }
         else
             Response.Write("<script>alert('Không bỏ trống tên hạng mục tổn thất!');</script>");
     }
 }
Esempio n. 3
0
        public bool Update(LossListDTO l)
        {
            string sql = "sp_LostList_Update";
            List<SqlParameter> ds = new List<SqlParameter>();

            SqlParameter diengiai = new SqlParameter("@diengiai", SqlDbType.NVarChar);
            diengiai.Value = l.TenHangMuc;
            ds.Add(diengiai);

            SqlParameter soluong = new SqlParameter("@soluong", SqlDbType.Float);
            soluong.Value = l.SoLuong;
            ds.Add(soluong);

            SqlParameter ghichu = new SqlParameter("@ghichu", SqlDbType.NVarChar);
            ghichu.Value = l.GhiChu;
            ds.Add(ghichu);

            SqlParameter id = new SqlParameter("@malostlist", SqlDbType.Int);
            id.Value = l.MaLossList;
            ds.Add(id);
            bool kq = false;
            kq = SqlDataAcessHelper.exNonStoreParas(sql, ds);
            return kq;
        }
 protected void grDSItem_RowUpdating(object sender, GridViewUpdateEventArgs e)
 {
     if (this.IsPostBack)
     {
         GridViewRow row = grDSItem.Rows[e.RowIndex];
         TextBox txtTenHangMuc2 = row.Cells[1].Controls[0] as TextBox;
         TextBox txtsoluong2 = row.Cells[2].Controls[0] as TextBox;
         TextBox txtghichu2 = row.Cells[5].Controls[0] as TextBox;
         int ma = int.Parse(grDSItem.DataKeys[e.RowIndex].Value.ToString());
         LossListDTO l = new LossListDTO();
         l.MaLossList = ma;
         l.TenHangMuc = txtTenHangMuc2.Text;
         l.SoLuong = float.Parse(txtsoluong2.Text);
         l.GhiChu = txtghichu2.Text;
         bool kq = ld.Update(l);
         if (kq == true)
         {
             e.Cancel = true;
             grDSItem.EditIndex = -1;
             LoadItem(lblIDClaim.Text);
             int maGDV = int.Parse(Request.Cookies["MaGDV"].Value);
             string noidung = gdv.LayTenTheoMa(maGDV) + " edited item loss worksheet of case " + lblIDClaim.Text + ".";
             SaveLogTracking(maGDV, noidung, lblIDClaim.Text);
         }
     }
 }