public static void UpdateInfo_Duyet(PLInfoBox Info, DOChiTietCongViec Phieu) { try { string Duyet1 = "4"; try { Duyet1 = Phieu.GetType().GetProperty("DUYET").GetValue(Phieu, null).ToString().Trim(); } catch { } string NguoiCapNhat = GetFullName(Phieu.GetType().GetProperty("NGUOI_CAP_NHAT").GetValue(Phieu, null)); string NgayCapNhat = Phieu.GetType().GetProperty("NGAY_CAP_NHAT").GetValue(Phieu, null).ToString(); if (Duyet1 == "2" || Duyet1 == "3") { Info._init(NguoiCapNhat, NgayCapNhat, GetFullName(Phieu.GetType().GetProperty("NGUOI_DUYET").GetValue(Phieu, null)), Phieu.GetType().GetProperty("NGAY_DUYET").GetValue(Phieu, null).ToString()); } else { Info._init(NguoiCapNhat, NgayCapNhat); } } catch { } }
public void InnitDodata(DateTime ngaylamviec, long ID_NV, long CTCCV_ID) { DataSet ds = new DataSet(); if (CTCCV_ID != -1 && Is_Add == false) { chitietcongviec = DAChiTietCongViec.Instance.GetCTCV(ngaylamviec, ID_NV, CTCCV_ID); ds = DAChiTietCongViec.Instance.GetData_Update(CTCCV_ID); lblThoiGianCapNhat.Text = System.Convert.ToDateTime(chitietcongviec.NGAY_CAP_NHAT).ToString(PLConst.FORMAT_DATETIME_STRING); } else { ds = DAChiTietCongViec.Instance.GetData(ngaylamviec, ID_NV); lblThoiGianCapNhat.Text = System.Convert.ToDateTime(ds.Tables[0].Rows[0]["NGAY_CAP_NHAT"]).ToString(PLConst.FORMAT_DATETIME_STRING); } //else if (ngaylamviec.ToString() != "" && ID_NV.ToString() != "") //{ // chitietcongviec = DAChiTietCongViec.Instance.GetCTCV(ngaylamviec, ID_NV, -1); // ds = DAChiTietCongViec.Instance.GetData(ngaylamviec, ID_NV); //} NgayNhap.DateTime = ngaylamviec; this.gridDSCongviec.DataSource = ds.Tables[0]; //if (ds.Tables[0].Rows.Count > 0) //{ // Info.Enabled = true; // PLTimeSheetUtil.UpdateInfo_Duyet(Info, chitietcongviec); // foreach (DataRow r in ds.Tables[0].Rows) // { // if (r["DUYET"].ToString() == "1") // { // chitietcongviec._DUYET = "1"; // Duyet.SetDuyet(chitietcongviec); // Allow(true, gridViewDSCongviec); // break; // } // else if (r["DUYET"].ToString() == "2") // { // Duyet.SetDuyet(chitietcongviec); // Allow(false, gridViewDSCongviec); // break; // } // else if (r["DUYET"].ToString() == "3") // { // Duyet.SetDuyet(chitietcongviec); // Allow(true, gridViewDSCongviec); // break; // } // } //} //else //{ // Info.Enabled = false; // chitietcongviec._DUYET = "1"; // Duyet.SetDuyet(chitietcongviec); // Allow(true, gridViewDSCongviec); //} }
private void btnSave_Click(object sender, EventArgs e) { chitietcongviec = GetCTCV(NgayNhap.DateTime, NhanVien._getSelectedID()); Duyet.GetDuyet(chitietcongviec); bool flag = false; DataSet ds =((DataView)gridViewDSCongviec.DataSource).Table.DataSet; foreach (DataRow row in ds.Tables[0].Rows) { if (row.RowState != DataRowState.Unchanged) { if (row.RowState == DataRowState.Added) { flag = Insert_Code("", row["DA_ID"], row["CV_ID"], NhanVien._getSelectedID() , row["MO_TA"].ToString(), row["BAT_DAU"], row["KET_THUC"] , row["THOI_GIAN_THUC_HIEN"], NgayNhap.DateTime,chitietcongviec._DUYET, 1); } else if (row.RowState == DataRowState.Modified) { flag = Insert_Code(row["CTCCV_ID"], row["DA_ID"], row["CV_ID"], NhanVien._getSelectedID() , row["MO_TA"].ToString(), row["BAT_DAU"], row["KET_THUC"] , row["THOI_GIAN_THUC_HIEN"], "", chitietcongviec._DUYET, 2); } else if (row.RowState == DataRowState.Deleted) { DataSet dsCV = null; dsCV = GetData(NgayNhap.DateTime,NhanVien._getSelectedID()); foreach (DataRow r in dsCV.Tables[0].Rows) { DataRow[] deleterow = ds.Tables[0].Select("CTCCV_ID = " + r["CTCCV_ID"].ToString()); if (deleterow.Length == 0) { flag = Insert_Code(r["CTCCV_ID"], "", "", "", "", "", "", "", "", "", 3); } } } } else { if(flag!=false) flag = true; } } if (flag != true) HelpMsgBox.ShowErrorMessage("Lưu Không thành công. Vui lòng kiểm tra số liệu!"); else { this.Close(); } }
public static DOChiTietCongViec GetCTCV(DateTime ngaylamviec, long nv_id) { DOChiTietCongViec ctcv = null; try { string sql = "select DUYET,NGAY_DUYET,NGUOI_DUYET,NGAY_CAP_NHAT,NGUOI_CAP_NHAT from KE_HOACH_LAM_VIEC where NGAY_LAM_VIEC='" + ngaylamviec.ToString("MM/dd/yyyy") + "'and NV_ID=" + nv_id; ctcv = new DOChiTietCongViec(); DatabaseFB db = HelpDB.getDatabase(); DbCommand cmd = db.GetSQLStringCommand(sql); DataSet ds = new DataSet(); db.LoadDataSet(cmd, ds, "a"); //if(ds.Tables[0].Rows.Count>0) foreach (DataRow dr in ds.Tables[0].Rows) { ctcv._DUYET = dr["DUYET"].ToString(); ctcv._NGAY_CAP_NHAT = Convert.ToDateTime(dr["NGAY_CAP_NHAT"]); ctcv._NGUOI_CAP_NHAT = HelpNumber.ParseInt64(dr["NGUOI_CAP_NHAT"].ToString()); if (dr["NGAY_DUYET"].ToString()!="") ctcv._NGAY_DUYET = Convert.ToDateTime(dr["NGAY_DUYET"]); if (dr["NGUOI_DUYET"].ToString() != "") ctcv._NGUOI_DUYET = HelpNumber.ParseInt64(dr["NGUOI_DUYET"].ToString()); break; } } catch (Exception) { throw; } return ctcv; }
public void InnitDodata(DateTime ngaylamviec,long ID_NV) { if (ngaylamviec.ToString() != "" && ID_NV.ToString() != "") { chitietcongviec = GetCTCV(ngaylamviec, ID_NV); DataSet ds = GetData(ngaylamviec,ID_NV); NgayNhap.DateTime = ngaylamviec; NhanVien._setSelectedID(ID_NV); this.gridDSCongviec.DataSource = ds.Tables[0]; if (ds.Tables[0].Rows.Count > 0) { Info.Enabled = true; PLTimeSheetUtil.UpdateInfo_Duyet(Info, chitietcongviec); foreach (DataRow r in ds.Tables[0].Rows) { if (r["DUYET"].ToString() == "1") { chitietcongviec._DUYET = "1"; Duyet.SetDuyet(chitietcongviec); Allow(true, gridViewDSCongviec); btnDuyet.Text = "Duyệt"; break; } else if (r["DUYET"].ToString() == "2") { Duyet.SetDuyet(chitietcongviec); Allow(false, gridViewDSCongviec); btnDuyet.Text = "Không Duyệt"; break; } else if (r["DUYET"].ToString() == "3") { Duyet.SetDuyet(chitietcongviec); Allow(true, gridViewDSCongviec); btnDuyet.Text = "Duyệt"; break; } } btnDuyet.Enabled = true; } else { Info.Enabled = false; chitietcongviec._DUYET = "1"; Duyet.SetDuyet(chitietcongviec); Allow(true,gridViewDSCongviec); btnDuyet.Enabled = false; } } }