public void TestApproveProcurementPlan() { Guid DepartmentID = new Guid("066AF5C4-3F41-419E-ADD5-77E8EC0E1E93"); int BudgetYear = 2018; DepartmentItems Items = new DepartmentItems(); Items.Quantity = "70000"; Items.UnitPrice = "70000"; Items.ItemName = "Office stationaries"; Items.ItemCodeID = new Guid("93E6FFA5-E700-45B0-BDE7-6B3570DAB27B"); Items.Deleted = false; List <DepartmentProject> Projects = new List <DepartmentProject>(); Projects.Add(new DepartmentProject() { ProcurementMethodID = new Guid("3D30C690-F37B-43D9-A17C-D47A4F5DA127"), ProjectName = "Procurement of Office stationary", ProjectCategoryID = new Guid("71CF7646-9D37-43FB-AC4D-23D34EA4D4D5"), Deleted = false, Attested = true, Items = new List <DepartmentItems>() { Items } }); var testApproveProcurementPlan = new ProcurementsController(); JsonResult result = (JsonResult)testApproveProcurementPlan.ApproveProcurementPlan(DepartmentID, BudgetYear, Projects); Console.WriteLine(result.Data); Assert.IsTrue((result.Data + "").Contains("All procurement needs.")); }
/// <summary> /// 修改部门 /// </summary> /// <param name="items"></param> /// <returns></returns> public bool UpdateDepartment(DepartmentItems items) { string sql = "Update table_Department set DepartmentName=@DepartmentName,IsEnable=@IsEnable where ObjectID=@ObjectID"; SQLiteParameter[] sqlparamter = new SQLiteParameter[] { new SQLiteParameter("@ObjectID", items.ObjectID), new SQLiteParameter("@DepartmentName", items.DepartmentName), new SQLiteParameter("@IsEnable", items.IsEnable), }; return(new SqlHelper().ExecuteNonQuery(sql, sqlparamter) == 1); }
{ /// <summary> /// 新增部门 /// </summary> /// <param name="items"></param> /// <returns></returns> public bool InsertDepartment(DepartmentItems items) { string sql = "INSERT into table_Department (ObjectID,DepartmentName,IsEnable,IsDelete) VALUES(@ObjectID,@DepartmentName,@IsEnable,@IsDelete)"; SQLiteParameter[] sqlparamter = new SQLiteParameter[] { new SQLiteParameter("@ObjectID", items.ObjectID), new SQLiteParameter("@DepartmentName", items.DepartmentName), new SQLiteParameter("@IsEnable", items.IsEnable), new SQLiteParameter("@IsDelete", "N") }; return(new SqlHelper().ExecuteNonQuery(sql, sqlparamter) == 1); }
private void Btn_Save_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(Txt_DepartmentName.Text)) { MessageBox.Show("请输入部门名称"); return; } try { var item = new DepartmentItems() { ObjectID = Txt_DepartmentID.Text, DepartmentName = Txt_DepartmentName.Text, IsEnable = Rbtn_Yes.Checked ? "Y" : "N" }; var result = IsEdit ? new DepartmentQuery().UpdateDepartment(item) : new DepartmentQuery().InsertDepartment(item); if (result) { MessageBox.Show("保存成功"); if (IsEdit) { this.Close(); } else { var unitId = Guid.NewGuid().ToString(); while (new DepartmentQuery().GetDepartment(unitId) != null) { unitId = Guid.NewGuid().ToString(); } Txt_DepartmentID.Text = unitId; Txt_DepartmentName.Text = String.Empty; } } } catch (Exception exp) { MessageBox.Show("保存失败," + exp.Message); } }
public override void Init(object initData) { base.Init(initData); string id = (string)initData; if (!string.IsNullOrEmpty(id)) { Data = customSyncEngine.Realm.All <Employee>().Where(w => w.Id == id).FirstOrDefault(); } if (Data == null) { Title = $"Add {nameof(Employee)}"; IsNewData = true; Data = new Employee(); Data.Birthday = DateTime.Now; } else { Title = $"Edit {nameof(Employee)}"; } DateTimeBirthday = Data.Birthday.LocalDateTime; //Prepare the navigation property for binding if (Data.Department == null) { SelectedDepartmentItem = DepartmentItems.Where(w => w.Id == Guid.Empty.ToString()).First(); } else { ReferenceItem referenceItem = DepartmentItems.Where(w => w.Id == Data.Department.Id).FirstOrDefault(); if (referenceItem == null) { SelectedDepartmentItem = DepartmentItems.Where(w => w.Id == Guid.Empty.ToString()).First(); } else { SelectedDepartmentItem = referenceItem; } } }
public override void Init(object initData) { base.Init(initData); Data = (Employee)initData; if (Data == null) { Title = $"Add {nameof(Employee)}"; isNewData = true; Data = new Employee(); Data.Id = Guid.NewGuid().ToString(); Data.Birthday = DateTime.Now; } else { Title = $"Edit {nameof(Employee)}"; } //Prepare the navigation property for binding Data.Department = DepartmentItems.Where(w => w.Id == Guid.Empty.ToString()).First(); if (!string.IsNullOrEmpty(Data.DepartmentId)) { Data.Department = DepartmentItems.Where(w => w.Id == Data.DepartmentId).FirstOrDefault(); } }