/// <summary>
/// 添加记录
/// </summary>
private void AddLog_Click(object sender, EventArgs e)
{
try
{
List <string> errorList = new List <string>();//创建一个错误列表
//获取根据当前页面内容生成的清单（若有错误会被添加到错误列表中）
AcceptanceList list = GetAcceptanceList(ref errorList);
list.State = "未处理";
//判断是否添加清单成功
if (interviewBll.AddAcceptanceList(list, ref errorList))
{
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("添加失败");
foreach (var i in errorList)
{
MessageBox.Show(i);//逐条显示错误信息
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
DataBind();
}
private void Btn_addCase_Click(object sender, EventArgs e)
{
try
{
List <string> errorList = new List <string>();//创建一个错误列表
//获取根据当前页面内容生成的订单（若有错误会被添加到错误列表中）
var list = new AcceptanceList[] { GetAcceptanceList(ref errorList) };
if (errorList.Count == 0)
{
if (userCaseHandle.AddUserCases(list.ToList()))
{
MessageBox.Show("添加成功");
}
}
else
{
MessageBox.Show("添加失败");
foreach (var i in errorList)
{
MessageBox.Show(i);//逐条显示错误信息
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
DataBind();
}
/// <summary>
/// 增加一条验收清单记录
/// </summary>
/// <param name="list">验收清单</param>
/// <returns>增加成功与否</returns>
public bool AddAcceptanceList(AcceptanceList list)
{
string sqlStr = "INSERT INTO tb_AcceptanceList (" +
"OrderId," +
"AcceptorId," +
"State" +
")" +
"VALUES(" +
"@orderId," +
"@acceptorId," +
"@state" +
")";
//储存Datatable
MySqlParameter[] para = new MySqlParameter[]//存储相应参数的容器
{
new MySqlParameter("@orderId", list.OrderId),
new MySqlParameter("@acceptorId", list.AcceptorId),
new MySqlParameter("@state", list.State),
};
int count = helper.ExecuteNonQuery(sqlStr, para, CommandType.Text);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取当前窗体所表示的清单
/// </summary>
/// <param name="error">错误列表</param>
/// <returns>验收清单</returns>
private AcceptanceList GetAcceptanceList(ref List <string> error)
{
List <string> errorList = new List <string>();//错误列表
//判断验收人账号是否符合要求
Match matchAcceptor = Regex.Match(AcceptorTextBox.Text, @"(^\d{8}$)|(^\d{10}$)|(^\d{12}$)");
if (!matchAcceptor.Success)
{
errorList.Add("AcceptorId Error");
}
//通过订购人账号获取id
int acceptorId = utilBll.GetUserIdFormNumber(AcceptorTextBox.Text);
//根据页面内容构造清单
AcceptanceList list = new AcceptanceList()
{
OrderId = int.Parse(textBox_orderId.Text),
AcceptorId = acceptorId,
State = comboBox_State.Text,
};
error = errorList; //返回错误列表
return(list); //返回订单
}
/// <summary>
/// 修改一条验收记录
/// </summary>
/// <param name="list">验收清单</param>
/// <returns>修改成功与否</returns>
public bool UpdateAcceptanceList(AcceptanceList list)
{
string sqlStr = "UPDATE tb_AcceptanceList SET " +
"OrderId=@orderId, " +
"AcceptorId=@acceptorId, " +
"State=@state " +
"where Id=@id;";
//储存Datatable
MySqlParameter[] para = new MySqlParameter[]//存储相应参数的容器
{
new MySqlParameter("@id", list.Id),
new MySqlParameter("@orderId", list.OrderId),
new MySqlParameter("@acceptorId", list.AcceptorId),
new MySqlParameter("@state", list.State),
};
int count = helper.ExecuteNonQuery(sqlStr, para, CommandType.Text);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
public void TestUpdateAcceptanceList()
{
Tools.UserCaseHandle userCaseHandle = new Tools.UserCaseHandle(@"C:\Users\Mr.Feng\Desktop\软工\测试用例\Update_AcceptanceList.xls");
IEnumerable acceptanceList = userCaseHandle.GetUserCases();
List <string> errorList = new List <string>();
foreach (var i in acceptanceList)
{
Assert.AreEqual(false, interviewBll.UpdateAcceptanceList((AcceptanceList)i, ref errorList));
}
int maxId = -1;
foreach (AcceptanceList i in interviewBll.GetAllAcceptanceListArray())
{
if (i.Id > maxId)
{
maxId = i.Id;
}
}
if (maxId != -1)
{
AcceptanceList list = new AcceptanceList()
{
Id = maxId,
OrderId = 10,
AcceptorId = 200,
State = "已编目",
};
Assert.AreEqual(true, interviewBll.UpdateAcceptanceList(list, ref errorList));
}
}
/// <summary>
/// 获取全部订单
/// </summary>
/// <returns>全部订单</returns>
public IEnumerable GetAllAcceptanceListArray()
{
List <AcceptanceList> result = new List <AcceptanceList>();
try
{
DataTable datatable = interviewDal.GetAllAcceptanceList();
foreach (DataRow dr in datatable.Rows)
{
AcceptanceList acceptanceList = new AcceptanceList()
{
Id = (int)dr["清单号"],
OrderId = (int)dr["订单号"],
AcceptorId = (int)dr["订单号"],
State = dr["状态"].ToString(),
};
result.Add(acceptanceList);
}
return(result);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 修改一条验收清单记录
/// </summary>
/// <param name="list">验收清单</param>
/// <returns>修改成功与否</returns>
public bool UpdateAcceptanceList(AcceptanceList list, ref List <string> errorMsg)
{
bool result = false;
try
{
if (list.Id == 0)
{
errorMsg.Add("Id Error");
return(false);
}
if (!AcceptanceList.isNull(list)) //是否有空项
{
if (AcceptanceList.isNormative(list, ref errorMsg)) //是否符合规范
{
result = interviewDal.UpdateAcceptanceList(list);
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
return(result);
}
public void TestAddAcceptanceList()
{
Tools.UserCaseHandle userCaseHandle = new Tools.UserCaseHandle(@"C:\Users\96464\Desktop\软件工程\测试用例\Add_AcceptanceList.xls");
IEnumerable acceptanceList = userCaseHandle.GetUserCases();
List <string> errorList = new List <string>();
foreach (var i in acceptanceList)
{
Assert.AreEqual(false, interviewBll.AddAcceptanceList((AcceptanceList)i, ref errorList));
}
AcceptanceList list = new AcceptanceList()
{
Id = 1,
OrderId = 1,
AcceptorId = 1,
State = "已编目",
};
Assert.AreEqual(true, interviewBll.AddAcceptanceList(list, ref errorList));
}
/// <summary>
/// 增加一条验收清单记录
/// </summary>
/// <param name="list">验收清单</param>
/// <param name="errorMsg">增加成功与否</param>
/// <returns></returns>
public bool AddAcceptanceList(AcceptanceList list, ref List <string> errorMsg)
{
bool result = false;
try
{
if (!AcceptanceList.isNull(list)) //是否有空项
{
if (AcceptanceList.isNormative(list, ref errorMsg)) //是否符合规范
{
result = interviewDal.AddAcceptanceList(list);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
return(result);
}
/// <summary>
/// 获取当前窗体所表示的清单
/// </summary>
/// <param name="error">错误列表</param>
/// <returns>验收清单</returns>
private AcceptanceList GetAcceptanceList(ref List <string> error)
{
List <string> errorList = new List <string>();//错误列表
//通过订购人账号获取id
int ordererId = int.Parse(OrdererTextBox.Text);
//通过订购人账号获取id
int acceptorId = int.Parse(AcceptorTextBox.Text);
//根据页面内容构造清单
AcceptanceList list = new AcceptanceList()
{
//Id = int.Parse(IdTextBox.Text),
//BookSellerId = BookSellerComboBox.SelectedIndex,
//PublishingHouseId = PublishingHouseComboBox.SelectedIndex,
//OrdererId = ordererId,
//AcceptorId = acceptorId,
//DocumentType = DocumentTypeComboBox.Text,
};
error = errorList; //返回错误列表
return(list); //返回订单
}
/// <summary>
/// 保存记录
/// </summary>
private void SaveLog_Click(object sender, EventArgs e)
{
try
{
List <string> errorList = new List <string>(); //创建一个错误列表
//获取根据当前页面内容生成的清单（若有错误会被添加到错误列表中）
string idNum = IdTextBox.Text; //获取订单编号
int id;
if (!int.TryParse(idNum, out id)) //将其转换为数字失败
{
MessageBox.Show("订单编号错误");
return;
}
AcceptanceList list = GetAcceptanceList(ref errorList);
list.Id = id;//设置清单ID
//判断是否添加清单成功
if (interviewBll.UpdateAcceptanceList(list, ref errorList))
{
MessageBox.Show("修改成功");
}
else
{
MessageBox.Show("修改失败");
foreach (var i in errorList)
{
MessageBox.Show(i);//逐条显示错误信息
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
DataBind(); //数据绑定
ChangeControlEnableState(); //改变菜单按钮启用状态
}
