/// <summary>
/// 获取全部订单
/// </summary>
/// <returns>全部订单</returns>
public IEnumerable GetAllCreateCatalogArray()
{
List <CreateCatalogList> result = new List <CreateCatalogList>();
try
{
DataTable datatable = createDal.GetAllCatalogList();
foreach (DataRow dr in datatable.Rows)
{
CreateCatalogList createCatalogList = new CreateCatalogList()
{
Id = (int)dr["编号"],
FirstAuthor = dr["第一作者"].ToString(),
ISBN = dr["ISBN号"].ToString(),
PositiveTitle = dr["正题名"].ToString(),
PrimaryLiability = dr["第一责任"].ToString(),
DocumentType = dr["文献类型"].ToString(),
CatalogingDate = (DateTime)dr["编目日期"],
};
result.Add(createCatalogList);
}
return(result);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 修改一条采访编目记录
/// </summary>
/// <param name="list">编目清单</param>
/// <returns>修改成功与否</returns>
public bool UpdateCatalogList(CreateCatalogList list, ref List <string> errorMsg)
{
bool result = false;
try
{
if (list.Id == 0)
{
errorMsg.Add("Id Error");
return(false);
}
if (!CreateCatalogList.isNull(list)) //是否有空项
{
if (CreateCatalogList.isNormative(list, ref errorMsg)) //是否符合规范
{
result = createDal.UpdateCatalogList(list);
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
return(result);
}
public void AddCatalogListTest()
{
Tools.UserCaseHandle userCaseHandle = new Tools.UserCaseHandle(@"E:\大三课程文档汇总\软件工程\FunctionTest\Add_CreateCatalogList.xls");
IEnumerable createCatalog = userCaseHandle.GetUserCases();
List <string> errorList = new List <string>();
foreach (var i in createCatalog)
{
Assert.AreEqual(false, createCatalogBll.AddCatalogList((CreateCatalogList)i, ref errorList));
}
CreateCatalogList list = new CreateCatalogList()
{
Id = 1,
ISBN = "1234567890",
PositiveTitle = "阿衰正传" + DateTime.Now.Date.ToString("yy-MM-dd"),
FirstAuthor = "小七" + DateTime.Now.Date.ToString("yy-MM-dd"),
PrimaryLiability = "笑哈哈出版社" + DateTime.Now.Date.ToString("yy-MM-dd"),
CatalogerId = 1,
CatalogingDate = DateTime.Now,
DocumentType = "专著",
PublishingHouseId = 1,
};
Assert.AreEqual(true, createCatalogBll.AddCatalogList(list, ref errorList));
}
/// <summary>
/// 增加记录
/// </summary>
private void AddLog_Click(object sender, EventArgs e)
{
try
{
List <string> errorList = new List <string>();//创建一个错误列表
//获取根据当前页面内容生成的订单（若有错误会被添加到错误列表中）
CreateCatalogList list = GetCatalogList(ref errorList);
//判断是否添加订单成功
if (createCatalogBll.AddCatalogList(list, 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="error">错误列表</param>
/// <returns>编目清单</returns>
private CreateCatalogList GetCatalogList(ref List <string> error)
{
List <string> errorList = new List <string>();//错误列表
//出版社Id
int publisherId = ((KeyValuePair <int, string>)PublishingHouseComboBox.SelectedItem).Key;
//编目人员ID
int catalogerId = utilBll.GetUserIdFormNumber(CatalogerIdTextBox.Text);
//根据页面内容构造清单
CreateCatalogList list = new CreateCatalogList()
{
ISBN = ISBNTextBox.Text,
FirstAuthor = AuthorTextBox.Text,
PositiveTitle = BookNameTextBox.Text,
CatalogingDate = CatalogDateTimePicker.Value,
PublishingHouseId = publisherId,
DocumentType = DocumentTypeComboBox.Text,
CatalogerId = catalogerId,
PrimaryLiability = PrimaryLiabilityLabelTextBox.Text
};
error = errorList; //返回错误列表
return(list); //返回清单
}
private void btn_addCase_Click(object sender, EventArgs e)
{
try
{
List <string> errorList = new List <string>();//创建一个错误列表
//获取根据当前页面内容生成的订单（若有错误会被添加到错误列表中）
var list = new CreateCatalogList[] { GetCatalogList(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 AddCatalogList(CreateCatalogList list)
{
string sqlStr = "INSERT INTO tb_CatalogForm (" +
"ISBN," +
"PositiveTitle," +
"FirstAuthor," +
"PublishingHouseId," +
"DocumentType," +
"PrimaryLiability," +
"CatalogerId," +
"CatalogingDate" +
")" +
"VALUES(" +
"@iSBN," +
"@positiveTitel," +
"@firstAuther," +
"@publishingHouseId," +
"@documentType," +
"@primaryLiability," +
"@catalogerId," +
"@catalogingDate" +
")";
//储存Datatable
MySqlParameter[] para = new MySqlParameter[]//存储相应参数的容器
{
new MySqlParameter("@iSBN", list.ISBN),
new MySqlParameter("@positiveTitel", list.PositiveTitle),
new MySqlParameter("@firstAuther", list.FirstAuthor),
new MySqlParameter("@publishingHouseId", list.PublishingHouseId),
new MySqlParameter("@documentType", list.DocumentType),
new MySqlParameter("@primaryLiability", list.PrimaryLiability),
new MySqlParameter("@catalogerId", list.CatalogerId),
new MySqlParameter("@catalogingDate", list.CatalogingDate),
};
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 CreateCatalogList GetCatalogList(ref List <string> error)
{
List <string> errorList = new List <string>();//错误列表
//根据页面内容构造清单
CreateCatalogList list = new CreateCatalogList()
{
ISBN = ISBNTextBox.Text,
FirstAuthor = AuthorTextBox.Text,
PublishingHouseId = int.Parse(publishingHouseTextBox.Text),
PositiveTitle = BookNameTextBox.Text,
CatalogingDate = CatalogDateTimePicker.Value,
DocumentType = DocumentTypeComboBox.Text,
PrimaryLiability = PrimaryLiabilityLabelTextBox.Text
};
error = errorList; //返回错误列表
return(list); //返回清单
}
/// <summary>
/// 增加一条编目记录
/// </summary>
/// <param name="list">编目列表</param>
/// <param name="errorMsg">增加成功与否</param>
/// <returns></returns>
public bool AddCatalogList(CreateCatalogList list, ref List <string> errorMsg)
{
bool result = false;
try
{
if (!CreateCatalogList.isNull(list)) //是否有空项
{
if (CreateCatalogList.isNormative(list, ref errorMsg)) //是否符合规范
{
result = createDal.AddCatalogList(list);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
return(result);
}
public IEnumerable GetMoveCatalog()
{
List <CreateCatalogList> result = new List <CreateCatalogList>();
try
{
DataTable datatable = createDal.GetAllQueryCatalogForm();
foreach (DataRow dr in datatable.Rows)
{
CreateCatalogList createCatalogList = new CreateCatalogList()
{
Id = (int)dr["编号"]
};
result.Add(createCatalogList);
}
return(result);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 修改一条直接编目记录
/// </summary>
/// <param name="list">编目清单</param>
/// <returns>修改成功与否</returns>
public bool UpdateCatalogList(CreateCatalogList list)
{
string sqlStr = "UPDATE tb_CatalogForm SET " +
"ISBN=@iSBN, " +
"PositiveTitle=@positiveTitle, " +
"FirstAuthor=@firstAuthor, " +
"PublishingHouseId=@publishingHouseId, " +
"DocumentType=@documentType, " +
"PrimaryLiability=@primaryLiability, " +
"CatalogerId=@catalogerId, " +
"CatalogingDate=@catalogingDate " +
"where Id=@id;";
//储存Datatable
MySqlParameter[] para = new MySqlParameter[]//存储相应参数的容器
{
new MySqlParameter("@iSBN", list.ISBN),
new MySqlParameter("@documentType", list.DocumentType),
new MySqlParameter("@positiveTitle", list.PositiveTitle),
new MySqlParameter("@firstAuthor", list.FirstAuthor),
new MySqlParameter("@publishingHouseId", list.PublishingHouseId),
new MySqlParameter("@primaryLiability", list.PrimaryLiability),
new MySqlParameter("@catalogerId", list.CatalogerId),
new MySqlParameter("@catalogingDate", list.CatalogingDate),
new MySqlParameter("@id", list.Id),
};
int count = helper.ExecuteNonQuery(sqlStr, para, CommandType.Text);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 保存记录
/// </summary>
private void SaveLog_Click(object sender, EventArgs e)
{
try
{
List <string> errorList = new List <string>(); //创建一个错误列表
//获取根据当前页面内容生成的清单（若有错误会被添加到错误列表中）
string createId = idTextBox.Text; //获取清单号
int id;
if (!int.TryParse(createId, out id)) //将其转换为数字失败
{
MessageBox.Show("清单号错误");
return;
}
CreateCatalogList list = GetCatalogList(ref errorList);
list.Id = id;//设置清单号
//判断是否添加清单成功
if (createCatalogBll.UpdateCatalogList(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(); //改变菜单按钮启用状态
}
public bool MoveCatalog(int Id)
{
string sqlStr = " SELECT " +
" tb_CatalogForm.Id AS `编目编号`, " +
" tb_CatalogForm.ISBN AS ISBN, " +
" tb_CatalogForm.PositiveTitle AS `题目名称`, " +
" tb_CatalogForm.FirstAuthor AS `第一作者`, " +
" tb_CatalogForm.PublishingHouseId AS `出版社编号`, " +
" tb_CatalogForm.DocumentType AS `文献类型`, " +
" tb_CatalogForm.State AS `编目状态` " +
" FROM " +
" tb_CatalogForm " +
" WHERE " +
" tb_CatalogForm.Id = @id " +
" AND tb_CatalogForm.State = '未处理';";
MySqlParameter[] paras = new MySqlParameter[]
{
new MySqlParameter("@id", Id),
};
DataTable dataTable = helper.ExecuteQuery(sqlStr, paras, CommandType.Text);
if (dataTable.Rows.Count <= 0)
{
return(false);
}
DataRow row = dataTable.Rows[0];
CreateCatalogList createCatalogList = new CreateCatalogList()
{
Id = int.Parse(row["编目编号"].ToString()),
ISBN = row["ISBN"].ToString(),
PositiveTitle = row["题目名称"].ToString(),
FirstAuthor = row["第一作者"].ToString(),
PublishingHouseId = int.Parse(row["出版社编号"].ToString()),
DocumentType = row["文献类型"].ToString(),
};
sqlStr = "UPDATE tb_CatalogForm SET tb_CatalogForm.State='已处理' where tb_CatalogForm.state='未处理' and tb_CatalogForm.Id=@id";
paras = new MySqlParameter[]
{
new MySqlParameter("@id", createCatalogList.Id),
};
int count = helper.ExecuteNonQuery(sqlStr, paras, CommandType.Text);
sqlStr = "INSERT INTO tb_CirculateBooks (" +
" tb_CirculateBooks.ISBN," +
" tb_CirculateBooks.FirstAuthor," +
" tb_CirculateBooks.DocumentType, " +
"tb_CirculateBooks.BookStatus, " +
"tb_CirculateBooks.OfficialTitle, " +
"tb_CirculateBooks.PublishingHouseId" +
" )VALUES" +
"(" +
"@iSBN," +
"@firstAuther," +
"@documentType," +
"@bookStatus," +
"@officialTitle," +
"@publishingHouseId" +
")";
paras = new MySqlParameter[]
{
new MySqlParameter("@iSBN", createCatalogList.ISBN),
new MySqlParameter("@firstAuther", createCatalogList.FirstAuthor),
new MySqlParameter("@documentType", createCatalogList.DocumentType),
new MySqlParameter("@bookStatus", "可借阅"),
new MySqlParameter("@officialTitle", createCatalogList.PositiveTitle),
new MySqlParameter("@publishingHouseId", createCatalogList.PublishingHouseId),
};
count = helper.ExecuteNonQuery(sqlStr, paras, CommandType.Text);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
