/// <summary>
/// 修改一条采访清单记录
/// </summary>
/// <param name="list">采访清单</param>
/// <returns>修改成功与否</returns>
public bool UpdateInterviewList(InterviewList list, ref List <string> errorMsg)
{
bool result = false;
try
{
if (list.Id == 0)
{
errorMsg.Add("Id Error");
return(false);
}
if (!InterviewList.isNull(list)) //是否有空项
{
if (InterviewList.isNormative(list, ref errorMsg)) //是否符合规范
{
result = interviewDal.UpdateInterviewList(list);
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
return(result);
}
/// <summary>
/// 添加记录
/// </summary>
private void AddLog_Click(object sender, EventArgs e)
{
try
{
List <string> errorList = new List <string>();//创建一个错误列表
//获取根据当前页面内容生成的清单（若有错误会被添加到错误列表中）
InterviewList list = GetInterviewList(ref errorList);
//判断是否添加清单成功
if (interviewBll.AddInterviewList(list, ref errorList))
{
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("添加失败");
foreach (var i in errorList)
{
MessageBox.Show(i);//逐条显示错误信息
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
DataBind();
}
public void TestAddInterviewList()
{
Tools.UserCaseHandle userCaseHandle = new Tools.UserCaseHandle(@"C:\Users\Mr.Feng\Desktop\软工\测试用例\Add_InterviewList.xls");
IEnumerable interviewList = userCaseHandle.GetUserCases();
List <string> errorList = new List <string>();
foreach (var i in interviewList)
{
Assert.AreEqual(false, interviewBll.AddInterviewList((InterviewList)i, ref errorList));
}
InterviewList list = new InterviewList()
{
Id = 1,
Author = "测试师",
ISBN = "1234567890",
PublishingHouseId = 1,
Price = 50,
CurrencyType = "美元＄",
SubscriptionNum = 1,
DocumentType = "期刊",
OrderStatus = "采访",
BookName = "单元测试"
};
Assert.AreEqual(true, interviewBll.AddInterviewList(list, ref errorList));
}
/// <summary>
/// 获取全部订单
/// </summary>
/// <returns>全部订单</returns>
public IEnumerable GetAllInterviewListArray()
{
List <InterviewList> result = new List <InterviewList>();
try
{
DataTable datatable = interviewDal.GetAllInterviewList();
foreach (DataRow dr in datatable.Rows)
{
InterviewList interviewList = new InterviewList()
{
Id = (int)dr["清单号"],
ISBN = dr["ISBN号"].ToString(),
Author = dr["作者"].ToString(),
BookName = dr["书名"].ToString(),
Price = double.Parse(dr["价格"].ToString()),
CurrencyType = dr["货币种类"].ToString(),
SubscriptionNum = (int)dr["征订册数"],
PublishingHouseId = int.Parse(dr["出版社"].ToString()),
DocumentType = dr["文献类型"].ToString(),
OrderStatus = dr["订购状态"].ToString(),
};
result.Add(interviewList);
}
return(result);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
private void Btn_addCase_Click(object sender, EventArgs e)
{
try
{
List <string> errorList = new List <string>();//创建一个错误列表
//获取根据当前页面内容生成的订单（若有错误会被添加到错误列表中）
var list = new InterviewList[] { GetInterviewList(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 AddInterviewList(InterviewList list)
{
string sqlStr = "INSERT INTO tb_InterviewList (" +
"Author," +
"ISBN," +
"OrderStatus," +
"BookName," +
"Price," +
"CurrencyType," +
"SubscriptionNum," +
"PublishingHouseId," +
"DocumentType" +
")" +
"VALUES(" +
"@author," +
"@iSBN," +
"@orderStatus," +
"@bookName," +
"@price," +
"@currencyType," +
"@subscriptionNum," +
"@publishingHouseId," +
"@documentType" +
")";
//储存Datatable
MySqlParameter[] para = new MySqlParameter[]//存储相应参数的容器
{
new MySqlParameter("@author", list.Author),
new MySqlParameter("@iSBN", list.ISBN),
new MySqlParameter("@bookName", list.BookName),
new MySqlParameter("@price", list.Price),
new MySqlParameter("@currencyType", list.CurrencyType),
new MySqlParameter("@subscriptionNum", list.SubscriptionNum),
new MySqlParameter("@publishingHouseId", list.PublishingHouseId),
new MySqlParameter("@orderStatus", list.OrderStatus),
new MySqlParameter("@documentType", list.DocumentType),
};
int count = helper.ExecuteNonQuery(sqlStr, para, CommandType.Text);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
public override async Task <InterviewList> getInterviewListByExbContractId(ExbContractIdRequest request, ServerCallContext context)
{
try
{
InterviewList interviewList = new InterviewList();
var list = await _service.GetInterviewListByExbContractId(request.ExbContractId);
var result = Mapper.Map <List <Interview>, List <InterviewStruct> >(list);
interviewList.Listdata.AddRange(result);
interviewList.Total = result.Count;
return(interviewList);
}
catch (Exception ex)
{
LogHelper.Error(this, ex);
throw ex;
}
}
public override async Task <InterviewList> getInterviewList(PaginationRequestSearch request, ServerCallContext context)
{
try
{
InterviewList interviewList = new InterviewList();
var search = Mapper.Map <SearchStruct, SearchModel>(request.Search);
var list = await _service.GetInterviewList(request.Offset, request.Limit, search);
var result = Mapper.Map <List <Interview>, List <InterviewStruct> >(list);
interviewList.Listdata.AddRange(result);
interviewList.Total = await _service.GetInterviewListCount(search);
return(interviewList);
}
catch (Exception ex)
{
LogHelper.Error(this, ex);
throw ex;
}
}
/// <summary>
/// 增加一条采访清单记录
/// </summary>
/// <param name="list">采访清单</param>
/// <param name="errorMsg">增加成功与否</param>
/// <returns></returns>
public bool AddInterviewList(InterviewList list, ref List <string> errorMsg)
{
bool result = false;
try
{
if (!InterviewList.isNull(list)) //是否有空项
{
if (InterviewList.isNormative(list, ref errorMsg)) //是否符合规范
{
result = interviewDal.AddInterviewList(list);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
return(result);
}
/// <summary>
/// 获取当前窗体所表示的清单
/// </summary>
/// <param name="error">错误列表</param>
/// <returns>采访清单</returns>
private InterviewList GetInterviewList(ref List <string> error)
{
List <string> errorList = new List <string>();//错误列表
//出版社Id
int publisherId = ((KeyValuePair <int, string>)PublishingHouseComboBox.SelectedItem).Key;
double price;
//判断价格是否能被转换为浮点型
if (!double.TryParse(PriceTextBox.Text, out price))
{
errorList.Add("Price Error");
}
int subscriptionNum;
//判断征订册数是否能被转换为整型
if (!int.TryParse(subscriptionNumTextBox.Text, out subscriptionNum))
{
errorList.Add("Price Error");
}
//根据页面内容构造清单
InterviewList list = new InterviewList()
{
ISBN = ISBNTextBox.Text,
Author = AuthorTextBox.Text,
BookName = BookNameTextBox.Text,
Price = price,
CurrencyType = currencyTypeComboBox.Text,
SubscriptionNum = subscriptionNum,
PublishingHouseId = publisherId,
DocumentType = DocumentTypeComboBox.Text,
OrderStatus = OrderStatusComboBox.Text
};
error = errorList; //返回错误列表
return(list); //返回订单
}
/// <summary>
/// 修改一条采访清单记录
/// </summary>
/// <param name="list">采访清单</param>
/// <returns>修改成功与否</returns>
public bool UpdateInterviewList(InterviewList list)
{
string sqlStr = "UPDATE tb_InterviewList SET " +
"ISBN=@iSBN, " +
"Author=@author, " +
"BookName=@bookName, " +
"Price=@price, " +
"CurrencyType=@currencyType, " +
"SubscriptionNum=@subscriptionNum, " +
"PublishingHouseId=@publishingHouseId, " +
"DocumentType=@documentType, " +
"OrderStatus=@orderStatus " +
"where Id=@id;";
//储存Datatable
MySqlParameter[] para = new MySqlParameter[]//存储相应参数的容器
{
new MySqlParameter("@author", list.Author),
new MySqlParameter("@iSBN", list.ISBN),
new MySqlParameter("@documentType", list.DocumentType),
new MySqlParameter("@bookName", list.BookName),
new MySqlParameter("@price", list.Price),
new MySqlParameter("@currencyType", list.CurrencyType),
new MySqlParameter("@subscriptionNum", list.SubscriptionNum),
new MySqlParameter("@publishingHouseId", list.PublishingHouseId),
new MySqlParameter("@id", list.Id),
new MySqlParameter("@orderStatus", list.OrderStatus),
};
int count = helper.ExecuteNonQuery(sqlStr, para, CommandType.Text);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
public void TestUpdateInterviewList()
{
Tools.UserCaseHandle userCaseHandle = new Tools.UserCaseHandle(@"C:\Users\Mr.Feng\Desktop\软工\测试用例\Update_InterviewList.xls");
IEnumerable InterviewList = userCaseHandle.GetUserCases();
List <string> errorList = new List <string>();
foreach (var i in InterviewList)
{
Assert.AreEqual(false, interviewBll.UpdateInterviewList((InterviewList)i, ref errorList));
}
int maxId = -1;
foreach (AcceptanceList i in interviewBll.GetAllInterviewListArray())
{
if (i.Id > maxId)
{
maxId = i.Id;
}
}
if (maxId != -1)
{
InterviewList list = new InterviewList()
{
Id = 1,
Author = "测试师",
ISBN = "1234567890",
PublishingHouseId = 1,
Price = 50,
CurrencyType = "美元＄",
SubscriptionNum = 1,
DocumentType = "期刊",
OrderStatus = "采访",
BookName = "单元测试"
};
Assert.AreEqual(true, interviewBll.UpdateInterviewList(list, ref errorList));
}
}
/// <summary>
/// 保存记录
/// </summary>
private void SaveLog_Click(object sender, EventArgs e)
{
try
{
List <string> errorList = new List <string>(); //创建一个错误列表
//获取根据当前页面内容生成的清单（若有错误会被添加到错误列表中）
string interviewId = InterviewIdTextBox.Text; //获取清单号
int id;
if (!int.TryParse(interviewId, out id)) //将其转换为数字失败
{
MessageBox.Show("清单号错误");
return;
}
InterviewList list = GetInterviewList(ref errorList);
list.Id = id;//设置清单号
//判断是否添加清单成功
if (interviewBll.UpdateInterviewList(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(); //改变菜单按钮启用状态
}
