Exemple #1
0
        private void cmdNhapKetLuan_Click(object sender, EventArgs e)
        {
            int record = new Update(TAssignDetail.Schema)
                         .Set(TAssignDetail.Columns.Summary).EqualTo(txtKetLuan.Text)
                         .Set(TAssignDetail.Columns.BsThucHien).EqualTo(globalVariables.UserName)
                         .Set(TAssignDetail.Columns.NgayThucHien).EqualTo(BusinessHelper.GetSysDateTime())
                         .Where(TAssignDetail.Columns.AssignDetailId).IsEqualTo(AssignDetail_ID).Execute();

            if (record > 0)
            {
                DataRow[] arr = P_dtDataTable.Select("AssignDetail_ID=" + AssignDetail_ID);
                if (arr.GetLength(0) > 0)
                {
                    arr[0][TAssignDetail.Columns.Summary]      = txtKetLuan.Text;
                    arr[0][TAssignDetail.Columns.NgayThucHien] = BusinessHelper.GetSysDateTime();
                    arr[0][TAssignDetail.Columns.BsThucHien]   = globalVariables.UserName;
                }
                P_dtDataTable.AcceptChanges();
                Utility.ShowMsg("Bạn thực hiện thành công", "Thông báo");
            }
        }
Exemple #2
0
        private void cmdNhapKetLuan_Click(object sender, EventArgs e)
        {
            int record = new Update(KcbChidinhclsChitiet.Schema)
                         //.Set(KcbChidinhclsChitiet.Columns.KetLuan).EqualTo(txtKetLuan.Text)
                         .Set(KcbChidinhclsChitiet.Columns.NguoiThuchien).EqualTo(globalVariables.UserName)
                         .Set(KcbChidinhclsChitiet.Columns.IdBacsiThuchien).EqualTo(globalVariables.gv_intIDNhanvien)
                         .Set(KcbChidinhclsChitiet.Columns.NgayThuchien).EqualTo(globalVariables.SysDate)
                         .Where(KcbChidinhclsChitiet.Columns.IdChitietchidinh).IsEqualTo(AssignDetail_ID).Execute();

            if (record > 0)
            {
                DataRow[] arr = P_dtDataTable.Select("AssignDetail_ID=" + AssignDetail_ID);
                if (arr.GetLength(0) > 0)
                {
                    //arr[0][KcbChidinhclsChitiet.Columns.KetLuan] = txtKetLuan.Text;
                    arr[0][KcbChidinhclsChitiet.Columns.NgayThuchien]    = globalVariables.SysDate;
                    arr[0][KcbChidinhclsChitiet.Columns.NguoiThuchien]   = globalVariables.UserName;
                    arr[0][KcbChidinhclsChitiet.Columns.IdBacsiThuchien] = globalVariables.gv_intIDNhanvien;
                }
                P_dtDataTable.AcceptChanges();
                Utility.ShowMsg("Bạn thực hiện thành công", "Thông báo");
            }
        }