/// <summary>
/// 更改一条期刊登到记录
/// </summary>
/// <param name="arrival">期刊登到记录</param>
/// <returns>更改成功与否</returns>
public bool UpdatePeriodicalArrival(PeriodicalArrival arrival)
{
string sqlStr = "UPDATE tb_PeriodicalArrival SET " +
"OrderId=@orderId, " +
"State=@state " +
"where Id=@id;";
//储存Datatable
MySqlParameter[] para = new MySqlParameter[]//存储相应参数的容器
{
new MySqlParameter("@state", arrival.State),
new MySqlParameter("@orderId", arrival.OrderId),
new MySqlParameter("@id", arrival.Id),
};
int count = helper.ExecuteNonQuery(sqlStr, para, CommandType.Text);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改登到按钮点击
/// </summary>
private void changeButton_Click(object sender, EventArgs e)
{
try
{
List<string> errorList = new List<string>();//创建一个错误列表
//获取根据当前页面内容生成的订单（若有错误会被添加到错误列表中）
int id;
if (!int.TryParse(idTextBox.Text, out id))//将其转换为数字失败
{
MessageBox.Show("登到编号错误");
return;
}
PeriodicalArrival arrival = GetPeriodicalArrival(ref errorList);
arrival.Id = id;//设置登到ID
//判断是否修改登到成功
if (periodicalBll.UpdatePeriodicalArrival(arrival, ref errorList))
{
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="arrival">期刊登到记录</param>
/// <returns>增加成功与否</returns>
public bool AddPeriodicalArrival(PeriodicalArrival arrival)
{
string sqlStr = "INSERT INTO tb_PeriodicalArrival (" +
"OrderId," +
"State" +
") " +
"VALUES(" +
"@orderId," +
"@state" +
");";
//储存Datatable
MySqlParameter[] para = new MySqlParameter[]//存储相应参数的容器
{
new MySqlParameter("@orderId", arrival.OrderId),
new MySqlParameter("@state", arrival.State),
};
int count = helper.ExecuteNonQuery(sqlStr, para, CommandType.Text);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取分页后订单
/// </summary>
/// <returns>分页后订单</returns>
public IEnumerable GetPeriodArrivalsArray(int index, int size)
{
List <PeriodicalArrival> result = new List <PeriodicalArrival>();
try
{
DataTable datatable = periodicalDal.GetPeriodOrders(index, size);
foreach (DataRow dr in datatable.Rows)
{
PeriodicalArrival periodicalArrival = new PeriodicalArrival()
{
Id = (int)dr["编号"],
OrderId = (int)dr["订单编号"],
State = dr["状态"].ToString(),
};
result.Add(periodicalArrival);
}
return(result);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 登到按钮点击
/// </summary>
private void arrivalButton_Click(object sender, EventArgs e)
{
try
{
List<string> errorList = new List<string>();//创建一个错误列表
//获取根据当前页面内容生成的订单（若有错误会被添加到错误列表中）
PeriodicalArrival arrival = GetPeriodicalArrival(ref errorList);
//判断是否添加订单成功
if (periodicalBll.AddPeriodicalArrival(arrival, ref errorList))
{
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="arrival">期刊登到记录</param>
/// <returns>更改成功与否</returns>
public bool UpdatePeriodicalArrival(PeriodicalArrival arrival, ref List <string> errorMsg)
{
bool result = false;
try
{
if (arrival.Id == 0)
{
errorMsg.Add("Id Error");
return(false);
}
if (!PeriodicalArrival.isNull(arrival)) //是否有空项
{
if (PeriodicalArrival.isNormative(arrival, ref errorMsg)) //是否符合规范
{
result = periodicalDal.UpdatePeriodicalArrival(arrival);
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
return(result);
}
public void TestAddPeriodicalArrival()
{
Tools.UserCaseHandle userCaseHandle = new Tools.UserCaseHandle(@"C:\Users\96464\Desktop\软件工程\测试用例\Add_PeriodicalArrival.xls");
IEnumerable periodicalArrivals = userCaseHandle.GetUserCases();
List <string> errorList = new List <string>();
foreach (var i in periodicalArrivals)
{
Assert.AreEqual(false, periodicalBll.AddPeriodicalArrival((PeriodicalArrival)i, ref errorList));
}
int maxId = -1;
foreach (PeriodicalOrder i in periodicalBll.GetAllPeriodOrdersArray())
{
if (i.Id > maxId)
{
maxId = i.Id;
}
}
PeriodicalArrival arrival = new PeriodicalArrival()
{
Id = 1,
OrderId = maxId,
State = "完好",
};
Assert.AreEqual(true, periodicalBll.AddPeriodicalArrival(arrival, ref errorList));
}
private void btn_addCase_Click(object sender, EventArgs e)
{
try
{
List <string> errorList = new List <string>();//创建一个错误列表
//获取根据当前页面内容生成的登到（若有错误会被添加到错误列表中）
var list = new PeriodicalArrival[] { GetPeriodicalArrival(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="error">错误列表</param>
/// <returns>期刊登到</returns>
private PeriodicalArrival GetPeriodicalArrival(ref List <string> error)
{
List <string> errorList = new List <string>();//错误列表
//根据页面内容构造登到
PeriodicalArrival arrival = new PeriodicalArrival()
{
State = stateComboBox.Text,
};
error = errorList; //返回错误列表
return(arrival); //返回登到
}
/// <summary>
/// 获取当前窗体所表示的登到记录
/// </summary>
/// <param name="error">错误列表</param>
/// <returns>期刊登到记录</returns>
private PeriodicalArrival GetPeriodicalArrival(ref List<string> error)
{
List<string> errorList = new List<string>();//错误列表
int orderId;
//判断登到编号是否能被转换为浮点型
if (!int.TryParse(orderIdTextBox.Text, out orderId))
{
errorList.Add("OrderId Error");
}
//根据页面内容构造登到记录
PeriodicalArrival arrival = new PeriodicalArrival()
{
OrderId = orderId,
State = stateComboBox.Text,
};
error = errorList;//返回错误列表
return arrival;//返回登到
}
