/// <summary>
/// 检索条件
/// </summary>
/// <returns></returns>
private string GetSearchCondition(DataTableUtils.DataTableModel dtm)
{
string where = "InstrumentForm=" + (int)Constants.InstrumentForm.仪器;
if (!string.IsNullOrWhiteSpace(dtm.FieldCondition))
{
where = string.Format("{0} and {1}", dtm.FieldCondition, where);
}
//所属部门
string orgName = Request["searchBelongDepart"];
where = Global.Business.ServiceProvider.UserManageDepartService.GetManageAndDepartSearchCondition(where, "InstrumentFlow-CheckAll", orgName);
//if (!string.IsNullOrEmpty(orgName))
//{
// IList<OrgModel> orgList = Global.Business.ServiceProvider.OrgService.GetAll().Where(o => o.OrgName == orgName).ToList();
// string strFilte = "";
// foreach (OrgModel org in orgList)
// {
// if (string.IsNullOrWhiteSpace(strFilte))
// strFilte = string.Format("BelongDepart like '{0}%'", org.OrgCode);
// else
// strFilte = string.Format("{0} or BelongDepart like '{1}%'", strFilte, org.OrgCode);
// }
// where = string.Format("{0} and ({1})", where, strFilte);
//}
return(where);
}
/// <summary>
/// 上传文件列表数据
/// </summary>
/// <returns></returns>
public JsonResult GetAttachmentListJsonData()
{
//提取DataTable参数
DataTableUtils.DataTableModel dtm = DataTableUtils.GetJquerydataTableParams();
//构造输入参数
PagingModel paging = new PagingModel();
paging.PageSize = dtm.PageSize;
paging.PageCurrent = dtm.PageIndex;
paging.Where = string.IsNullOrWhiteSpace(dtm.FieldCondition) ? "1=1" : dtm.FieldCondition;
if (!string.IsNullOrWhiteSpace(dtm.KeyWord))
{
paging.Where = string.Format("{0} and (FileName like '{1}%' or UserName like '{1}%')", paging.Where, dtm.KeyWord);
}
IList <Hashtable> attachmentList = ServiceProvider.AttachmentService.GetAttachmentListForPaging(paging);
//Json数据格式组装
dtm.iTotalRecords = paging.RecordCount;
dtm.iTotalDisplayRecords = dtm.iTotalRecords;
dtm.aaData = new List <List <string> >();
//列表项：文件显示名称、文件大小、文件类型、上传人、上传时间、文件路径
StringBuilder operate = new StringBuilder();
foreach (var item in attachmentList)
{
string fileSite = item["FileAccessPrefix"].ToString() + item["FileVirtualPath"].ToString();
string fileId = UtilsHelper.Encrypt(item["FileId"].ToString());
int fileServerType = int.Parse(item["FileServerType"].ToString());
int fileSize = int.Parse(item["FileSize"].ToString()) / 1024;
dtm.aaData.Add(new List <string>());
if (LoginHelper.LoginUserAuthorize.ContainsKey("/SysManage/Attachment/List".ToLower()))
{
operate.AppendFormat("<a href='/SysManage/Attachment/DownLoad?fileId={0}' target='_blank'>下载</a> | <a href='#' fileId='{0}' fileName='{1}' onclick='fnDeleteAttachment(this);return false;' >删除</a>", fileId, item["FileName"].ToString());
}
dtm.aaData[dtm.aaData.Count - 1].Add(operate.ToString());
operate.Clear();
dtm.aaData[dtm.aaData.Count - 1].Add(item["FileName"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(fileSize.ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(((UtilConstants.AttachmentType)Convert.ToInt16(item["FileType"])).ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(item["UserName"] == null ?string.Empty:item["UserName"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(DateTime.Parse(item["CreateDate"].ToString()).ToString("yyyy-MM-dd"));
dtm.aaData[dtm.aaData.Count - 1].Add(item["FileAccessPrefix"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(item["FileVirtualPath"].ToString());
}
JsonResult jr = Json(new
{
sEcho = dtm.sEcho,
iTotalRecords = dtm.iTotalRecords,
iTotalDisplayRecords = dtm.iTotalDisplayRecords,
aaData = dtm.aaData
}, JsonRequestBehavior.AllowGet);
return(jr);
}
/// <summary>
/// 获取知识库
/// </summary>
/// <returns></returns>
public JsonResult GetAllKnowledgeListJsonData()
{
//提取DataTable参数
DataTableUtils.DataTableModel dtm = DataTableUtils.GetJquerydataTableParams();
//构造输入参数
PagingModel paging = new PagingModel();
paging.PageSize = dtm.PageSize;
paging.PageCurrent = dtm.PageIndex;
paging.Where = string.IsNullOrWhiteSpace(dtm.FieldCondition) ? "1=1" : dtm.FieldCondition;
IList <Hashtable> knowledgeList = ServiceProvider.KnowledgesService.GetAllKnowledgesListForPaging(paging);
//系统参数
IList <Global.Common.Models.ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll();
ParamModel pState = paramList.SingleOrDefault(p => p.ParamCode.Equals(UtilConstants.SysParamType.KnowledgeState));
ParamModel pType = paramList.SingleOrDefault(p => p.ParamCode.Equals(UtilConstants.SysParamType.KnowledgeType));
//Json数据格式组装
dtm.iTotalRecords = paging.RecordCount;
dtm.iTotalDisplayRecords = dtm.iTotalRecords;
dtm.aaData = new List <List <string> >();
StringBuilder operate = new StringBuilder();
foreach (var item in knowledgeList)
{
dtm.aaData.Add(new List <string>());
string knowledgeId = UtilsHelper.Encrypt(item["KnowledgeId"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("<input type='checkbox' name='chk' value='{0}'>", knowledgeId));
operate.AppendFormat("<div knowledgeId='{0}'>", knowledgeId);
if (LoginHelper.LoginUserAuthorize.Contains("/CustKnowledge/Edit".ToLower()))
{
operate.AppendFormat("<a href='#' onclick='fnEdit(this)'>编辑</a> | ");
}
if (LoginHelper.LoginUserAuthorize.Contains("/CustKnowledge/Details".ToLower()))
{
operate.AppendFormat("<a href='#' onclick='fnDetail(this)'>查看</a>");
}
operate.Append("</div>");
dtm.aaData[dtm.aaData.Count - 1].Add(operate.ToString());
operate.Clear();
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", item["Title"]));
ParamItemModel itemModel = pType.itemsList.SingleOrDefault(p => p.ParamItemValue.Equals(item["KType"].ToString()));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", itemModel == null ? "" : itemModel.ParamItemName));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", item["Abstract"]));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", item["Creator"]));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0:yyyy-MM-dd}", item["CreatDate"]));
}
JsonResult jr = Json(new
{
sEcho = dtm.sEcho,
iTotalRecords = dtm.iTotalRecords,
iTotalDisplayRecords = dtm.iTotalDisplayRecords,
aaData = dtm.aaData
}, JsonRequestBehavior.AllowGet);
return(jr);
}
/// <summary>
/// 检索条件
/// </summary>
/// <returns></returns>
private string GetCraftSearchCondition(DataTableUtils.DataTableModel dtm)
{
string where = "1=1";
if (!string.IsNullOrWhiteSpace(dtm.FieldCondition))
{
where = dtm.FieldCondition;
}
return(where);
}
public JsonResult GetOperateLogListJsonData()
{
//提取DataTable参数
DataTableUtils.DataTableModel dtm = DataTableUtils.GetJquerydataTableParams();
//构造输入参数
PagingModel paging = new PagingModel();
paging.PageSize = dtm.PageSize;
paging.PageCurrent = dtm.PageIndex;
paging.FieldShow = "OperateType,Operator,OperateDate,OperateIP,OperateContent,TargetPK,TargetType";
paging.Where = "1=1";
if (!string.IsNullOrWhiteSpace(dtm.FieldCondition))
{
paging.Where = dtm.FieldCondition;
}
//paging.Where = string.Format(" 1 = 1 and {0}", dtm.FieldCondition);
if (!string.IsNullOrEmpty(dtm.KeyWord))
{
paging.Where = string.Format("{0} and (Operator like '%{1}%' or OperateContent like '%{1}%' or TargetType like '%{1}%')", paging.Where, dtm.KeyWord);
}
IList <ParamModel> paramAllList = Global.Business.ServiceProvider.ParamService.GetAll();
ParamModel operateTypeParam = paramAllList.SingleOrDefault(S => S.ParamCode == UtilConstants.SysParamType.OperateType);
ParamItemModel item = null;
//数据库查询数据
IList <Hashtable> operateList = ServiceProvider.OperateLogService.GetAllOperateLogListForPaging(paging);
//Json数据格式组装
dtm.iTotalRecords = paging.RecordCount;
dtm.iTotalDisplayRecords = dtm.iTotalRecords;
dtm.aaData = new List <List <string> >();
StringBuilder sb = new StringBuilder();
string orderId = string.Empty;
foreach (Hashtable row in operateList)
{
dtm.aaData.Add(new List <string>());
item = operateTypeParam.itemsList.SingleOrDefault(p => p.ParamItemValue.Equals(row["OperateType"].ToString()));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", item == null?"":item.ParamItemName));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", row["Operator"]));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", row["OperateIP"]));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", row["OperateContent"]));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", row["TargetPK"]));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", (UtilConstants.TargetType)Convert.ToInt32(row["TargetType"])));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0:yyyy-MM-dd HH:mm:ss}", row["OperateDate"]));
}
JsonResult jr = Json(new
{
sEcho = dtm.sEcho,
iTotalRecords = dtm.iTotalRecords,
iTotalDisplayRecords = dtm.iTotalDisplayRecords,
aaData = dtm.aaData
}, JsonRequestBehavior.AllowGet);
return(jr);
}
/// <summary>
/// 检索条件
/// </summary>
/// <returns></returns>
private string GetInstrumentSearchCondition()
{
DataTableUtils.DataTableModel dtm = DataTableUtils.GetJquerydataTableParams();
string where = "1=1";
if (!string.IsNullOrWhiteSpace(dtm.FieldCondition))
{
where = dtm.FieldCondition;
}
return(where);
}
public ActionResult GetServerJsonData(int orgId)
{
//提取DataTable参数
DataTableUtils.DataTableModel dtm = DataTableUtils.GetJquerydataTableParams();
string code = ServiceProvider.OrgService.GetCodeById(orgId);
//构造输入参数
PagingModel paging = new PagingModel();
paging.PageSize = dtm.PageSize;
paging.PageCurrent = dtm.PageIndex;
paging.Where = "1=1";
if (!string.IsNullOrWhiteSpace(dtm.FieldCondition))
{
paging.Where = dtm.FieldCondition;
}
paging.Where = string.Format(" {0} and BelongDepart like '{1}%'", paging.Where, code);
if (!string.IsNullOrEmpty(dtm.KeyWord))
{
paging.Where = string.Format("{0} and (UserName like '{1}%' or LoginName like '{1}%')", paging.Where, dtm.KeyWord);
}
//数据库查询数据
IList <Hashtable> userList = ServiceProvider.UserService.GetListForPaging(paging);
//Json数据格式组装
dtm.iTotalRecords = paging.RecordCount;
dtm.iTotalDisplayRecords = dtm.iTotalRecords;
dtm.aaData = new List <List <string> >();
foreach (var row in userList)
{
string userId = UtilsHelper.Encrypt(row["UserId"].ToString());
dtm.aaData.Add(new List <string>());
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("<a href='/Employee/PersonInfo?userId={0}' target=\"_blank\">{1}</a>", userId, row["UserName"]));
dtm.aaData[dtm.aaData.Count - 1].Add(row["Sex"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(row["LoginName"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(row["OrgName"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(row["Duty"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(row["IsEnabled"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(row["EmployeeState"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("<a href='#' onclick=\"fnNewWindow({0});return false;\">角色设置</a> <a href='#' onclick=\"fnConfirmWithoutF5('确定重置账户【{1}】密码？','/SysManage/User/ResetPassword?userId={0}');return false;\">重置密码</a> <a href='#' onclick=\"fnConfirmWithF5('确定要禁用账户：{1}','/SysManage/User/DisableAccout?userId={0}');return false;\">禁用</a> <a href='#' onclick=\"fnConfirmWithF5('确定要启用账户：{1}','/SysManage/User/EnableAccout?userId={0}');return false;\">启用</a> <a href='#' onclick=\"fnConfirmWithF5('确定要删除用户：{1}','/SysManage/User/DeleteUser?userId={0}');return false;\">删除</a>", row["UserId"], row["UserName"]));
}
JsonResult jr = Json(new
{
sEcho = dtm.sEcho,
iTotalRecords = dtm.iTotalRecords,
iTotalDisplayRecords = dtm.iTotalDisplayRecords,
aaData = dtm.aaData
}, JsonRequestBehavior.AllowGet);
return(jr);
}
/// <summary>
/// 检索条件
/// </summary>
/// <returns></returns>
private string GetCertificationSearchCondition(DataTableUtils.DataTableModel dtm)
{
string where = "1=1";
if (!string.IsNullOrWhiteSpace(dtm.FieldCondition))
{
where = dtm.FieldCondition;
}
string instrumentParam = Request["InstrumentParam"];
if (!string.IsNullOrEmpty(instrumentParam))
{
where = string.Format("{0} and {1}", where, instrumentParam);
}
return(where);
}
/// <summary>
/// 仪器查询、仪器维护
/// </summary>
/// <param name="type">Search:仪器查询，Maintain：仪器维护</param>
/// <returns></returns>
public JsonResult GetAllCraftJsonData(string type)
{
//查询标准器具
DataTableUtils.DataTableModel dtm = DataTableUtils.GetJquerydataTableParams();
PagingModel paging = new PagingModel();
paging.PageSize = dtm.PageSize;
paging.PageCurrent = dtm.PageIndex;
paging.FieldShow = @"CraftId,CraftCode,CraftName,InstrumentNo,UsePlace,CreateUser,CreateDate";
paging.Where = GetCraftSearchCondition(dtm);
//IList<CraftModel> craftList = ServiceProvider.CraftService.GetAll();
IList <Hashtable> craftList = ServiceProvider.CraftService.GetAllCraftListForPaging(paging);
//Json数据格式组装
dtm.iTotalRecords = paging.RecordCount;
dtm.iTotalDisplayRecords = dtm.iTotalRecords;
StringBuilder sbData = new StringBuilder();
dtm.aaData = new List <List <string> >();
foreach (var item in craftList)
{
dtm.aaData.Add(new List <string>());
sbData.Clear();
sbData.AppendFormat("<div craftId='{0}' craftName='{1}'>", item["CraftId"].ToString(), item["CraftName"]);
//if (LoginHelper.LoginUserAuthorize.ContainsKey("/Instrument/InstrumentDetail".ToLower()))
//{
// //详细
// sbData.Append("<a href='#' onclick='fnInstrumentDetail(this);'>详细</a> ");
//}
if (type.Equals("CraftList"))
{
if (LoginHelper.LoginUserAuthorize.ContainsKey("/Instrument/Edit".ToLower()))
{
//修改
sbData.Append("<a href='#' onclick='fnEditCraft(" + item["CraftId"] + ");'>修改</a> ");
}
if (LoginHelper.LoginUserAuthorize.ContainsKey("/Instrument/Delete".ToLower()))
{
//删除
sbData.Append("<a href='#' onclick='fnDeleteCraft(" + item["CraftId"] + ");'>删除</a> ");
}
}
sbData.Append("</div>");
dtm.aaData[dtm.aaData.Count - 1].Add(sbData.ToString());
//dtm.aaData[dtm.aaData.Count - 1].Add(item.CraftId.ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(item["CraftCode"] == null ? null : item["CraftCode"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(item["CraftName"] == null ? null : item["CraftName"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(item["InstrumentNo"] == null ? null : item["InstrumentNo"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(item["UsePlace"] == null ? null : item["UsePlace"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(item["CreateUser"] == null ? null : item["CreateUser"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0:yyyy-MM-dd}", item["CreateDate"]));
}
JsonResult jr = Json(new
{
sEcho = dtm.sEcho,
iTotalRecords = dtm.iTotalRecords,
iTotalDisplayRecords = dtm.iTotalDisplayRecords,
aaData = dtm.aaData,
}, JsonRequestBehavior.AllowGet);
return(jr);
}
public JsonResult GetAllCertificationJsonData()
{
DataTableUtils.DataTableModel dtm = DataTableUtils.GetJquerydataTableParams();
//string where = GetCertificationSearchCondition(dtm);
PagingModel paging = new PagingModel();
paging.PageSize = dtm.PageSize;
paging.PageCurrent = dtm.PageIndex;
dtm.iTotalDisplayRecords = dtm.iTotalRecords;
paging.FieldShow = @"LogId,InstrumentId,CertificationCode,FileId,CheckDate,EndDate,SendInstrumentDate,CheckResult,ErrorValue,RecordState,IsUseding,CertMoney,CreateDate,CreateUser";
paging.Where = string.IsNullOrWhiteSpace(dtm.FieldCondition) ? dtm.FieldCondition = "1=1" : dtm.FieldCondition;
//是否超期
string overTime = Request["searchIsOverTime"];
if (!string.IsNullOrEmpty(overTime))
{
if (overTime == "0")
{
paging.Where = string.Format("{0} and {1}", paging.Where, "GetDate()<=EndDate");//未超期
}
else
{
paging.Where = string.Format("{0} and {1}", paging.Where, "GetDate()>EndDate");//已超期
}
}
//是否上传报告
string UpdateReport = Request["searchIsUpdateReport"];
if (!string.IsNullOrEmpty(UpdateReport))
{
paging.Where = string.Format("{0} and {1}", paging.Where, UpdateReport == "0" ? "(FileId IS null or FileId=0)" : "FileId>0");
}
//添加委托单查询条件.
string orderParam = Request["InstrumentParam"];
if (!string.IsNullOrWhiteSpace(orderParam))
{
orderParam = string.Format(" and {0}", orderParam);
}
paging.Where = string.Format("{0} and (InstrumentId In (Select InstrumentId From Instrument_BaseInfo Where {2}{1}))", paging.Where, orderParam, GetManageCondition("InstrumentForm=0 "));
DateTime dueEndDate;
bool isOverTime = false;
IList <Hashtable> instrumentCertificationList = ServiceProvider.InstrumentCertificationService.GetInstrumentCertificationListForPaging(paging);
IList <int> instrumentIds = instrumentCertificationList.Select(s => Convert.ToInt32(s["InstrumentId"])).Distinct().ToList();
IList <InstrumentModel> instrumentList = ServiceProvider.InstrumentService.GetByIds(instrumentIds);
dtm.iTotalRecords = paging.RecordCount;
dtm.iTotalDisplayRecords = dtm.iTotalRecords;
////系统参数
IList <ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll();
Global.Common.Models.OrgModel belongDeptModel = new Global.Common.Models.OrgModel();
Global.Common.Models.ParamItemModel mInstrumentCate = null;
IList <Global.Common.Models.ParamItemModel> paramItemList = paramList.SingleOrDefault(t => t.ParamCode == Instrument.Common.Constants.SysParamType.InstrumentCate).itemsList;
///周检状态
IList <ParamItemModel> CertificationState = paramList.SingleOrDefault(t => t.ParamCode == Instrument.Common.Constants.SysParamType.InstrumentCertificationState).itemsList;
ParamItemModel mParamItem = new ParamItemModel();
StringBuilder sbData = new StringBuilder();
dtm.aaData = new List <List <string> >();
foreach (var item in instrumentCertificationList)
{
InstrumentModel instrumentModel = instrumentList.SingleOrDefault(p => p.InstrumentId == Convert.ToInt32(item["InstrumentId"]));
if (instrumentModel == null)
{
instrumentModel = new InstrumentModel();
}
if (item["EndDate"] == null)
{
isOverTime = true;
}
else
{
dueEndDate = Convert.ToDateTime(string.Format("{0:d}", item["EndDate"]));
//是否过期
isOverTime = DateTime.Now.CompareTo(dueEndDate) > 0 ? true : false;
}
dtm.aaData.Add(new List <string>());
sbData.Clear();
sbData.AppendFormat("<a href='#' onclick='fnDetails({0})'>详细</a> ", item["LogId"]);
if (item["FileId"] != null)
{
sbData.Append("<a href='#' onclick='fnDownFile(\"" + UtilsHelper.Encrypt(item["FileId"].ToString()) + "\");'>下 载</a> ");
//sbData.Append(string.Format("<a href='/Certification/ReadCert?Id={1}' target='_blank' >{0}</a>","浏 览", UtilsHelper.Encrypt(item["FileId"].ToString())));
}
dtm.aaData[dtm.aaData.Count - 1].Add(sbData.ToString());
mParamItem = CertificationState.SingleOrDefault(c => c.ParamItemValue == string.Format("{0}", item["RecordState"]));
dtm.aaData[dtm.aaData.Count - 1].Add(mParamItem == null ? "" : mParamItem.ParamItemName); //状态
dtm.aaData[dtm.aaData.Count - 1].Add(isOverTime ? "已超期" : "未超期"); //证书超期
dtm.aaData[dtm.aaData.Count - 1].Add(item["FileId"] == null || item["FileId"].ToString() == "" ? "否" : "是"); //是否上传证书
dtm.aaData[dtm.aaData.Count - 1].Add(item["EndDate"] == null ? null : string.Format("{0:yyyy-MM-dd}", item["EndDate"]));
dtm.aaData[dtm.aaData.Count - 1].Add(item["CertificationCode"] == null ? "" : item["CertificationCode"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0:F2}", item["CertMoney"]));
dtm.aaData[dtm.aaData.Count - 1].Add(instrumentModel.InstrumentName);
mInstrumentCate = paramItemList.SingleOrDefault(t => t.ParamItemValue == Convert.ToString(instrumentModel.InstrumentCate));
dtm.aaData[dtm.aaData.Count - 1].Add(mInstrumentCate == null ? "" : mInstrumentCate.ParamItemName);
dtm.aaData[dtm.aaData.Count - 1].Add(instrumentModel.ManageNo);
dtm.aaData[dtm.aaData.Count - 1].Add(instrumentModel.Specification);
dtm.aaData[dtm.aaData.Count - 1].Add(instrumentModel.SerialNo);
dtm.aaData[dtm.aaData.Count - 1].Add(item["CheckDate"] == null ? null : string.Format("{0:yyyy-MM-dd}", item["CheckDate"]));
dtm.aaData[dtm.aaData.Count - 1].Add(item["CheckResult"] == null ? null : item["CheckResult"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(item["ErrorValue"] == null ? null : item["ErrorValue"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(item["CreateDate"] == null ? null : string.Format("{0:yyyy-MM-dd}", item["CreateDate"]));
dtm.aaData[dtm.aaData.Count - 1].Add(item["CreateUser"] == null ? null : item["CreateUser"].ToString());
}
JsonResult jr = Json(new
{
sEcho = dtm.sEcho,
iTotalRecords = dtm.iTotalRecords,
iTotalDisplayRecords = dtm.iTotalDisplayRecords,
aaData = dtm.aaData,
}, JsonRequestBehavior.AllowGet);
return(jr);
}
public ActionResult Export()
{
DataTable dtData = new DataTable();
DataTableUtils.DataTableModel dtm = DataTableUtils.GetJquerydataTableParams();
string where = GetCertificationSearchCondition(dtm);
string Where = string.IsNullOrWhiteSpace(dtm.FieldCondition) ? dtm.FieldCondition = "1=1" : dtm.FieldCondition;
//是否超期
string overTime = Request["searchIsOverTime"];
if (!string.IsNullOrEmpty(overTime))
{
if (overTime == "0")
{
Where = string.Format("{0} and {1}", Where, "GetDate()<=EndDate");//未超期
}
else
{
Where = string.Format("{0} and {1}", Where, "GetDate()>EndDate");//已超期
}
}
//添加委托单查询条件.
string orderParam = Request["InstrumentParam"];
if (!string.IsNullOrWhiteSpace(orderParam))
{
orderParam = string.Format(" and {0}", orderParam);
}
if (!string.IsNullOrWhiteSpace(orderParam))
{
Where = string.Format("{0} and (InstrumentId In (Select InstrumentId From Instrument_BaseInfo Where {2}{1}))", Where, orderParam, GetManageCondition("InstrumentForm=0 "));
}
IList <InstrumentCertificationModel> instrumentCertificationList = ServiceProvider.InstrumentCertificationService.GetByWhere(Where);
IList <int> instrumentIds = instrumentCertificationList.Select(s => Convert.ToInt32(s.InstrumentId)).Distinct().ToList();
IList <InstrumentModel> instrumentList = ServiceProvider.InstrumentService.GetByIds(instrumentIds);
if (0 == instrumentCertificationList.Count)
{
Response.Write("没有要导出的内容。");
Response.End();
return(Content(""));
}
dtData.Columns.Add("RecordState", typeof(string)); //周检状态
dtData.Columns.Add("IsOverTime", typeof(string)); //是否过期
dtData.Columns.Add("CertificateNo", typeof(string)); //证书编号
dtData.Columns.Add("CertMoney", typeof(string)); //费用
dtData.Columns.Add("InstrumentName", typeof(string)); //仪器名称
dtData.Columns.Add("ManageNo", typeof(string)); //管理编号
dtData.Columns.Add("Specification", typeof(string)); //型号规格
dtData.Columns.Add("SerialNo", typeof(string)); //出厂编号
dtData.Columns.Add("CheckDate", typeof(string)); //检验日期
dtData.Columns.Add("EndDate", typeof(string)); //有效日期
dtData.Columns.Add("CheckResult", typeof(string)); //检测结果
dtData.Columns.Add("ErrorValue", typeof(string)); //误 差
dtData.Columns.Add("CreateDate", typeof(string)); //创建日期
dtData.Columns.Add("CreateUser", typeof(string)); //创建人
DateTime dueEndDate;
bool isOverTime = false;
////系统参数
IList <ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll();
///周检状态
IList <ParamItemModel> CertificationState = paramList.SingleOrDefault(t => t.ParamCode == Instrument.Common.Constants.SysParamType.InstrumentCertificationState).itemsList;
ParamItemModel mParamItem = new ParamItemModel();
foreach (var item in instrumentCertificationList)
{
DataRow drData = dtData.NewRow();
mParamItem = CertificationState.SingleOrDefault(c => c.ParamItemValue == string.Format("{0}", item.RecordState));
drData["RecordState"] = mParamItem == null ? "" : mParamItem.ParamItemName; //周检状态
InstrumentModel instrumentModel = instrumentList.SingleOrDefault(p => p.InstrumentId == Convert.ToInt32(item.InstrumentId));
if (instrumentModel == null)
{
instrumentModel = new InstrumentModel();
}
if (instrumentModel.DueEndDate == null)
{
dueEndDate = DateTime.MinValue;
}
else
{
dueEndDate = Convert.ToDateTime(string.Format("{0:d}", instrumentModel.DueEndDate));
}
if (item.EndDate == null)
{
isOverTime = true;
}
else
{
dueEndDate = Convert.ToDateTime(string.Format("{0:d}", item.EndDate));
//是否过期
isOverTime = DateTime.Now.CompareTo(dueEndDate) > 0 ? true : false;
}
//isOverTime = DateTime.Now.CompareTo(dueEndDate) > 0 ? true : false;
drData["IsOverTime"] = isOverTime ? "已超期" : "未超期"; //是否过期
drData["CertificateNo"] = item.CertificationCode == null ? null : item.CertificationCode.ToString(); //证书编号
drData["CertMoney"] = string.Format("{0:F2}", item.CertMoney);
drData["InstrumentName"] = instrumentModel.InstrumentName; //仪器名称
drData["ManageNo"] = instrumentModel.ManageNo; //管理编号
drData["Specification"] = instrumentModel.Specification; //型号规格
drData["SerialNo"] = instrumentModel.SerialNo; //出厂编号
drData["CheckDate"] = item.CheckDate == null ? null : string.Format("{0:yyyy-MM-dd}", item.CheckDate); //检验日期
drData["EndDate"] = item.EndDate == null ? null : string.Format("{0:yyyy-MM-dd}", item.EndDate); //有效日期
drData["CheckResult"] = item.CheckResult; //检测结果
drData["ErrorValue"] = item.ErrorValue; //误 差
drData["CreateDate"] = item.CreateDate == null ? null : string.Format("{0:yyyy-MM-dd}", item.CreateDate); //创建日期
drData["CreateUser"] = item.CreateUser; //创建人
dtData.Rows.Add(drData);
}
//导出
List <string> headerList = new List <string>(new string[] {
"周检状态", "是否过期", "证书编号", "费用", "仪器名称", "管理编号", "仪器型号", "出厂编号", "检验日期", "有效日期", "检测结果", "误 差", "创建日期", "创建人"
});
string result = ToolsLib.FileService.ExcelFile.WriteDataToExcel(headerList, dtData, "证书", ToolsLib.LibConst.ExcelVersion.Excel2007);
ToolsLib.FileService.WebServer.DownLoadFile(result, string.Format("{0:yyyyMMddHHmmss}证书{1}", DateTime.Now, System.IO.Path.GetExtension(result)), true);
return(Content("OK"));
}
public JsonResult GetAllInstrumentJsonData(string documentId)
{
//查询标准器具
DataTableUtils.DataTableModel dtm = DataTableUtils.GetJquerydataTableParams();
PagingModel paging = new PagingModel();
paging.PageSize = dtm.PageSize;
paging.PageCurrent = dtm.PageIndex;
paging.FieldShow = @"InstrumentId,InstrumentName,ManageNo,Specification,InstrumentType,Manufacturer,SerialNo,CreateDate,DueStartDate,DueEndDate,BelongDepart";
paging.Where = GetInstrumentSearchCondition();
IList <ParamModel> list = Global.Business.ServiceProvider.ParamService.GetAll();
ParamModel paramModel = null;
IList <OrgModel> orgList = Global.Business.ServiceProvider.OrgService.GetAll();
OrgModel org = new OrgModel();
//IList<CraftModel> craftList = ServiceProvider.CraftService.GetAll();
IList <Hashtable> instrumentList = ServiceProvider.InstrumentService.GetAllInstrumentListForPaging(paging);
//Json数据格式组装
dtm.iTotalRecords = paging.RecordCount;
dtm.iTotalDisplayRecords = dtm.iTotalRecords;
//StringBuilder sbData = new StringBuilder();
dtm.aaData = new List <List <string> >();
foreach (var item in instrumentList)
{
paramModel = list.SingleOrDefault(p => p.ParamCode == Constants.SysParamType.InstrumentType);
org = orgList.SingleOrDefault(o => o.OrgCode == (item["BelongDepart"] == null ? "" : item["BelongDepart"].ToString()));
dtm.aaData.Add(new List <string>());
//sbData.Clear();
//sbData.AppendFormat("<div documentId='{0}' instrumentId='{1}'>", documentId, item["InstrumentId"].ToString());
//if (LoginHelper.LoginUserAuthorize.ContainsKey("/Document/InstrumentList".ToLower()))
//{
// //修改
// sbData.Append("<a href='#' onclick='fnChoose(" + documentId + "," + item["InstrumentId"] + ");'>关 联</a> ");
//}
//sbData.Append("</div>");
if (LoginHelper.LoginUserAuthorize.ContainsKey("/Instrument/DeleteInstruments".ToLower()))
{
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("<input type='checkbox' name='chk' value={0} />", item["InstrumentId"]));
}
//dtm.aaData[dtm.aaData.Count - 1].Add(sbData.ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(item["InstrumentName"] == null ? "" : item["InstrumentName"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(item["ManageNo"] == null ? "" : item["ManageNo"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(item["Specification"] == null ? "" : item["Specification"].ToString());
//设备分类
dtm.aaData[dtm.aaData.Count - 1].Add(paramModel.itemsList.SingleOrDefault(p => p.ParamItemValue == item["InstrumentType"].ToString()).ParamItemName);
dtm.aaData[dtm.aaData.Count - 1].Add(item["Manufacturer"] == null ? "" : item["Manufacturer"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(item["SerialNo"] == null ? "" : item["SerialNo"].ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0:yyyy-MM-dd}", item["CreateDate"] == null ? "" : item["CreateDate"].ToString()));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0:yyyy-MM-dd}", item["DueStartDate"] == null ? "" : item["DueStartDate"].ToString()));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0:yyyy-MM-dd}", item["DueEndDate"] == null ? "" : item["DueEndDate"].ToString()));
//所属部门
dtm.aaData[dtm.aaData.Count - 1].Add(org == null ? null : org.OrgName);
}
JsonResult jr = Json(new
{
sEcho = dtm.sEcho,
iTotalRecords = dtm.iTotalRecords,
iTotalDisplayRecords = dtm.iTotalDisplayRecords,
aaData = dtm.aaData,
}, JsonRequestBehavior.AllowGet);
return(jr);
}
public JsonResult GetAllInstrumentJsonData()
{
//查询标准器具
DataTableUtils.DataTableModel dtm = DataTableUtils.GetJquerydataTableParams();
PagingModel paging = new PagingModel();
paging.PageSize = dtm.PageSize;
paging.PageCurrent = dtm.PageIndex;
paging.FieldShow = @"InstrumentId,RecordState,InstrumentName,ManageNo,CertificateNo,Specification,InstrumentCate,Manufacturer,SerialNo,DueStartDate,DueEndDate,LeaderName,BelongDepart,StorePalce,CreateDate,CreateUser";
paging.Where = GetSearchCondition(dtm);
IList <Hashtable> instrumentList = ServiceProvider.InstrumentService.GetAllInstrumentListForPaging(paging);
//系统参数
IList <ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll();
IList <OrgModel> orgList = Global.Business.ServiceProvider.OrgService.GetAll();
OrgModel belongDeptModel = new OrgModel();
ParamItemModel mInstrumentCate = null;
//分类
ParamModel InstrumentCate = paramList.SingleOrDefault(t => t.ParamCode == Instrument.Common.Constants.SysParamType.InstrumentCate); //设备分类
IList <ParamItemModel> paramItemList = InstrumentCate.itemsList;
//Json数据格式组装
dtm.iTotalRecords = paging.RecordCount;
dtm.iTotalDisplayRecords = dtm.iTotalRecords;
dtm.aaData = new List <List <string> >();
StringBuilder sbOperate = new StringBuilder();
foreach (var item in instrumentList)
{
dtm.aaData.Add(new List <string>());
sbOperate.Clear(); //操作
sbOperate.AppendFormat("<div instrumentId='{0}' instrumentName='{1}'>", UtilsHelper.Encrypt(item["InstrumentId"].ToString()), item["InstrumentName"]);
if (LoginHelper.LoginUserAuthorize.ContainsKey("/InstrumentFlow/FlowDetails".ToLower()))
{
//详细
sbOperate.Append("<a href='#' onclick='fnInstrumentFlowDetail(this);'>流转明细</a> ");
}
sbOperate.Append("</div>");
dtm.aaData[dtm.aaData.Count - 1].Add(sbOperate.ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", item["InstrumentName"])); //仪器名称
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", item["Specification"])); //型号
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", item["SerialNo"])); //出厂编号
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", item["ManageNo"])); //管理编号
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", item["CertificateNo"])); //证书编号
mInstrumentCate = paramItemList.SingleOrDefault(t => t.ParamItemValue == Convert.ToString(item["InstrumentCate"]));
dtm.aaData[dtm.aaData.Count - 1].Add(mInstrumentCate == null ? "" : mInstrumentCate.ParamItemName);
//分公司
belongDeptModel = orgList.SingleOrDefault(o => o.OrgCode == string.Format("{0}", item["BelongDepart"]));
dtm.aaData[dtm.aaData.Count - 1].Add(belongDeptModel == null ? "" : belongDeptModel.OrgName);
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0:d}", item["DueStartDate"]));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", item["LeaderName"]));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0:d}", item["CreateUser"]));
}
JsonResult jr = Json(new
{
sEcho = dtm.sEcho,
iTotalRecords = dtm.iTotalRecords,
iTotalDisplayRecords = dtm.iTotalDisplayRecords,
aaData = dtm.aaData
}, JsonRequestBehavior.AllowGet);
return(jr);
}
public JsonResult GetAllContactJsonData()
{
//查询标准器具
DataTableUtils.DataTableModel dtm = DataTableUtils.GetJquerydataTableParams();
PagingModel paging = new PagingModel();
paging.PageSize = dtm.PageSize;
paging.PageCurrent = dtm.PageIndex;
paging.FieldShow = @"ContactId,CompanyName,CaseType,Abstract,State,ContactContent,FeedbackContent,FeedbackDate,Creator,CreatId,CreatDate,ItemCode";
paging.Where = string.IsNullOrWhiteSpace(dtm.FieldCondition) ? dtm.FieldCondition = "1=1" : dtm.FieldCondition;
IList <Hashtable> contractList = Instrument.Business.ServiceProvider.ContactService.GetAllContactListForPaging(paging);
////系统参数
IList <ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll();
ParamModel pCaseType = paramList.SingleOrDefault(p => p.ParamCode.Equals(Common.Constants.SysParamType.ContactCaseType));
if (pCaseType == null)
{
pCaseType = new ParamModel();
}
ParamItemModel itemCaseType = null;
//Json数据格式组装
dtm.iTotalRecords = paging.RecordCount;
dtm.iTotalDisplayRecords = dtm.iTotalRecords;
dtm.aaData = new List <List <string> >();
StringBuilder sbOperate = new StringBuilder();
foreach (var item in contractList)
{
dtm.aaData.Add(new List <string>());
sbOperate.Clear(); //操作
sbOperate.AppendFormat("<div contactId='{0}' >", UtilsHelper.Encrypt(item["ContactId"].ToString()));
int state = Convert.ToInt32(item["State"]);
if (state.Equals(Common.Constants.ContactState.草稿.GetHashCode()))
{
if (LoginHelper.LoginUserAuthorize.ContainsKey("新增联络单-修改"))
{
sbOperate.Append("<a href='#' onclick='fnEditContact(this);'>编辑</a> ");
}
if (LoginHelper.LoginUserAuthorize.ContainsKey("/Contact/Delete".ToLower()))
{
sbOperate.Append("<a href='#' onclick='fnDeleteContact(this);'>删除</a> ");
}
if (LoginHelper.LoginUserAuthorize.ContainsKey("/Contact/Send".ToLower()))
{
sbOperate.Append("<a href='#' onclick='fnSendContact(this);'>提交</a> ");
}
}
if (!state.Equals(Common.Constants.ContactState.草稿.GetHashCode()))
{
if (LoginHelper.LoginUserAuthorize.ContainsKey("/Contact/Detail".ToLower()))
{
sbOperate.Append("<a href='#' onclick='fnViewContact(this);'>查看</a> ");
}
}
if (state.Equals(Common.Constants.ContactState.已提交.GetHashCode()))
{
if (LoginHelper.LoginUserAuthorize.ContainsKey("/Contact/SynContact".ToLower()))
{
sbOperate.Append("<a href='#' onclick='fnSynContact(this);'>更新同步</a> ");
}
}
if (state.Equals(Common.Constants.ContactState.已反馈.GetHashCode()))
{
if (LoginHelper.LoginUserAuthorize.ContainsKey("/Contact/Solve".ToLower()))
{
sbOperate.Append("<a href='#' onclick='fnSolveContact(this);'>解决</a> ");
}
}
sbOperate.Append("</div>");
dtm.aaData[dtm.aaData.Count - 1].Add(sbOperate.ToString());
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", item["CompanyName"]));
//事项分类
itemCaseType = pCaseType.itemsList.SingleOrDefault(p => p.ParamItemValue.Equals(item["CaseType"].ToString()));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", itemCaseType == null ? "" : itemCaseType.ParamItemName));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", item["Abstract"]));
dtm.aaData[dtm.aaData.Count - 1].Add(((Constants.ContactState)Convert.ToInt32(item["State"])).ToString()); //状态
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0:yyyy-MM-dd}", item["FeedbackDate"]));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0}", item["Creator"]));
dtm.aaData[dtm.aaData.Count - 1].Add(string.Format("{0:yyyy-MM-dd}", item["CreatDate"]));
}
JsonResult jr = Json(new
{
sEcho = dtm.sEcho,
iTotalRecords = dtm.iTotalRecords,
iTotalDisplayRecords = dtm.iTotalDisplayRecords,
aaData = dtm.aaData
}, JsonRequestBehavior.AllowGet);
return(jr);
}
