public static int update(ModelCheckoutContract model)
{
string strSQL = @"
UPDATE checkout_contract
SET
id_admin = @id_admin,
time_create = @time_create,
name_unit = @name_unit,
name_department = @name_department,
name_sign = @name_sign,
photo_urls = @photo_urls,
comment = @comment,
flag = @flag
WHERE
id = @id
";
MySqlParameter[] aryParams = new MySqlParameter[9];
aryParams[0] = new MySqlParameter("@id_admin", model.id_admin);
aryParams[1] = new MySqlParameter("@time_create", model.time_create);
aryParams[2] = new MySqlParameter("@name_unit", model.name_unit);
aryParams[3] = new MySqlParameter("@name_department", model.name_department);
aryParams[4] = new MySqlParameter("@name_sign", model.name_sign);
aryParams[5] = new MySqlParameter("@photo_urls", model.photo_urls);
aryParams[6] = new MySqlParameter("@comment", model.comment);
aryParams[7] = new MySqlParameter("@flag", model.flag);
aryParams[8] = new MySqlParameter("@id", model.id);
return((int)HelperMySql.ExecuteNonQuery(strSQL, aryParams));
}
public static ModelCheckoutContract getById(int intId)
{
string strSQL = @"SELECT * FROM checkout_contract WHERE id = @id";
MySqlParameter[] aryParams = new MySqlParameter[1];
aryParams[0] = new MySqlParameter("@id", intId);
DataTable objDT = HelperMySql.GetDataTable(strSQL, aryParams);
if (objDT != null && objDT.Rows.Count > 0)
{
ModelCheckoutContract model = new ModelCheckoutContract();
model.id = Convert.ToInt32(objDT.Rows[0]["id"]);
model.id_admin = Convert.ToInt32(objDT.Rows[0]["id_admin"]);
model.time_create = Convert.ToDateTime(objDT.Rows[0]["time_create"]);
model.name_unit = Convert.ToString(objDT.Rows[0]["name_unit"]);
model.name_department = Convert.ToString(objDT.Rows[0]["name_department"]);
model.name_sign = Convert.ToString(objDT.Rows[0]["name_sign"]);
model.photo_urls = Convert.ToString(objDT.Rows[0]["photo_urls"]);
model.comment = Convert.ToString(objDT.Rows[0]["comment"]);
model.flag = Convert.ToInt16(objDT.Rows[0]["flag"]);
return(model);
}
else
{
return(null);
}
}
public static int add(ModelCheckoutContract model)
{
string strSQL = @"
INSERT INTO checkout_contract (
id_admin,
time_create,
name_unit,
name_department,
name_sign,
photo_urls,
comment,
flag
) VALUES (
@id_admin,
@time_create,
@name_unit,
@name_department,
@name_sign,
@photo_urls,
@comment,
@flag
)";
MySqlParameter[] aryParams = new MySqlParameter[8];
aryParams[0] = new MySqlParameter("@id_admin", model.id_admin);
aryParams[1] = new MySqlParameter("@time_create", model.time_create);
aryParams[2] = new MySqlParameter("@name_unit", model.name_unit);
aryParams[3] = new MySqlParameter("@name_department", model.name_department);
aryParams[4] = new MySqlParameter("@name_sign", model.name_sign);
aryParams[5] = new MySqlParameter("@photo_urls", model.photo_urls);
aryParams[6] = new MySqlParameter("@comment", model.comment);
aryParams[7] = new MySqlParameter("@flag", model.flag);
if (HelperMySql.ExecuteNonQuery(strSQL, aryParams) > 0)
{
strSQL = "SELECT MAX(id) FROM checkout_contract";
object objReturn = HelperMySql.ExecuteScalar(strSQL);
return(objReturn == null ? 0 : Convert.ToInt32(objReturn));
}
else
{
return(0);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int intAdminId = HelperUtility.hasPurviewPage("CheckoutContract_update");
ViewState["AdminId"] = intAdminId;
// 本页只能从list.aspx的编辑页转过来
// 因此要得到要修改的id值和页面的page值用于修改成功后返回
int intId = HelperUtility.getQueryInt("id");
ViewState["id"] = intId;
int intPage = HelperUtility.getQueryInt("page");
ViewState["page"] = intPage;
if (HelperUtility.hasPurviewPage("SUPERADMIN") > 0)
{
cbFlag.Visible = true;
}
// 根据入库单id查询得到入库单model
ModelCheckoutContract model = BllCheckoutContract.getById(intId);
List <string> listUnitName = model.name_unit.Split(',').ToList();
if (!"".Equals(listUnitName[0]))
{
cbUnitName1.Checked = true;
}
if (!"".Equals(listUnitName[1]))
{
cbUnitName2.Checked = true;
}
tbDepartmentName.Value = model.name_department;
tbSignName.Value = model.name_sign;
tbTimeCreate.Value = model.time_create.ToString("yyyy-MM-dd");
tbComment.Text = model.comment;
if (model.flag > 0)
{
cbFlag.Checked = true;
}
BllDepartment.bindRPT(rptName);
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
if (!HelperUtility.hasPurviewOP("CheckoutContract_update"))
{
HelperUtility.showAlert("没有操作权限", "/BackManager/home.aspx");
}
int intAdminId = (int)ViewState["AdminId"];
int intId = (int)ViewState["id"];
int intPage = (int)ViewState["page"];
string strThisPageUrl = "edit.aspx?id=" + intId + "&page=" + intPage;
// 验证输入
string strMsgError = "";
string strUnitName, strUnitName1, strUnitName2;
strUnitName1 = cbUnitName1.Checked ? cbUnitName1.Value : "";
strUnitName2 = cbUnitName2.Checked ? cbUnitName2.Value : "";
strUnitName = strUnitName1 + "," + strUnitName2;
if (",".Equals(strUnitName))
{
strMsgError += "申请单位至少选一个！";
}
string strDepartmentName = tbDepartmentName.Value.Trim();
if ("".Equals(strDepartmentName))
{
strMsgError += "申请部门/科室不能为空！";
}
string strSignName = tbSignName.Value.Trim();
if ("".Equals(strSignName))
{
strMsgError += "申请人姓名不能为空！";
}
string strTimeCreate = tbTimeCreate.Value.Trim();
if ("".Equals(strTimeCreate))
{
strMsgError += "签发时间不能为空！";
}
if (!HelperUtility.isDateType(strTimeCreate))
{
strMsgError += "签发时间格式不正确！";
}
string strComment = tbComment.Text.Trim();
if (strComment.Length > 500)
{
strMsgError += "备注信息不能超过500个字数！";
}
if (!"".Equals(strMsgError))
{
HelperUtility.showAlert(strMsgError, strThisPageUrl);
return;
}
string strPhotoUrls = "";
// 验证完毕，提交数据
ModelCheckoutContract model = BllCheckoutContract.getById(intId);
model.id_admin = intAdminId;
model.time_create = Convert.ToDateTime(strTimeCreate);
model.name_unit = strUnitName;
model.name_department = strDepartmentName;
model.name_sign = strSignName;
model.photo_urls = strPhotoUrls;
model.comment = strComment;
if (cbFlag.Checked)
{
model.flag = 1;
}
else
{
model.flag = 0;
}
// 更新数据库记录
BllCheckoutContract.update(model);
// 跳转回列表页
Response.Redirect("/BackManager/checkout_contract/list.aspx?page=" + intPage);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (!HelperUtility.hasPurviewOP("CheckoutContract_add"))
{
string strUrl = "/BackManager/home.aspx";
HelperUtility.showAlert("没有操作权限", strUrl);
}
string strMsgError = "";
string strUnitName, strUnitName1, strUnitName2;
strUnitName1 = cbUnitName1.Checked ? cbUnitName1.Value : "";
strUnitName2 = cbUnitName2.Checked ? cbUnitName2.Value : "";
strUnitName = strUnitName1 + "," + strUnitName2;
if (",".Equals(strUnitName))
{
strMsgError += "申请单位至少选一个！";
}
string strDepartmentName = tbDepartmentName.Value.Trim();
if ("".Equals(strDepartmentName))
{
strMsgError += "申请部门/科室不能为空！";
}
string strSignName = tbSignName.Value.Trim();
if ("".Equals(strSignName))
{
strMsgError += "申请人姓名不能为空！";
}
string strComment = tbComment.Text.Trim();
if (strComment.Length > 500)
{
strMsgError += "备注信息不能超过500个字数！";
}
if (!"".Equals(strMsgError))
{
HelperUtility.showAlert(strMsgError, "add.aspx");
return;
}
string strPhotoUrls = "";
// 验证完毕，提交数据
int intAdminId = (int)ViewState["AdminId"];
ModelCheckoutContract model = new ModelCheckoutContract();
model.id_admin = intAdminId;
model.time_create = DateTime.Now;
model.name_unit = strUnitName;
model.name_department = strDepartmentName;
model.name_sign = strSignName;
model.photo_urls = strPhotoUrls;
model.comment = strComment;
if (cbFlag.Checked)
{
model.flag = 1;
}
else
{
model.flag = 0;
}
int intId = BllCheckoutContract.add(model);
if (intId > 0)
{
string strUrl = "list.aspx";
HelperUtility.showAlert("添加成功！", strUrl);
}
else
{
string strUrl = "add.aspx";
HelperUtility.showAlert("添加失败，请联系管理员！", strUrl);
}
}
/// <summary>
/// 导出记录出库单货品清单的Excel文件
/// </summary>
/// <param name="intContractId">出库单id号</param>
/// <returns>5条记录为一个excel文件，每个文件的地址存到数组里输出</returns>
public static string[] setExcel(int intContractId)
{
// 得到此出库单的信息
ModelCheckoutContract model = getById(intContractId);
// 得到收货单位名称
string strNameUnit = model.name_unit;
string[] aryUnit = strNameUnit.Split(',');
// 得到收货部门科室名称
string strNameDepartment = model.name_department;
// 设置出库单时间
string strYear = model.time_create.Year.ToString();
string strMonth = model.time_create.Month.ToString();
string strDay = model.time_create.Day.ToString();
string strDateShow = " " + strYear + " " + strMonth + " " + strDay;
// 根据出库单ID得到此出库单下所有的出库货品记录，转成DataTable作为Excel文件的数据源
DataTable objDTAll = BllCheckoutRecord.getAll(intContractId);
DataSet objDS = HelperUtility.splitDataTable(objDTAll, 5);
List <string> listReturn = new List <string>();
DataTable objDT;
string strExcelTemplateFileName, strExcelOutFileName;
// 不同的收货单位要设置不同的模板，二院的肯定要生成
if ("信州区第二人民医院".Equals(aryUnit[0]))
{
for (int i = 0; i < objDS.Tables.Count; i++)
{
// 先对DataTable里的数据进行改造
objDT = objDS.Tables[i];
objDT.TableName = "DataTable";
WorkbookDesigner objDesigner = new WorkbookDesigner();
objDesigner.SetDataSource("NameUnit", aryUnit[0]);
objDesigner.SetDataSource("NameDepartment", strNameDepartment);
objDesigner.SetDataSource("DateShow", strDateShow);
objDesigner.SetDataSource(objDT);
strExcelTemplateFileName = "/Excel/Template/02出库单.xlsx";
// 设置要输出的每个Excel文件的文件名
strExcelOutFileName = "/Excel/Export/出库单[区二院-" + strNameDepartment + "-" +
model.time_create.ToString("yyMMdd") + "]-" + (i + 1) + ".xlsx";
// 根据以上参数生成excel文件，并输出生成的excel文件路径
HelperExcel.ExportExcelByTemplate(objDesigner, strExcelTemplateFileName, strExcelOutFileName);
listReturn.Add(strExcelOutFileName);
// 处理完成后把表名改成别的名字，DS中不能有重名的Table
objDT.TableName = "DataTable" + i;
}
}
// 如果社区的也要打就在此生成
if ("东市街道社区卫生服务中心".Equals(aryUnit[1]))
{
for (int i = 0; i < objDS.Tables.Count; i++)
{
// 先对DataTable里的数据进行改造
objDT = objDS.Tables[i];
objDT.TableName = "DataTable";
WorkbookDesigner objDesigner = new WorkbookDesigner();
objDesigner.SetDataSource("NameUnit", aryUnit[1]);
objDesigner.SetDataSource("NameDepartment", strNameDepartment);
objDesigner.SetDataSource("DateShow", strDateShow);
objDesigner.SetDataSource(objDT);
strExcelTemplateFileName = "/Excel/Template/02出库单.xlsx";
// 设置要输出的每个Excel文件的文件名
strExcelOutFileName = "/Excel/Export/出库单[东市-" + strNameDepartment + "-" +
model.time_create.ToString("yyMMdd") + "]-" + (i + 1) + ".xlsx";
// 根据以上参数生成excel文件，并输出生成的excel文件路径
HelperExcel.ExportExcelByTemplate(objDesigner, strExcelTemplateFileName, strExcelOutFileName);
listReturn.Add(strExcelOutFileName);
// 处理完成后把表名改成别的名字，DS中不能有重名的Table
objDT.TableName = "DataTable" + i;
}
}
return(listReturn.ToArray());
}
public static int update(ModelCheckoutContract model)
{
return(DalCheckoutContract.update(model));
}
public static int add(ModelCheckoutContract model)
{
return(DalCheckoutContract.add(model));
}
