/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult CheckRecord(string id)
{
DCheckInfo CheckInfo = new DCheckInfo();
CheckInfo.StrECode = id;
return(View(CheckInfo));
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult EquipCheck(string id)
{
string[] arr = id.Split('@');
DCheckInfo CheckInfo = new DCheckInfo();
CheckInfo.StrECode = arr[0];
CheckInfo.StrCheckCompany = arr[1];
CheckInfo.StrCheckWay = arr[2];
return(View(CheckInfo));
}
//合并单元格
//private static void mergeCell(ISheet sheet, int firstRow, int lastRow, int firstCell, int lastCell)
//{
// sheet.AddMergedRegion(new CellRangeAddress(firstRow, lastRow, firstCell, lastCell));//2.0使用 2.0以下为Region
//}
//public static HSSFCellStyle SetCellStyle(HSSFWorkbook workbook)
//{
// HSSFCellStyle CellStyle = (HSSFCellStyle)workbook.CreateCellStyle();
// //CellStyle.FillForegroundColor = HSSFColor.LAVENDER.index;
// CellStyle.WrapText = true;
// CellStyle.Alignment = HorizontalAlignment.LEFT;
// CellStyle.VerticalAlignment = VerticalAlignment.CENTER;
// // fCellStyle.FontIndex = HSSFFont.FONT_ARIAL.;
// HSSFFont ffont = (HSSFFont)workbook.CreateFont();
// ffont.FontHeight = 20 * 20;
// ffont.FontName = "宋体";
// ffont.Boldweight = (short)FontBoldWeight.BOLD;
// //ffont.Boldweight = ;
// //ffont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
// //CellStyle.BorderBottom = BorderStyle.THIN;
// //CellStyle.BorderLeft = BorderStyle.THIN;
// //CellStyle.BorderRight = BorderStyle.THIN;
// //CellStyle.BorderTop = BorderStyle.THIN;
// // fCellStyle .BorderBottom
// // ffont.Color = HSSFColor.;
// CellStyle.SetFont(ffont);
// CellStyle.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.CENTER;//.Center;//垂直对齐
// CellStyle.FillPattern = FillPatternType.SOLID_FOREGROUND;
// return CellStyle;
//}
//public void ToWord(DataTable dt, Page page, string filName)
//{
// HttpResponse response = page.Response;
// response.Clear();
// response.ContentType = "application/msword";
// response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
// response.AddHeader("Content-Disposition","attachment:filename="+System.Web.HttpUtility.UrlEncode(filName,System.Text.Encoding.UTF8)+".doc");
// StringBuilder sBuilder = new StringBuilder();
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// sBuilder.Append(dt.Rows[i][1].ToString()+"\n");
// }
// response.Write(sBuilder.ToString());
// response.End();
//}
/// <summary>
///
/// </summary>
/// <param name="CheckInfo"></param>
/// <param name="Did"></param>
/// <param name="num"></param>
/// <returns></returns>
public ActionResult UpNewCheckInfo(DCheckInfo CheckInfo, string Did, string num)
{
string strErr = "";
if (EquipMan.UpdateNewDCheckInfo(CheckInfo, Did, num, ref strErr) == true)
{
return(Json(new { success = "true", Msg = "保存成功" }));
}
else
{
return(Json(new { success = "false", Msg = "保存出错" + "/" + strErr }));
}
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult UpDCheckInfo(string id)
{
string[] arrA = id.Split('@');
string Did = arrA[0];
string num = arrA[1];
ViewData["Did"] = Did;
ViewData["num"] = num;
DCheckInfo CheckInfo = new DCheckInfo();
CheckInfo = EquipMan.getNewUpdateDCheckInfo(Did);
return(View(CheckInfo));
}
/// <summary>
///
/// </summary>
/// <param name="CheckInfo"></param>
/// <returns></returns>
public ActionResult InsertDCheckInfo(DCheckInfo CheckInfo)
{
string strErr = "";
if (EquipMan.InsertNewDCheckInfo(CheckInfo, ref strErr) == true)
{
return(Json(new { success = "true", Msg = "保存成功" }));
}
else
{
return(Json(new { success = "false", Msg = "保存出错" + "/" + strErr }));
}
}
