public void SaveDataComplete(List <HRTimeKeeperCompletesInfo> timeKeepeCompleterList) { List <HRTimeKeeperCompletesInfo> TimeKeeperCompleteList = new List <HRTimeKeeperCompletesInfo>(); if (timeKeepeCompleterList != null) { TimeKeeperCompleteList.AddRange(timeKeepeCompleterList); //TimeKeeperCompleteList.SaveItemObjects(); HRTimeKeeperCompletesController objTimeKeeperCompletesController = new HRTimeKeeperCompletesController(); int percent = 0; string mess = "Đang lưu dữ liệu: "; foreach (HRTimeKeeperCompletesInfo item in TimeKeeperCompleteList) { percent++; objTimeKeeperCompletesController.CreateObject(item); if (TimeKeeperCompleteBackupList2.Where(o => o.HRTimeKeeperCompleteDate == item.HRTimeKeeperCompleteDate && o.HRTimeKeeperCompletesEmployeeCardNo == item.HRTimeKeeperCompletesEmployeeCardNo && o.FK_HRTimeKeeperID == item.FK_HRTimeKeeperID && o.HRTimeKeeperCompleteDateCheck == item.HRTimeKeeperCompleteDateCheck).Count() > 0 && TimeKeeperCompleteBackupList.Where(o => o.HRTimeKeeperCompleteDate == item.HRTimeKeeperCompleteDate && o.HRTimeKeeperCompletesEmployeeCardNo == item.HRTimeKeeperCompletesEmployeeCardNo && o.FK_HRTimeKeeperID == item.FK_HRTimeKeeperID && o.HRTimeKeeperCompleteDateCheck == item.HRTimeKeeperCompleteDateCheck).Count() > 0) { HRTimeKeeperCompletesInfo objTimeKeeperCompletesInfo = TimeKeeperCompleteBackupList2.Where(o => o.HRTimeKeeperCompleteDate == item.HRTimeKeeperCompleteDate && o.HRTimeKeeperCompletesEmployeeCardNo == item.HRTimeKeeperCompletesEmployeeCardNo && o.FK_HRTimeKeeperID == item.FK_HRTimeKeeperID && o.HRTimeKeeperCompleteDateCheck == item.HRTimeKeeperCompleteDateCheck).FirstOrDefault(); HRTimeKeeperCompletesInfo objTimeKeeperCompleteOldsInfo = TimeKeeperCompleteBackupList.Where(o => o.HRTimeKeeperCompleteDate == item.HRTimeKeeperCompleteDate && o.HRTimeKeeperCompletesEmployeeCardNo == item.HRTimeKeeperCompletesEmployeeCardNo && o.FK_HRTimeKeeperID == item.FK_HRTimeKeeperID && o.HRTimeKeeperCompleteDateCheck == item.HRTimeKeeperCompleteDateCheck).FirstOrDefault(); SaveHistory(TableName.HRTimeKeeperCompletesTableName, objTimeKeeperCompleteOldsInfo, objTimeKeeperCompletesInfo, "Change"); } } } }
void gridView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { GridView view = sender as GridView; GridView gridView = (GridView)MainView; ManagerTimeKeeperEntities entity = (ManagerTimeKeeperEntities)((BaseModuleERP)Screen.Module).CurrentModuleEntity; if (e.RowHandle >= 0) { HRTimeKeeperCompletesInfo objTimeKeeperCompletesInfo = (HRTimeKeeperCompletesInfo)gridView.GetRow(e.RowHandle); ((ManagerTimeKeeperModule)Screen.Module).AddBackupList(objTimeKeeperCompletesInfo); if (e.Column.FieldName == "HRTimeKeeperCompleteTimeCheck") { //1.CheckSameTime ((ManagerTimeKeeperModule)Screen.Module).CheckSameTime(objTimeKeeperCompletesInfo, entity.TimeKeeperCompletesList.ToList()); //2.CheckNotInOverTime ((ManagerTimeKeeperModule)Screen.Module).CheckNotInOverTime(objTimeKeeperCompletesInfo, 60, true); //2.CheckNotInOverTime ((ManagerTimeKeeperModule)Screen.Module).CheckOverTimeAbsence(objTimeKeeperCompletesInfo, 60, true); } if (e.Column.FieldName == "HRTimeKeeperCompleteDate") { ((ManagerTimeKeeperModule)Screen.Module).ChangeCompleteDate(objTimeKeeperCompletesInfo); } } }
void gridView_RowStyle(object sender, RowStyleEventArgs e) { GridView view = sender as GridView; ManagerTimeKeeperEntities entity = (ManagerTimeKeeperEntities)((BaseModuleERP)Screen.Module).CurrentModuleEntity; GridView gridView = (GridView)MainView; if (e.RowHandle >= 0) { if (e.RowHandle == gridView.FocusedRowHandle) { e.Appearance.ForeColor = Color.Black; e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Bold); } HRTimeKeeperCompletesInfo objTimeKeeperCompletesInfo = (HRTimeKeeperCompletesInfo)gridView.GetRow(e.RowHandle); if (objTimeKeeperCompletesInfo != null) { bool isSameTime = ((ManagerTimeKeeperModule)Screen.Module).CheckSameTime(objTimeKeeperCompletesInfo, entity.TimeKeeperCompletesList.ToList()); if (isSameTime) { e.Appearance.BackColor2 = Color.Pink; e.Appearance.BackColor = Color.Pink; objTimeKeeperCompletesInfo.RowColor = Color.Pink.ToArgb(); } if (objTimeKeeperCompletesInfo.NotInOverTime == "False") { e.Appearance.BackColor2 = Color.Orange; e.Appearance.BackColor = Color.Orange; objTimeKeeperCompletesInfo.RowColor = Color.Orange.ToArgb(); } if (objTimeKeeperCompletesInfo.OverTimeAbsence == "False") { e.Appearance.BackColor2 = Color.Green; e.Appearance.BackColor = Color.Green; objTimeKeeperCompletesInfo.RowColor = Color.Green.ToArgb(); } if (objTimeKeeperCompletesInfo.NotInWorkingShift == "False") { e.Appearance.BackColor2 = Color.Blue; e.Appearance.BackColor = Color.Blue; objTimeKeeperCompletesInfo.RowColor = Color.Blue.ToArgb(); } if (objTimeKeeperCompletesInfo.LateForWork == "False") { e.Appearance.BackColor2 = Color.Orange; e.Appearance.BackColor = Color.Orange; objTimeKeeperCompletesInfo.RowColor = Color.Orange.ToArgb(); } if (objTimeKeeperCompletesInfo.GoEarly == "False") { e.Appearance.BackColor2 = Color.Yellow; e.Appearance.BackColor = Color.Yellow; objTimeKeeperCompletesInfo.RowColor = Color.Yellow.ToArgb(); } } } }
void item_Click(object sender, EventArgs e) { GridView view = (GridView)this.DefaultView; int index = view.GetDataSourceRowIndex(view.FocusedRowHandle); if (index >= 0) { List <HRTimeKeeperCompletesInfo> timeKeeperCompleteList = (List <HRTimeKeeperCompletesInfo>) this.DataSource; HRTimeKeeperCompletesInfo obj = (HRTimeKeeperCompletesInfo)timeKeeperCompleteList[index].Clone(); timeKeeperCompleteList.Insert(index, obj); this.RefreshDataSource(); } }
void rep_Click(object sender, EventArgs e) { GridView gridView = (GridView)MainView; HRTimeKeepersController objTimeKeepersController = new HRTimeKeepersController(); ManagerTimeKeeperEntities entity = (ManagerTimeKeeperEntities)((BaseModuleERP)Screen.Module).CurrentModuleEntity; if (gridView.FocusedRowHandle >= 0) { HRTimeKeeperCompletesInfo item = (HRTimeKeeperCompletesInfo)gridView.GetRow(gridView.FocusedRowHandle); entity.SaveHistory("HRTimeKeeperCompletes", item, item, "Cancel"); gridView.DeleteRow(gridView.FocusedRowHandle); } }
void gridView_RowStyle(object sender, RowStyleEventArgs e) { ManagerTimeKeeperEntities entity = (ManagerTimeKeeperEntities)((BaseModuleERP)Screen.Module).CurrentModuleEntity; GridView view = sender as GridView; GridView gridView = (GridView)MainView; if (e.RowHandle >= 0) { if (e.RowHandle == gridView.FocusedRowHandle) { e.Appearance.ForeColor = Color.Black; e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Bold); } HRTimeKeeperCompletesInfo objTimeKeeperCompletesInfo = (HRTimeKeeperCompletesInfo)gridView.GetRow(e.RowHandle); if (objTimeKeeperCompletesInfo != null) { bool isSameTime = ((ManagerTimeKeeperModule)Screen.Module).CheckSameTime(objTimeKeeperCompletesInfo, entity.TimeKeeperCompleteListView); } } }
public void SaveHistory(string ItemTableName, HRTimeKeeperCompletesInfo oldObject, HRTimeKeeperCompletesInfo newObject, string type) { //AAColumnAliasController objColumnAliasController = new AAColumnAliasController(); //List<AAColumnAliasInfo> columnAliasList = new List<AAColumnAliasInfo>(); //DataSet ds = objColumnAliasController.GetAAColumnAliasByTableName(ItemTableName); //if (ds.Tables.Count > 0) //{ // foreach (DataRow row in ds.Tables[0].Rows) // { // AAColumnAliasInfo objColumnAliasInfo = (AAColumnAliasInfo)objColumnAliasController.GetObjectFromDataRow(row); // columnAliasList.Add(objColumnAliasInfo); // } //} //List<HRTimeKeeperHistoryDetailsInfo> historyDetailList = new List<HRTimeKeeperHistoryDetailsInfo>(); //BOSDbUtil dbUtil = new BOSDbUtil(); //HRTimeKeeperHistorysController objTimeKeeperHistorysController = new HRTimeKeeperHistorysController(); //HRTimeKeeperHistoryDetailsController objTimeKeeperHistoryDetailsController = new HRTimeKeeperHistoryDetailsController(); //HRTimeKeeperHistorysInfo objTimeKeeperHistorysInfo; //List<HRTimeKeeperHistorysInfo> historyList = new List<HRTimeKeeperHistorysInfo>(); //historyList = objTimeKeeperHistorysController.GetTimeKeeperHistoryByTimeKeeperComplete(); //if (historyList != null) //{ // historyList.ForEach(o => // { // objTimeKeeperHistorysController.DeleteObject(o.HRTimeKeeperHistoryID); // objTimeKeeperHistoryDetailsController.DeleteByForeignColumn("FK_HRTimeKeeperHistoryID", o.HRTimeKeeperHistoryID); // }); //} //foreach (AAColumnAliasInfo alias in columnAliasList) //{ // string oldValue = ""; // string newValue = ""; // if (dbUtil.GetPropertyValue(oldObject, alias.AAColumnAliasName) != null) // { // oldValue = dbUtil.GetPropertyValue(oldObject, alias.AAColumnAliasName).ToString(); // } // if (dbUtil.GetPropertyValue(newObject, alias.AAColumnAliasName) != null) // { // newValue = dbUtil.GetPropertyValue(newObject, alias.AAColumnAliasName).ToString(); // } // if (oldValue != newValue) // { // HRTimeKeeperHistoryDetailsInfo objTimeKeeperHistoryDetailsInfo = new HRTimeKeeperHistoryDetailsInfo(); // objTimeKeeperHistoryDetailsInfo.HRTimeKeeperHistoryDetailTableName = ItemTableName; // objTimeKeeperHistoryDetailsInfo.HRTimeKeeperHistoryDetailColumnName = alias.AAColumnAliasCaption; // objTimeKeeperHistoryDetailsInfo.HRTimeKeeperHistoryDetailOldValue = oldValue; // objTimeKeeperHistoryDetailsInfo.HRTimeKeeperHistoryDetailNewValue = newValue; // objTimeKeeperHistoryDetailsInfo.HRTimeKeeperHistoryDetailEmployeeCardNumber = newObject.HRTimeKeeperCompletesEmployeeCardNo; // historyDetailList.Add(objTimeKeeperHistoryDetailsInfo); // } //} //if (type == "Cancel") //{ // HRTimeKeeperHistoryDetailsInfo objTimeKeeperHistoryDetailsInfo = new HRTimeKeeperHistoryDetailsInfo(); // objTimeKeeperHistoryDetailsInfo.HRTimeKeeperHistoryDetailTableName = ItemTableName; // objTimeKeeperHistoryDetailsInfo.HRTimeKeeperHistoryDetailEmployeeCardNumber = newObject.HRTimeKeeperCompletesEmployeeCardNo; // objTimeKeeperHistoryDetailsInfo.HRTimeKeeperHistoryDetailOldValue = oldObject.HRTimeKeeperCompleteDateCheck.ToString(); // historyDetailList.Add(objTimeKeeperHistoryDetailsInfo); //} //if (historyDetailList.Count > 0 || type == "Cancel") //{ // objTimeKeeperHistorysInfo = new HRTimeKeeperHistorysInfo(); // objTimeKeeperHistorysInfo.ADUserID = BOSApp.CurrentUsersInfo.ADUserID; // objTimeKeeperHistorysInfo.ADUserName = BOSApp.CurrentUsersInfo.ADUserName; // objTimeKeeperHistorysInfo.HRTimeKeeperHistoryObjectName = ItemTableName; // objTimeKeeperHistorysInfo.HRTimeKeeperHistoryAction = type; // objTimeKeeperHistorysInfo.HRTimeKeeperHistoryDate = dbUtil.GetCurrentServerDate(); // objTimeKeeperHistorysInfo.HRTimeKeeperHistoryObjectID = newObject.HRTimeKeeperCompleteID; // objTimeKeeperHistorysInfo.FK_HRTimeKeeperCompleteID = newObject.HRTimeKeeperCompleteID; // int parentHistoryID = objTimeKeeperHistorysController.CreateObject(objTimeKeeperHistorysInfo); // if (parentHistoryID > 0) // { // foreach (HRTimeKeeperHistoryDetailsInfo item in historyDetailList) // { // item.FK_HRTimeKeeperHistoryID = parentHistoryID; // objTimeKeeperHistoryDetailsController.CreateObject(item); // } // } //} }