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();
}
}
