public override ActionResult Add(ProduceTask producetask) { ContractItem item = this.service.GetGenericService <ContractItem>().Get(producetask.ContractItemsID); producetask.ConStrength = item.ConStrength; return(base.Add(producetask)); }
public int AddContractDetail(ContractItem input) { int result = CRUDStatusCode.ERROR; if (input != null) { bool isExisted = _contractItemRepository.Exist(t => t.ContractCode == input.ContractCode && t.ProductName == input.ProductName); if (!isExisted) { input.StatusId = CommonStatus.ACTIVE; input.CreateDate = Utilities.GetServerDateTimeNow(); input.LastUpdateDate = Utilities.GetServerDateTimeNow(); input.LastUpdateBy = Common.Session.GetId(); _contractItemRepository.Add(input); result = CRUDStatusCode.SUCCESS; } else { result = CRUDStatusCode.EXISTED; } } return(result); }
public ItemDetails(ContractItem item) { InitializeComponent(); lb_itemID.Text = item.ItemId.ToString(); lb_typeID.Text = item.TypeId.ToString(); lb_TYPE.Text = item.Type?.ToString() ?? "type not loaded"; }
public ContractItem CreateContractDetail(ContractItem input) { ContractItem result = null; if (input != null) { bool isExisted = _contractItemRepository.Exist(t => t.ContractCode == input.ContractCode && t.ProductName == input.ProductName && t.StatusId == Constants.CommonStatus.ACTIVE); if (!isExisted) { input.StatusId = CommonStatus.ACTIVE; input.CreateDate = Utilities.GetServerDateTimeNow(); input.LastUpdateDate = Utilities.GetServerDateTimeNow(); input.LastUpdateBy = Common.Session.GetId(); result = _contractItemRepository.Create(input); } else { //In case existed check result id = 0; result = new ContractItem() { Id = 0 }; } } return(result); }
public bool Import(string contractID, string[] conStrength) { if (conStrength == null) { throw new Exception(":没有合同明细需要导入"); } using (var tx = this.m_UnitOfWork.BeginTransaction()) { try { IRepositoryBase <ContractItem> itemResp = this.m_UnitOfWork.GetRepositoryBase <ContractItem>(); foreach (string item in conStrength) { ContractItem temp = new ContractItem(); temp.ContractID = contractID; temp.ConStrength = item; itemResp.Add(temp); } tx.Commit(); return(true); } catch { tx.Rollback(); throw; } } }
private void StartPropContract(ContractKind kind, Span span) { Contract.Requires(currentModule != null); Contract.Requires(currentModule.CanHaveContract(kind)); Contract.Requires(kind != ContractKind.RequiresSome && kind != ContractKind.RequiresAtLeast && kind != ContractKind.RequiresAtMost); crntContract = new ContractItem(span, kind); switch (currentModule.NodeKind) { case NodeKind.Model: ((Model)currentModule).AddContract(crntContract); break; case NodeKind.Transform: ((Transform)currentModule).AddContract(crntContract); break; case NodeKind.Domain: ((Domain)currentModule).AddConforms(crntContract); break; default: throw new NotImplementedException(); } if (crntSentConf != null) { crntContract.SetConfig(crntSentConf); crntSentConf = null; } }
public int EditContractDetail(ContractItem input) { int result = CRUDStatusCode.ERROR; var ContractItem = _contractItemRepository.GetById(input.Id); bool isExisted = _contractItemRepository.Exist(t => t.ContractCode == input.ContractCode && t.ProductName == input.ProductName && t.Id != input.Id); if (ContractItem != null) { ContractItem.ProductName = input.ProductName; ContractItem.FileName = input.FileName; ContractItem.TotalCost = input.TotalCost; ContractItem.ShowTypeId = input.ShowTypeId; ContractItem.DurationSecond = input.DurationSecond; ContractItem.LastUpdateDate = Utilities.GetServerDateTimeNow(); ContractItem.LastUpdateBy = Common.Session.GetId(); _contractItemRepository.Update(ContractItem); result = CRUDStatusCode.SUCCESS; } if (result == CRUDStatusCode.SUCCESS) { _productScheduleShowService.EditProductFileName(ContractItem.Id, ContractItem.FileName); } return(result); }
/// <summary> /// 运输单结算 /// </summary> /// <param name="sd"></param> public void JS(ShippingDocument sd) { sd.IsJS = true; decimal price = 0; ContractItem ci = this.m_UnitOfWork.GetRepositoryBase <ContractItem>().Get(this.m_UnitOfWork.GetRepositoryBase <ProduceTask>().Get(sd.TaskID).ContractItemsID); List <PriceSetting> list = this.m_UnitOfWork.GetRepositoryBase <PriceSetting>().All().Where(p => p.ContractItemsID == ci.ID).OrderBy(p => p.ChangeTime).ToList(); if (list.Count > 0) { int i = 0; while (list[i].ChangeTime < sd.BuildTime) { i++; } if (i == 0) { price = (ci.UnPumpPrice == null?0:(Decimal)ci.UnPumpPrice) + (ci.PumpPrice == null?0:(Decimal)ci.PumpPrice); } else { price = (list[i - 1].UnPumpPrice == null ? 0 : (Decimal)list[i - 1].UnPumpPrice) + (ci.PumpPrice == null ? 0 : (Decimal)ci.PumpPrice); } } else { price = (ci.UnPumpPrice == null?0:(Decimal)ci.UnPumpPrice) + (ci.PumpPrice == null?0:(Decimal)ci.PumpPrice); } sd.JSPrice = sd.SignInCube * price; this.m_UnitOfWork.ShippingDocumentRepository.Update(sd, null); this.m_UnitOfWork.Flush(); }
public ResultResponse postSuccessContract(ContractItem req) { ResultResponse res = new ResultResponse(); //check contract data //giam nguon cbms return(res); }
public static List <ContractWorkload> QureyContractWorkLoad(string contractId) { MySqlConnection con = DBTools.GetMySqlConnection(); MySqlCommand cmd; List <ContractWorkload> workloads = new List <ContractWorkload>(); try { con.Open(); cmd = con.CreateCommand(); cmd.CommandText = QUERY_CONTRACT_WORKLOAD_STR; cmd.Parameters.AddWithValue("@ContractId", contractId); MySqlDataReader sqlRead = cmd.ExecuteReader(); cmd.Dispose(); while (sqlRead.Read()) { ContractWorkload workload = new ContractWorkload(); workload.ContractId = contractId; workload.Work = double.Parse(sqlRead["work"].ToString()); workload.WorkInfo = sqlRead["workinfo"].ToString( ); workload.Expense = double.Parse(sqlRead["expense"].ToString()); ContractItem item = new ContractItem(); item.Id = int.Parse(sqlRead["itemid"].ToString()); item.ProjectId = int.Parse(sqlRead["projectid"].ToString()); item.Item = sqlRead["item"].ToString(); workload.Item = item; //Console.WriteLine(workload.Work + " " + workload.Expense); workloads.Add(workload); } con.Close(); con.Dispose(); } catch (Exception) { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(workloads); }
public async Task <IActionResult> DeleteContractItem([FromBody] ContractItemView view) { ContractItemModule invMod = new ContractItemModule(); ContractItem contractItem = await invMod.ContractItem.Query().MapToEntity(view); invMod.ContractItem.DeleteContractItem(contractItem).Apply(); return(Ok(view)); }
/// SELECT w.contractid, w.itemid, i.item, w.work, w.expense FROM `workload` w, `item` i WHERE w.itemid = i.id AND `contractid` like "申%" AND `itemid` = 1 /// SELECT w.contractid, p.id projectid, p.project, i.id itemid, i.item,w.work, w.expense FROM `workload` w, `item` i, `project` p WHERE w.itemid = i.id AND i.projectid = p.id AND `contractid` like "申%" AND `itemid` = 1 /// <summary> /// 统计工作量的信息[Search数据填写SDepartmentShortCall + ItemId] /// </summary> /// <param name="search"></param> /// <returns></returns> public static List <ContractWorkload> GetSDepartmentItemWorkload(Search search) { MySqlConnection con = DBTools.GetMySqlConnection(); MySqlCommand cmd; List <ContractWorkload> workloads = new List <ContractWorkload>(); try { con.Open(); cmd = con.CreateCommand(); cmd.CommandText = QUERY_SDEPARTMENT_ITEM_YEAR_WORKLOAD_STR; cmd.Parameters.AddWithValue("@SDepartmentYear", search.SDepartmentShortlCall + "_" + search.Year.ToString() + "%"); cmd.Parameters.AddWithValue("@ItemId", search.ItemId); MySqlDataReader sqlRead = cmd.ExecuteReader(); cmd.Dispose(); while (sqlRead.Read()) { ContractWorkload workload = new ContractWorkload(); workload.ContractId = sqlRead["contractid"].ToString(); workload.Work = double.Parse(sqlRead["work"].ToString()); workload.Expense = double.Parse(sqlRead["expense"].ToString()); ContractItem item = new ContractItem(); item.Id = int.Parse(sqlRead["itemid"].ToString()); //item.ProjectId = int.Parse(sqlRead["projectid"].ToString()); //item.Item = sqlRead["item"].ToString(); workload.Item = item; //Console.WriteLine(workload.Work + " " + workload.Expense); workloads.Add(workload); } con.Close(); con.Dispose(); } catch (Exception) { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(workloads); }
public EditItem(String categoryName, String projectName, ContractItem item, SignSocketClient sc) : this() { this.m_categoryName = categoryName; this.m_projectName = projectName; this.m_item = item; _sc = sc; }
private void GenerateText(ContractItem item) { lb_Amount.Text = "x" + item.Quantity.ToString(); lb_ItemName.Text = IDSearch.Items[item.TypeId.ToString()] ?? "No Item Name"; String path = $"Items\\{item.TypeId}_64.png"; if (File.Exists(path)) { pb_Icon.Load(path); } }
/// <summary> /// 统计当前部门申请的所有工程Project下的会签单信息[Search数据填写SDepartmentShortCall + ItemId] /// </summary> /// <param name="search"></param> /// <returns></returns> public static ContractWorkload StatisDepartmentYearProjectWorkLoad(HSDepartment department, int year, ContractProject project) { if (project.Id == 10) { } MySqlConnection con = DBTools.GetMySqlConnection(); MySqlCommand cmd; ContractWorkload workload = null; try { con.Open(); cmd = con.CreateCommand(); cmd.CommandText = STATIS_DEPARTMENT_YEAR_PROJECT_STR; cmd.Parameters.AddWithValue("@SDepartmentYear", department.ShortCall + "__" + year.ToString() + "%"); cmd.Parameters.AddWithValue("@ProjectId", project.Id); MySqlDataReader sqlRead = cmd.ExecuteReader(); cmd.Dispose(); while (sqlRead.Read()) { workload = new ContractWorkload(); workload.ContractId = STATIS_KIND.STATIS_DEPARTMENT_YEAR_PROJECT_WORKLOAD.ToString(); workload.Work = double.Parse(sqlRead["works"].ToString()); workload.Expense = double.Parse(sqlRead["expenses"].ToString()); ContractItem item = new ContractItem(); item.Id = -1; workload.Item = item; } con.Close(); con.Dispose(); } catch (Exception) { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(workload); }
public void EditContract(ContractItem contractItem) { _context.Entry(contractItem).State = EntityState.Modified; try { _context.SaveChanges(); } catch (Exception) { throw; } }
public static bool CheckIntegrity(ContractItem item) { MySqlConnection con = DBTools.GetMySqlConnection(); MySqlCommand cmd; int count = -1; try { con.Open(); cmd = con.CreateCommand(); cmd.CommandText = CHECK_ITEM_INTEGRITY_STR; cmd.Parameters.AddWithValue("@Id", item.Id); cmd.Parameters.AddWithValue("@ProjectId", item.ProjectId); cmd.Parameters.AddWithValue("@Item", item.Item); MySqlDataReader sqlRead = cmd.ExecuteReader(); cmd.Dispose(); while (sqlRead.Read()) { count = int.Parse(sqlRead["count"].ToString()); } con.Close(); con.Dispose(); if (count == 1) { return(true); } else { Console.WriteLine("PROJECT : Id = {0}, ProjectId = {1}, Item = {2}检查失败", item.Id, item.ProjectId, item.Item); return(false); } } catch (Exception) { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } }
public static ContractWorkload StatisYearCategoryRegularLoad(int year, ContractCategory category) { MySqlConnection con = DBTools.GetMySqlConnection(); MySqlCommand cmd; ContractWorkload workload = null; try { con.Open(); cmd = con.CreateCommand(); cmd.CommandText = STATIS_YEAR_CATEGORY_REGULARLOAD_STR; cmd.Parameters.AddWithValue("@Year", year); cmd.Parameters.AddWithValue("@CategoryId", category.Id); MySqlDataReader sqlRead = cmd.ExecuteReader(); cmd.Dispose(); while (sqlRead.Read()) { workload = new ContractWorkload(); workload.ContractId = STATIS_KIND.STATIS_YEAR_CATEGORY_REGULARLOAD.ToString(); workload.Work = double.Parse(sqlRead["works"].ToString()); workload.Expense = double.Parse(sqlRead["expenses"].ToString()); /// BUG ContractItem item = new ContractItem(); item.Id = -1; workload.Item = item; } con.Close(); con.Dispose(); } catch (Exception) { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(workload); }
//private static String STATIS_YEAR_ITEM_STR = @"SELECT IFNULL(Sum(work), 0) works, IFNULL(Sum(expense),0) expenses FROM `workload` WHERE `contractid` like @Year AND `itemid` = @ItemId"; public static ContractWorkload StatisYearItemWorkLoad(int year, ContractItem item) { MySqlConnection con = DBTools.GetMySqlConnection(); MySqlCommand cmd; ContractWorkload workload = null; try { con.Open(); cmd = con.CreateCommand(); cmd.CommandText = STATIS_DEPARTMENT_YEAR_ITEM_STR; cmd.Parameters.AddWithValue("@SDepartmentYear", "__" + year.ToString() + "%"); cmd.Parameters.AddWithValue("@ItemId", item.Id); MySqlDataReader sqlRead = cmd.ExecuteReader(); cmd.Dispose(); while (sqlRead.Read()) { workload = new ContractWorkload(); workload.ContractId = STATIS_KIND.STATIS_YEAR_ITEM_WORKLOAD.ToString(); workload.Work = double.Parse(sqlRead["works"].ToString()); workload.Expense = double.Parse(sqlRead["expenses"].ToString()); /// BUG //ContractItem item = new ContractItem(); //item.Id = -1; workload.Item = item; } con.Close(); con.Dispose(); } catch (Exception) { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(workload); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } if (e.ColumnIndex == 2) // 修改当前部门信息 { if (MessageBox.Show("确定要修改当前工作量类别信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { // BUG string categoryName = ((ComboboxItem)this.CateId.SelectedItem).Text; string projectName = this.SelectedProject.Text; ContractItem item = UserHelper.ContractItemList[e.RowIndex]; EditItem ei = new EditItem(categoryName, projectName, item, _sc); ei.ShowDialog(); if (ei.DialogResult == DialogResult.OK) { this.BindItem(true); } } } else if (e.ColumnIndex == 3) // 删除当前部门信息 { if (MessageBox.Show("确定要删除此工作量类别信息?\n危险操作,请谨慎进行\n请问您是否继续删除", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { //MessageBox.Show(this.dataGridView3.Rows[e.RowIndex].Cells[0].Value.ToString()); int itemId = Convert.ToInt32(this.dataGridView1.Rows[e.RowIndex].Cells[0].Value); string result = _sc.DeleteItem(itemId); if (result == Response.DELETE_ITEM_SUCCESS.ToString()) { MessageBox.Show("删除工作量成功!", "提示", MessageBoxButtons.OK); this.BindItem(true); } else if (result == "服务器连接中断") { MessageBox.Show("服务器连接中断,删除失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } //else if (result == Response.DELETE_DEPARTMENT_EXIST_EMPLOYEE.ToString()) //{ // MessageBox.Show("该部门下有人员存在,无法删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); //} else { MessageBox.Show("删除工作量失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } }
public IActionResult PostContractItem([FromBody] ContractDetailsForPostDto contractDetails) { var customer = _repository.GetCustomerByName(contractDetails.CustomerName); if (customer == null) { _logger.LogInformation($"Customer with name {contractDetails.CustomerName} not found."); ModelState.AddModelError("Customer Name", "Customer does not exist!"); return(BadRequest(ModelState)); } var planType = _repository.GetCoveragePlan(contractDetails.CustomerCountry, customer.DateOfBirth); var age = DateTime.Now.Year - contractDetails.DOB.Year; if (planType == null) { _logger.LogInformation("Suitable Coverage Plan not found for provided paramters."); ModelState.AddModelError("Coverage Plan", "Coverage Plan not found!"); return(BadRequest(ModelState)); } object g = null; Gender gender = (Gender) (Enum.TryParse(typeof(Gender), contractDetails.CustomerGender, true, out g) ? g : Gender.Other); var rate = _repository.GetRate(gender, age, planType); if (rate == null) { _logger.LogInformation($"Rate not found for Plan Id {planType.PlanId}."); ModelState.AddModelError("Rate", "Rate not found!"); return(BadRequest(ModelState)); } var contractItem = new ContractItem { CustomerId = customer.CustomerId, SaleDate = contractDetails.SaleDate, CoverageId = planType.PlanId, NetPrice = rate.NetPrice }; try { _repository.SaveContract(contractItem); } catch (DbUpdateConcurrencyException ex) { _logger.LogCritical("Database update concurrency exception thrown", ex); return(StatusCode(500, "Internal Server Error has occurred.")); } return(CreatedAtAction("GetContract", new { id = contractItem.ContractId }, contractItem)); }
/// <summary> /// 统计当前部门申请的所有工程Project下的会签单信息[Search数据填写SDepartmentShortCall + ItemId] /// </summary> /// <param name="search"></param> /// <returns></returns> public static ContractWorkload StatisSDepartmentProjectYearWorkload(Search search) { MySqlConnection con = DBTools.GetMySqlConnection(); MySqlCommand cmd; ContractWorkload workload = null; try { con.Open(); cmd = con.CreateCommand(); cmd.CommandText = STATIS_SDEPARTMENT_PROJECT_YEAR_WORKLOAD_STR; cmd.Parameters.AddWithValue("@SDepartmentYear", search.SDepartmentShortlCall + "_" + search.Year.ToString() + "%"); cmd.Parameters.AddWithValue("@ProjectId", search.ProjectId); MySqlDataReader sqlRead = cmd.ExecuteReader(); cmd.Dispose(); while (sqlRead.Read()) { workload = new ContractWorkload(); workload.ContractId = "STATIS"; workload.Work = -1; workload.Expense = double.Parse(sqlRead["expenses"].ToString()); ContractItem item = new ContractItem(); item.Id = -1; workload.Item = item; } con.Close(); con.Dispose(); } catch (Exception) { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(workload); }
public static ContractWorkload StatisDepartmentYearCategoryWorkLoad(string departmentShortCall, string categoryShortCall, int year) { MySqlConnection con = DBTools.GetMySqlConnection(); MySqlCommand cmd; ContractWorkload workload = null; try { con.Open(); cmd = con.CreateCommand(); cmd.CommandText = STATIS_DEPCATESHORTCALL_YEAR_CATEGORY_STR; cmd.Parameters.AddWithValue("@SDepartmentCategoryYear", departmentShortCall + categoryShortCall + year.ToString() + "%"); MySqlDataReader sqlRead = cmd.ExecuteReader(); cmd.Dispose(); while (sqlRead.Read()) { workload = new ContractWorkload(); workload.ContractId = STATIS_KIND.STATIS_DEPARTMENT_YEAR_CATEGORY_WORKLOAD.ToString(); workload.Work = double.Parse(sqlRead["works"].ToString()); workload.Expense = double.Parse(sqlRead["expenses"].ToString()); ContractItem item = new ContractItem(); item.Id = -1; workload.Item = item; } con.Close(); con.Dispose(); } catch (Exception) { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(workload); }
public async Task <IActionResult> UpdateContractItem([FromBody] ContractItemView view) { ContractItemModule invMod = new ContractItemModule(); ContractItem contractItem = await invMod.ContractItem.Query().MapToEntity(view); invMod.ContractItem.UpdateContractItem(contractItem).Apply(); ContractItemView retView = await invMod.ContractItem.Query().GetViewById(contractItem.ContractItemId); return(Ok(retView)); }
public static List <ContractItem> QueryProjectItem(string categoryName, string projectName) { MySqlConnection con = DBTools.GetMySqlConnection(); MySqlCommand cmd; List <ContractItem> items = new List <ContractItem>(); try { con.Open(); cmd = con.CreateCommand(); cmd.CommandText = QUERY_PROJECT_ITEM_BY_PROJECT_NAME_STR; cmd.Parameters.AddWithValue("CategoryName", categoryName); cmd.Parameters.AddWithValue("@ProjectName", projectName); MySqlDataReader sqlRead = cmd.ExecuteReader(); cmd.Dispose(); while (sqlRead.Read()) { ContractItem item = new ContractItem(); item.Id = int.Parse(sqlRead["id"].ToString()); item.ProjectId = int.Parse(sqlRead["projectid"].ToString()); item.Item = sqlRead["item"].ToString(); items.Add(item); } con.Close(); con.Dispose(); } catch (Exception) { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(items); }
internal static ContractItem ConstrainByKeys(this ContractItem contractItem, IContractKey contractKey) { if (contractItem == null) { throw new ArgumentNullException("contractItem"); } if (contractKey != null) { contractItem.Contract = null; contractItem.ContractYear = contractKey.ContractKey_Year; contractItem.ContractSequence = contractKey.ContractKey_Sequence; } return(contractItem); }
private static void SetContractItem(ContractItem contractItem, SetContractItemParameters newItem, IEnumerable <CustomerProductCode> productCodes) { contractItem.ChileProductId = newItem.ChileProductKey.ChileProductKey_ProductId; contractItem.PackagingProductId = newItem.PackagingProductKey.PackagingProductKey_ProductId; contractItem.TreatmentId = newItem.TreatmentKey.InventoryTreatmentKey_Id; contractItem.UseCustomerSpec = newItem.ContractItemParameters.UseCustomerSpec; contractItem.Quantity = newItem.ContractItemParameters.Quantity; contractItem.PriceBase = newItem.ContractItemParameters.PriceBase; contractItem.PriceFreight = newItem.ContractItemParameters.PriceFreight; contractItem.PriceTreatment = newItem.ContractItemParameters.PriceTreatment; contractItem.PriceWarehouse = newItem.ContractItemParameters.PriceWarehouse; contractItem.PriceRebate = newItem.ContractItemParameters.PriceRebate; contractItem.CustomerProductCode = newItem.ContractItemParameters.CustomerCodeOverride ?? productCodes.Where(c => newItem.ChileProductKey.Equals(c)).Select(c => c.Code).FirstOrDefault() ?? ""; }
public async Task <IActionResult> AddContractItem([FromBody] ContractItemView view) { ContractItemModule invMod = new ContractItemModule(); NextNumber nnContractItem = await invMod.ContractItem.Query().GetNextNumber(); view.ContractItemNumber = nnContractItem.NextNumberValue; ContractItem contractItem = await invMod.ContractItem.Query().MapToEntity(view); invMod.ContractItem.AddContractItem(contractItem).Apply(); ContractItemView newView = await invMod.ContractItem.Query().GetViewByNumber(view.ContractItemNumber); return(Ok(newView)); }
public static bool ModifyItem(ContractItem item) { MySqlConnection con = DBTools.GetMySqlConnection(); MySqlCommand cmd; int count = -1; // 受影响行数 try { con.Open(); cmd = con.CreateCommand(); cmd.CommandText = MODIFY_ITEM_STR; cmd.Parameters.AddWithValue("@Id", item.Id); cmd.Parameters.AddWithValue("@ProjectId", item.ProjectId); cmd.Parameters.AddWithValue("@Item", item.Item); count = cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); con.Dispose(); if (count == 1) // 插入成功后的受影响行数为1 { Console.WriteLine("任务工作量{0}修改成功", item.Item); return(true); } else { Console.WriteLine("任务工作量{0}修改失败", item.Item); return(false); } } catch (Exception) { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } }
public ContractItemDetailForm(ContractItem inputModel) { InitializeComponent(); this.model = inputModel; gbRegisterSchedule.Visible = false; if (model != null) { if (model.Id != 0) { gbRegisterSchedule.Visible = true; } } LoadDurationComboBox(); LoadCboShowType(); LoadData(); }