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"); } }
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"); } }