public void OperationInfo(CE_OperatorMode mode, Business_Project_Timesheets timesheets) { DepotManagementDataContext ctx = CommentParameter.DepotDataContext; switch (mode) { case CE_OperatorMode.添加: timesheets.RecordDate = ServerTime.Time; timesheets.RecordPersonnel = BasicInfo.LoginID; ctx.Business_Project_Timesheets.InsertOnSubmit(timesheets); break; case CE_OperatorMode.除: var varData = from a in ctx.Business_Project_Timesheets where a.ID == timesheets.ID select a; ctx.Business_Project_Timesheets.DeleteAllOnSubmit(varData); break; default: break; } ctx.SubmitChanges(); }
private void btnDelete_Click(object sender, EventArgs e) { try { if (customDataGridView1.CurrentRow == null) { return; } if (!GlobalObject.GeneralFunction.IsInSameWeek(Convert.ToDateTime(customDataGridView1.CurrentRow.Cells["项目工作日期"].Value), ServerTime.Time)) { MessageDialog.ShowPromptMessage("不能【删除】,【项目工作日期】与当前日期不在同一周的记录"); return; } Business_Project_Timesheets timesheets = new Business_Project_Timesheets(); timesheets.ID = Convert.ToInt32(customDataGridView1.CurrentRow.Cells["序号"].Value); if (MessageDialog.ShowEnquiryMessage("是否要【删除】您当前选中的记录?") == DialogResult.Yes) { _ServiceTimesheets.OperationInfo(CE_OperatorMode.除, timesheets); MessageDialog.ShowPromptMessage("删除成功"); ClearInfo(); } } catch (Exception ex) { MessageDialog.ShowErrorMessage(ex.Message); } customDataGridView1.DataSource = _ServiceTimesheets.GetInfo(BasicInfo.LoginID); }
Business_Project_Timesheets GetInfo() { Business_Project_Timesheets result = new Business_Project_Timesheets(); result.ElapsedTime = numElapsedTime.Value; result.ItemDescription = txtDescription.Text; result.ItemName = cmbItemName.Text; result.ItemDate = dtpItemDate.Value.Date; result.RecordPersonnel = BasicInfo.LoginID; result.RecordDate = ServerTime.Time; result.ExecUser = txtExecUser.Tag.ToString(); return(result); }
public bool IsOverTime(Business_Project_Timesheets timesheets) { DepotManagementDataContext ctx = CommentParameter.DepotDataContext; var varData = from a in ctx.Business_Project_Timesheets where a.ExecUser == timesheets.ExecUser && a.ItemDate == timesheets.ItemDate select a; if (varData.Count() > 0 && varData.Sum(k => k.ElapsedTime) + timesheets.ElapsedTime > 24) { return(true); } return(false); }
public bool IsRepeat(Business_Project_Timesheets timesheets) { DepotManagementDataContext ctx = CommentParameter.DepotDataContext; var varData = from a in ctx.Business_Project_Timesheets where a.ExecUser == timesheets.ExecUser && a.ItemName == timesheets.ItemName && a.ItemDate == timesheets.ItemDate select a; if (varData.Count() > 0) { return(true); } return(false); }
private void btnSubmit_Click(object sender, EventArgs e) { try { if (!CheckInfo()) { return; } Business_Project_Timesheets timesheets = GetInfo(); if (_ServiceTimesheets.IsOverTime(timesheets)) { MessageDialog.ShowPromptMessage("【项目工作日期】累计【项目工时】超过24小时"); return; } if (_ServiceTimesheets.IsRepeat(timesheets)) { MessageDialog.ShowPromptMessage("【项目工作日期】已存在一条【" + timesheets.ItemName + "】记录"); return; } if (MessageDialog.ShowEnquiryMessage("请确认您填写的信息是否【提交】?") == DialogResult.Yes) { _ServiceTimesheets.OperationInfo(CE_OperatorMode.添加, timesheets); MessageDialog.ShowPromptMessage("提交成功"); ClearInfo(); } } catch (Exception ex) { MessageDialog.ShowErrorMessage(ex.Message); } customDataGridView1.DataSource = _ServiceTimesheets.GetInfo(BasicInfo.LoginID); }