/// <summary>
/// 获取当前窗体所表示的退货清单
/// </summary>
/// <param name="error">错误列表</param>
/// <returns>退货清单</returns>
private InterviewReturnList GetReturnList(ref List <string> error)
{
List <string> errorList = new List <string>();//错误列表
//通过订购人账号获取id
int ordererId = int.Parse(SubscriberTextBox.Text);
double price;
//判断价格是否能被转换为整型
if (!double.TryParse(priceTextBox.Text, out price))
{
errorList.Add("OrderPrice Error");
}
//根据页面内容构造清单
InterviewReturnList list = new InterviewReturnList()
{
SubDate = subDatePicker.Value,
ISBN = ISBNtextBox.Text,
OrdererId = ordererId,
BookName = bookNameTextBox.Text,
Price = price,
PublishingHouseId = int.Parse(PublishingHouseTextBox.Text),
DocumentType = documentTypeComboBox.Text,
};
error = errorList; //返回错误列表
return(list); //返回清单
}
/// <summary>
/// 添加记录
/// </summary>
private void AddButton_Click(object sender, EventArgs e)
{
try
{
List <string> errorList = new List <string>();//创建一个错误列表
//获取根据当前页面内容生成的清单（若有错误会被添加到错误列表中）
InterviewReturnList list = GetReturnList(ref errorList);
//判断是否添加清单成功
if (interviewBll.AddReturnList(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 InterviewReturnList[] { GetReturnList(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>
/// <returns>全部订单</returns>
public IEnumerable GetAllReturnListArray()
{
List <InterviewReturnList> result = new List <InterviewReturnList>();
try
{
DataTable datatable = interviewDal.GetAllReturnList();
foreach (DataRow dr in datatable.Rows)
{
InterviewReturnList interviewReturnList = new InterviewReturnList()
{
Id = (int)dr["清单号"],
SubDate = (DateTime)dr["订单日期"],
ISBN = dr["ISBN号"].ToString(),
OrdererId = (int)dr["订购人ID"],
BookName = dr["书名"].ToString(),
Price = double.Parse(dr["价格"].ToString()),
PublishingHouseId = int.Parse(dr["出版社ID"].ToString()),
DocumentType = dr["文献类型"].ToString(),
};
result.Add(interviewReturnList);
}
return(result);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 增加一条退货清单记录
/// </summary>
/// <param name="list">退货清单</param>
/// <returns>增加成功与否</returns>
public bool AddReturnList(InterviewReturnList list)
{
string sqlStr = "INSERT INTO tb_InterviewReturnList (" +
"Id," +
"SubDate," +
"ISBN," +
"OrdererId," +
"BookName," +
"Price," +
"PublishingHouseId," +
"DocumentType" +
")" +
"VALUES(" +
"@id," +
"@subDate," +
"@iSBN," +
"@ordererId," +
"@bookName," +
"@price," +
"@publishingHouseId," +
"@documentType" +
")";
//储存Datatable
MySqlParameter[] para = new MySqlParameter[]//存储相应参数的容器
{
new MySqlParameter("@id", list.Id),
new MySqlParameter("@subDate", list.SubDate),
new MySqlParameter("@iSBN", list.ISBN),
new MySqlParameter("@ordererId", list.OrdererId),
new MySqlParameter("@bookName", list.BookName),
new MySqlParameter("@price", list.Price),
new MySqlParameter("@publishingHouseId", list.PublishingHouseId),
new MySqlParameter("@documentType", list.DocumentType),
};
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 InterviewReturnList GetReturnList(ref List <string> error)
{
List <string> errorList = new List <string>();//错误列表
//出版社Id
int publisherId = ((KeyValuePair <int, string>)publishingHouseComboBox.SelectedItem).Key;
//判断订购人账号是否符合要求
Match matchOrderer = Regex.Match(SubscriberTextBox.Text, @"(^\d{8}$)|(^\d{10}$)|(^\d{12}$)");
if (!matchOrderer.Success)
{
errorList.Add("OrdererNumber Error");
}
//通过订购人账号获取id
int ordererId = utilBll.GetUserIdFormNumber(SubscriberTextBox.Text);
double price;
//判断价格是否能被转换为整型
if (!double.TryParse(priceTextBox.Text, out price))
{
errorList.Add("OrderPrice Error");
}
//根据页面内容构造清单
InterviewReturnList list = new InterviewReturnList()
{
SubDate = subDatePicker.Value,
ISBN = ISBNtextBox.Text,
OrdererId = ordererId,
BookName = bookNameTextBox.Text,
Price = price,
PublishingHouseId = publisherId,
DocumentType = documentTypeComboBox.Text,
};
error = errorList; //返回错误列表
return(list); //返回清单
}
/// <summary>
/// 增加一条退货清单记录
/// </summary>
/// <param name="list">退货清单</param>
/// <param name="errorMsg">增加成功与否</param>
/// <returns></returns>
public bool AddReturnList(InterviewReturnList list, ref List <string> errorMsg)
{
bool result = false;
try
{
if (!InterviewReturnList.isNull(list)) //是否有空项
{
if (InterviewReturnList.isNormative(list, ref errorMsg)) //是否符合规范
{
result = interviewDal.AddReturnList(list);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
return(result);
}
public void TestAddReturnList()
{
Tools.UserCaseHandle userCaseHandle = new Tools.UserCaseHandle(@"C:\Users\96464\Desktop\软件工程\测试用例\Add_AcceptanceList.xls");
IEnumerable returnList = userCaseHandle.GetUserCases();
List <string> errorList = new List <string>();
foreach (var i in returnList)
{
Assert.AreEqual(false, interviewBll.AddAcceptanceList((AcceptanceList)i, ref errorList));
}
InterviewReturnList list = new InterviewReturnList()
{
Id = 1,
ISBN = "1234567890",
OrdererId = 1,
BookName = "采访单元测试",
Price = 1,
PublishingHouseId = 1,
DocumentType = "专著",
};
Assert.AreEqual(true, interviewBll.AddReturnList(list, ref errorList));
}
