Exemplo n.º 1
0
 protected void btnThem_Click(object sender, EventArgs e)
 {
     DRDTO drn = new DRDTO();
     drn.MaClaim = ClaimID.ToString();
     drn.MaLoaiDR = int.Parse(drTypeDR.SelectedItem.Value.ToString());
     drn.MaItem = int.Parse(drItems.SelectedItem.Value.ToString());
     string tendr = txtItem.Text;
     if (tendr != "")
     {
         drn.TenDR = tendr;
         bool ins = dr.Insert(drn);
         if (ins == true)
         {
             int maGDV = int.Parse(Request.Cookies["MaGDV"].Value);
             string noidung = gdv.LayTenTheoMa(maGDV) + " created item docsrequest of case " + ClaimID.ToString() + ".";
             SaveLogTracking(maGDV, noidung, ClaimID.ToString());
             txtItem.Text = "";
             loadLoaiDR(ClaimID);
             gvDRUpdate.Visible = false;
             gvDRList.Visible = true;
         }
     }
     else
         Response.Write("<script> alert('Enter item document request!');</script>");
 }
Exemplo n.º 2
0
 public bool UpdateDocsRequest(DRDTO dr)
 {
     string sql = "sp_DocsRequest_Update";
     List<SqlParameter> ds = new List<SqlParameter>();
     SqlParameter id = new SqlParameter("@maDR", SqlDbType.Int);
     id.Value = dr.MaDR;
     ds.Add(id);
     SqlParameter ten = new SqlParameter("@tendr", SqlDbType.NVarChar);
     ten.Value = dr.TenDR;
     ds.Add(ten);
     SqlParameter tinhtrang = new SqlParameter("@tinhtrang", SqlDbType.NVarChar);
     tinhtrang.Value = dr.TinhTrang;
     ds.Add(tinhtrang);
     SqlParameter ngaynhan = new SqlParameter("@ngaynhan", SqlDbType.Date);
     ngaynhan.Value = dr.NgayNhan;
     ds.Add(ngaynhan);
     return SqlDataAcessHelper.exNonStoreParas(sql, ds);
 }
Exemplo n.º 3
0
        public bool Insert(DRDTO dr)
        {
            string sql = "sp_DocsRequest_Insert";
            List<SqlParameter> ds = new List<SqlParameter>();
            SqlParameter maloaidr = new SqlParameter("@maloaiDR", SqlDbType.Int);
            maloaidr.Value = dr.MaLoaiDR;
            ds.Add(maloaidr);

            SqlParameter maitem = new SqlParameter("@maitem", SqlDbType.Int);
            maitem.Value = dr.MaItem;
            ds.Add(maitem);

            SqlParameter maclaim = new SqlParameter("@maclaim", SqlDbType.NVarChar);
            maclaim.Value = dr.MaClaim;
            ds.Add(maclaim);
            SqlParameter ten = new SqlParameter("@tenDR", SqlDbType.NVarChar);
            ten.Value = dr.TenDR;
            ds.Add(ten);
            return SqlDataAcessHelper.exNonStoreParas(sql, ds);
        }
Exemplo n.º 4
0
 protected void gvDRUpdate_RowUpdating(object sender, GridViewUpdateEventArgs e)
 {
     GridViewRow row = gvDRUpdate.Rows[e.RowIndex];
     TextBox txttendr = row.Cells[2].Controls[0] as TextBox;
     TextBox txttinhtrang = row.Cells[3].Controls[0] as TextBox;
     TextBox txtngay = (TextBox)row.FindControl("txtNgay");
     DRDTO drdto = new DRDTO();
     drdto.MaDR = int.Parse(gvDRUpdate.DataKeys[e.RowIndex].Value.ToString());
     drdto.TenDR = txttendr.Text;
     drdto.TinhTrang = txttinhtrang.Text;
     string ngaynhan=txtngay.Text;
     if (ngaynhan != "")
         drdto.NgayNhan = DateTime.Parse(txtngay.Text);
     else
         Response.Write("<script>alert('Enter date received!');</script>");
     bool up = dr.UpdateDocsRequest(drdto);
     if (up == true)
     {
         int maGDV = int.Parse(Request.Cookies["MaGDV"].Value);
         string noidung = gdv.LayTenTheoMa(maGDV) + " edited item docsrequest of case " + ClaimID.ToString() + ".";
         SaveLogTracking(maGDV, noidung, ClaimID.ToString());
         e.Cancel = true;
         gvDRUpdate.EditIndex = -1;
         loadLoaiDR(ClaimID);
         LoadDRUpdate(ClaimID);
         gvDRUpdate.Visible = true;
         gvDRList.Visible = false;
     }
     else
         Response.Write("<script>alert('Update failed!');</script>");
 }