public ActionResult DocumentOwnInstrumentList(int documentId)
{
IList <ParamModel> list = Global.Business.ServiceProvider.ParamService.GetAll();
ParamModel paramModel = null;
string InstrumentType = null;
IList <OrgModel> orgList = Global.Business.ServiceProvider.OrgService.GetAll();
OrgModel org = new OrgModel();
string where = "InstrumentId in (Select InstrumentId From DocumentOwnInstrument Where SysDocumentId='" + documentId + "')";
IList <Instrument.Common.Models.InstrumentModel> instrumentList = ServiceProvider.InstrumentService.GetAllInstrumentListByWhere(where);
StringBuilder sb = new StringBuilder();
sb.Append("[");
foreach (var instrument in instrumentList)
{
paramModel = list.SingleOrDefault(p => p.ParamCode == Constants.SysParamType.InstrumentType);
InstrumentType = paramModel.itemsList.SingleOrDefault(p => p.ParamItemValue == instrument.InstrumentType.ToString()).ParamItemName;
org = orgList.SingleOrDefault(o => o.OrgCode == instrument.BelongDepart);
sb.AppendFormat("[\"<a href='#' onclick='fnDelete({0},{1});return false;'>删 除</a> "
+ "\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\",\"{8}\",\"{9}\",\"{10}\",\"{11}\""
+ "],", documentId, instrument.InstrumentId, instrument.InstrumentName, instrument.ManageNo, instrument.Specification, InstrumentType, instrument.Manufacturer,
instrument.SerialNo, instrument.CreateDate, instrument.DueStartDate, instrument.DueEndDate, org == null ? null : org.OrgName);
}
if (instrumentList.Count > 0)
{
sb.Remove(sb.Length - 1, 1);
}
sb.Append("]");
ViewBag.instrumentData = sb.ToString();
ViewBag.DocumentId = documentId.ToString();
return(View());
}
public override string QueryResult()
{
JsonModel model = new JsonModel();
ParamModel p = new ParamModel();
DataTable table = null;
DataTable tblFile = null;
ParamModel param = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
this.clientid = param.cid;
TF.RunSafty.BLL.TAB_FileGroup bllFileGroup = new TF.RunSafty.BLL.TAB_FileGroup();
TF.RunSafty.BLL.TAB_ReadDoc bllFile = new TF.RunSafty.BLL.TAB_ReadDoc();
try
{
table = bllFileGroup.GetAllList().Tables[0];
tblFile = bllFile.GetAllListWithFileType(clientid).Tables[0];
model.result = "0";
model.returnStr = "返回成功";
model.TypeList = table;
model.FileList = tblFile;
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string result = Newtonsoft.Json.JsonConvert.SerializeObject(model, timeConverter).Replace(":null", ":\"\"");
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <param name="dir"></param>
private static void Execute(ParamModel model, string dir)
{
try
{
var dirs = new List <string>();
var files = new List <string>();
DirectoryHelper.GetDirectoryFiles(dir, ref dirs, ref files);
foreach (var file in files)
{
var fi = new FileInfo(file);
var dt = fi.CreationTime;
var tp = (DateTime.Now - dt);
if (tp <= model.DeleteTime)
{
continue;
}
if (!DirectoryHelper.DeleteFile(file))
{
model.Log?.Invoke(new Exception($"文件删除失败：{file}"));
}
}
}
catch (Exception ex)
{
model.Log?.Invoke(ex);
}
}
public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
try
{
ParamModel paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
TF.RunSafty.BLL.Workshop bllPlace = new TF.RunSafty.BLL.Workshop();
List <TF.RunSafty.Model.WorkShop> placeList = bllPlace.GetCheJianList("");
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
ArrayName an = new ArrayName();
jsonModel.data = an;
an.ArrayWorkShop = bllPlace.GetPlaceList(placeList);
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
return(Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel, timeConverter));
}
public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
try
{
ParamModel paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
TF.RunSafty.Model.TAB_Base_TrainNo train = new TF.RunSafty.Model.TAB_Base_TrainNo();
TF.RunSafty.BLL.TAB_Base_TrainNo bllTrain = new TF.RunSafty.BLL.TAB_Base_TrainNo();
if (bllTrain.Delete(paramModel.data.trainnoID))
{
jsonModel.result = 0;
jsonModel.resultStr = "返回成功";
}
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
string result = Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel);
return(result);
}
public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
try
{
ParamModel paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
TF.RunSafty.BLL.Tab_Plan_Rest bllPlace = new TF.RunSafty.BLL.Tab_Plan_Rest();
List <TF.RunSafty.Model.TAB_Plan_Rest> placeList = bllPlace.GetPlanTrain(paramModel.data.dtStartTime, paramModel.data.dtEndTime, paramModel.data.strJiaoluGUID);
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
planArrays p = new planArrays();
jsonModel.data = p;
p.strTrainJiaoLuGUID = paramModel.data.strJiaoluGUID;
p.strCurPlanGUID = "";
p.planArray = bllPlace.GetPlaceList(placeList);
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
return(Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel, timeConverter));
}
public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
try
{
ParamModel paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
TF.RunSafty.Model.TAB_Base_TrainNo train = new TF.RunSafty.Model.TAB_Base_TrainNo();
TF.RunSafty.BLL.TAB_Base_TrainNo bllTrain = new TF.RunSafty.BLL.TAB_Base_TrainNo();
DateTime dtBegin, dtEnd;
string strTrainjiao = paramModel.data.trainjiaoluID;
dtBegin = DateTime.Parse(paramModel.data.beginTime);
dtEnd = DateTime.Parse(paramModel.data.endTime);
int PlanState = paramModel.data.planState <= 0 ? 1 : paramModel.data.planState;
bllTrain.GetTrainnoByTime(strTrainjiao, dtBegin, dtEnd, PlanState);
jsonModel.result = 0;
jsonModel.resultStr = "返回成功";
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
string result = Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel);
return(result);
}
public ActionResult Details(string userId, int orgId = 1)
{
UserModel userModel = null;
int user_id = 0;
//解密处理userid
if (!string.IsNullOrWhiteSpace(userId) && userId != "0")
{
//userId = UtilsHelper.Decrypt(userId);
user_id = int.Parse(userId);
userModel = ServiceProvider.UserService.GetById(user_id);
}
if (userModel == null)
{
userModel = new UserModel();
userModel.BelongDepart = ServiceProvider.OrgService.GetCodeById(orgId);
}
//部门...........生成一个下拉框树所需的数据源
ViewBag.OrgList = ServiceProvider.OrgService.GetAll();
////员工状态
//ParamModel paramModel = ServiceProvider.ParamService.GetByCode(GlobalConstants.SysParamType.EmployeeState);
ParamModel paramModel = ServiceProvider.ParamService.GetByCode(GlobalConstants.SysParamType.EmployeeState);
ViewBag.EmployeeStateList = new SelectList(paramModel.itemsList, "ParamItemValue", "ParamItemName", userModel.EmployeeState);
if (user_id != 0)
{
ViewBag.JobNumb = ServiceProvider.UserService.GetById(user_id).UserName;
}
return(View("Details", userModel));
}
public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
TF.Api.Utilities.Validation validater = new TF.Api.Utilities.Validation();
try
{
ParamModel paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
//验证数据正确性,非空字段不能为空
if (validater.IsNotNullPropertiesValidated(paramModel.data))
{
TF.RunSafty.BLL.TAB_Base_TrainNo bllTrain = new TF.RunSafty.BLL.TAB_Base_TrainNo();
if (bllTrain.UpdateByParamModel(paramModel))
{
jsonModel.result = 0;
jsonModel.resultStr = "返回成功";
}
}
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
string result = Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel);
return(result);
}
public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
try
{
ParamModel paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
TF.RunSafty.BLL.Place.VIEW_Base_Site_DutyPlace bllPlace = new TF.RunSafty.BLL.Place.VIEW_Base_Site_DutyPlace();
string strTrainJiaolu = paramModel.data.trainjiaoluID;
string strSite = paramModel.data.siteID;
List <TF.RunSafty.Model.VIEW_Base_Site_DutyPlace> placeList = bllPlace.GetPlaceOfClient(strTrainJiaolu, strSite);
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
jsonModel.data = GetPlaceList(placeList);
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败";
}
string result = Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel);
return(result);
}
public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
ParamModel param = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
TF.RunSafty.Logic.MonthWorkTimeBLL bllWorkTime = new TF.RunSafty.Logic.MonthWorkTimeBLL();
int nTotalWorkCount = 0;
decimal ntotalMinutes = 0m;
DataTable table = null;
try
{
table = bllWorkTime.GetWorkTimeByTrainman(param.strTrainmanGUID, param.dtBeginTime, param.dtEndTime);
if (table != null)
{
nTotalWorkCount = table.Rows.Count;
ntotalMinutes = Convert.ToDecimal(table.Compute("sum(fTotalTime)", ""));
}
jsonModel.Detail = table;
jsonModel.ntotalMinutes = ntotalMinutes.ToString();
jsonModel.nTotalWorkCount = nTotalWorkCount.ToString();
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
}
jsonModel.result = "0";
jsonModel.resultStr = "返回成功";
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string result = Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel, timeConverter).Replace(":null", ":\"\"");
return(result);
}
public string IsJsPrintable(string data)
{
JsonModel model = new JsonModel();
ParamModel param = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(data);
TF.RunSafty.BLL.Tab_DeliverJSPrint bllPrint = new TF.RunSafty.BLL.Tab_DeliverJSPrint();
TF.RunSafty.Model.Tab_DeliverJSPrint modelPlan = new TF.RunSafty.Model.Tab_DeliverJSPrint();
try
{
int bPrint = bllPrint.IsJsPrintable(param.strPlanGUID, param.strTrainmanGUID, param.dtBeginWorkTime);
modelPlan.StrPlanGUID = param.strPlanGUID;
modelPlan.StrSiteGUID = param.cid;
modelPlan.StrTrainmanGUID = param.strTrainmanGUID;
model.result = "0";
model.returnStr = "返回成功";
model.bPrint = bPrint.ToString();
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
model.result = "1";
model.returnStr = "提交失败" + ex.Message;
}
string result = Newtonsoft.Json.JsonConvert.SerializeObject(model);
return(result);
}
public JsonModel Getsignplanlist(string input)
{
JsonModel jsonModel = new JsonModel();
try
{
ParamModel paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(input);
Bll_Plan_Rest bllPlace = new Bll_Plan_Rest();
List <Modal_Plan_Rest> placeList = bllPlace.GetPlanTrain(paramModel.dtStartTime, paramModel.dtEndTime, paramModel.strJiaoluGUID);
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
planArrays p = new planArrays();
jsonModel.data = p;
p.strTrainJiaoLuGUID = paramModel.strJiaoluGUID;
p.strCurPlanGUID = "";
p.planArray = bllPlace.GetPlaceList(placeList);
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
return(jsonModel);
}
/// <summary>
/// 判断交付揭示是否已经打印
/// </summary>
/// <param name="Data"></param>
/// <returns></returns>
public JsonModelJsPrintCheck JsPrintCheck(string Data)
{
JsonModelJsPrintCheck model = new JsonModelJsPrintCheck();
ParamModel param = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(Data);
DBDeliverJSPrint dbDeliverJSPrint = new DBDeliverJSPrint();
MDSelfServiceMachine.MDDeliverJSPrint modelPlan = new MDSelfServiceMachine.MDDeliverJSPrint();
try
{
int bPrint = dbDeliverJSPrint.IsJsPrintable(param.strPlanGUID, param.strTrainmanGUID, param.dtBeginWorkTime);
modelPlan.StrPlanGUID = param.strPlanGUID;
modelPlan.StrSiteGUID = param.cid;
modelPlan.StrTrainmanGUID = param.strTrainmanGUID;
model.result = "0";
model.returnStr = "返回成功";
model.bPrint = bPrint.ToString();
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
model.result = "1";
model.returnStr = "提交失败" + ex.Message;
}
return(model);
}
/// <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);
}
public int IsExistParamCode(int paramId, string paramCode)
{
ParamModel m = new ParamModel {
ParamId = paramId, ParamCode = paramCode
};
return(DBProvider.dbMapper.SelectObject <int>("Sys_Params.IsExistParamCode", m));
}
private void AddParam()
{
int order = this.ParameterModels.Count();
var paramModel = new ParamModel(order, this.ParameterModels);
this.ParameterModels.Add(paramModel);
}
/// <summary>
/// 更新版本号
/// </summary>
/// <param name="model"></param>
public static void UpdateParam(ParamModel model)
{
string cmdText = "UPDATE Sys_Params Set ParamName=@ParamName WHERE ParamCode=@ParamCode";
SqlParameter[] param = { new SqlParameter("@ParamName", model.ParamName),
new SqlParameter("@ParamCode", model.ParamCode) };
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.Text, cmdText, param);
}
public void Init(ParamModel model, ESettingsType type)
{
_paramName = model.param_name;
_paramId = model.param_id;
Type = type;
TxtParam.text = _paramName;
}
public string PostWithFile()
{
JObject jObject = GetParam(HttpContext.Current.Request);
ParamModel model = GetParamModel(jObject);
Tuple <bool, string> upload = UploadWithFile(HttpContext.Current.Request);
return(upload.Item2 + " 参数：" + JsonConvert.SerializeObject(model));
}
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>
/// <param name="model"></param>
public static void InsertParam(ParamModel model)
{
string cmdText = "INSERT INTO Sys_Params (ParamName, ParamCode, status, CreateDate) VALUES (@ParamName, @ParamCode, @status,getdate())";
SqlParameter[] param = { new SqlParameter("@ParamName", model.ParamName),
new SqlParameter("@ParamCode", model.ParamCode),
new SqlParameter("@status", 1), };
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.Text, cmdText, param);
}
public void Type_ShouldReturnCorrectValue(string xml, string expectedType)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(xml);
mSut = new ParamModel(xmlDoc.FirstChild);
Assert.AreEqual(expectedType, mSut.Type);
}
/// <summary>
/// 简单的Model转换
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
private ParamModel GetParamModel(JObject jObject)
{
ParamModel model = new ParamModel();
model.Param1 = jObject["Param1"] != null ? jObject["Param1"].ToString() : "";
model.Param2 = jObject["Param2"] != null ? jObject["Param2"].ToString() : "";
model.Param3 = jObject["Param3"] != null ? jObject["Param3"].ToString() : "";
return(model);
}
public ActionResult shipment(ParamModel param)
{
List <ShipmentModel> shipments = new List <ShipmentModel>();
ShipmentRepository sr = new ShipmentRepository();
shipments = sr.GetShipments(param.OrderIds);
return(PartialView("/Views/Partials/_PartialShipments.cshtml", shipments));
}
public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
try
{
ParamModel paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
TF.RunSafty.BLL.getAllSign bllPlace = new TF.RunSafty.BLL.getAllSign();
List <TF.RunSafty.Model.Model_Plan_ToBeTake> plans = bllPlace.GetPlanTrain(paramModel.data.strPlanGUID);
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
//jsonModel.data = bllPlace.GetPlaceList(placeList);
if (plans.Count > 0)
{
PlanBeginWork work = new PlanBeginWork();
work.strCheCi = plans[0].StrTrainNo;
work.dtCallWorkTime = plans[0].dtCallWorkTime.ToString();
work.dtWaitWorkTime = plans[0].dtWaitWorkTime.ToString();
work.strTrainmanGUID1 = plans[0].strTrainmanGUID1;
work.strTrainmanGUID2 = plans[0].strTrainmanGUID2;
work.strTrainmanGUID3 = plans[0].strTrainmanGUID3;
work.strTrainmanGUID4 = plans[0].strTrainmanGUID4;
work.strTrainmanName1 = plans[0].strTrainmanName1;
work.strTrainmanName2 = plans[0].strTrainmanName2;
work.strTrainmanName3 = plans[0].strTrainmanName3;
work.strTrainmanName4 = plans[0].strTrainmanName4;
work.strTrainmanNumber1 = plans[0].strTrainmanNumber1;
work.strTrainmanNumber2 = plans[0].strTrainmanNumber2;
work.strTrainmanNumber3 = plans[0].strTrainmanNumber3;
work.strTrainmanNumber4 = plans[0].strTrainmanNumber4;
work.NNeedRest = plans[0].NNeedRest;
work.NPlanState = plans[0].NPlanState;
jsonModel.data = work;
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
}
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
return(Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel, timeConverter));
}
//public static IProcessBase GetProcessByMethod(FormSpider form, ParamModel paramModel)
//{
// if (!ProcessBaseDic.ContainsKey(paramModel.Method))
// throw new Exception(ArtificialCode.A_UnknownMethod.ToString());
// var process = (IProcessBase)Activator.CreateInstance(ProcessBaseDic[paramModel.Method],
// form, paramModel);
// return process;
//}
public static IProcessBase2 GetProcessByMethod(ParamModel paramModel)
{
if (!ProcessBase2Dic.ContainsKey(paramModel.Method))
{
throw new Exception(ArtificialCode.A_UnknownMethod.ToString());
}
var process = (IProcessBase2)Activator.CreateInstance(ProcessBase2Dic[paramModel.Method]);
return(process);
}
/// <summary>
/// 设置操作类型,也即设置处理事件
/// </summary>
public void SetActionType(ParamModel paramModel)
{
//赋值为null
this._result = null;
//得到处理程序,若有异常直接抛出
_process = ProcessFactory.GetProcessByMethod(this, paramModel);
//开始执行
_process?.Begin();
}
/// <summary>
/// 保存实体数据.
/// </summary>
public void Save(ParamModel model)
{
if (model.ParamId == 0)
{
DBProvider.ParamDAO.Add(model);
}
else
{
DBProvider.ParamDAO.Update(model);
}
}
private ParamModel CreateObj(DataRow dataRow)
{
ParamModel info = new ParamModel();
info.FKSN = int.Parse(dataRow["FKSN"].ToString());
info.SN = int.Parse(dataRow["SN"].ToString());
info.ParamName = dataRow["ParamName"].ToString();
info.ParamType = dataRow["ParamType"].ToString();
info.DefaultValue = dataRow["DefaultValue"].ToString();
return(info);
}
