/// <summary> /// 删除规则 /// </summary> public InterfaceOutPut DeleteRule(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InDeleteRule InParams = javaScriptSerializer.Deserialize <InDeleteRule>(Data); string strSql = "delete from Tab_MealTicket_CheCi where strRuleGUID = @strRuleGUID"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strRuleGUID", InParams.RuleGUID) }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams); strSql = "delete from Tab_MealTicket_Rule where strGUID = @strRuleGUID"; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams); output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.DeleteRule:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 修改本段入寓时间 /// </summary> public InterfaceOutPut UpdateInRoomTime(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InUpdateInRoomTime InParams = javaScriptSerializer.Deserialize <InUpdateInRoomTime>(Data); string strSql = "update TAB_Plan_InRoom set dtInRoomTime = @dtInRoomTime where strInRoomGUID = @strInRoomGUID"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("dtInRoomTime", InParams.NewTime), new SqlParameter("strInRoomGUID", InParams.strInRoomGUID) }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams); output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.UpdateInRoomTime:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 1.10.2 获取车间GUID /// </summary> public InterfaceOutPut GetOwnerWorkShopID(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { InGetOwnerWorkShopID InParams = JsonConvert.DeserializeObject <InGetOwnerWorkShopID>(Data); OutGetOwnerWorkShopID OutParams = new OutGetOwnerWorkShopID(); DBTeamGuide db = new DBTeamGuide(); string workShopGUID = ""; if (db.GetWorkShopGUID(InParams.GuideGroupGUID, out workShopGUID)) { OutParams.Exist = 1; OutParams.result = workShopGUID; } output.data = OutParams; output.result = 0; output.resultStr = "返回成功"; } catch (Exception ex) { output.resultStr = "返回失败:" + ex.Message; throw ex; } return(output); }
/// <summary> /// 1.8.13 给定一个工号,返回该职工的请假信息以及所请假的请假类型名称 /// </summary> public InterfaceOutPut GetValidAskLeaveInfoByID(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; string strTypeName; Boolean bExist; try { InGetValidAskLeaveInfoByID InParams = JsonConvert.DeserializeObject <InGetValidAskLeaveInfoByID>(Data); OutGetValidAskLeaveInfoByID OutParams = new OutGetValidAskLeaveInfoByID(); DBLCAskLeave db = new DBLCAskLeave(); OutParams.leaveInfo = db.GetLeavesDataListByID(InParams.strTrainManID, out strTypeName, out bExist); OutParams.strTypeName = strTypeName; OutParams.bExist = bExist; output.data = OutParams; output.result = 0; output.resultStr = "返回成功"; } catch (Exception ex) { output.resultStr = "返回失败:" + ex.Message; throw ex; } return(output); }
/// <summary> /// 1.8.15 获取销假明细 /// </summary> public InterfaceOutPut GetCancelLeaveDetail(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; Boolean bExist; try { InGetCancelLeaveDetail InParams = JsonConvert.DeserializeObject <InGetCancelLeaveDetail>(Data); OutGetCancelLeaveDetail OutParams = new OutGetCancelLeaveDetail(); DBLCAskLeave db = new DBLCAskLeave(); OutParams.CancelLeaveDetail = db.GetCancelLeaveDetailDataList(InParams.strAskLeaveGUID, out bExist); OutParams.bExist = bExist; output.data = OutParams; output.result = 0; output.resultStr = "返回成功"; } catch (Exception ex) { output.resultStr = "返回失败:" + ex.Message; throw ex; } return(output); }
/// <summary> /// 获取指定编号的记名式机组 /// </summary> public InterfaceOutPut GetNamedGroup(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InGetNamedGroup InParams = javaScriptSerializer.Deserialize <InGetNamedGroup>(Data); OutGetNamedGroup OutParams = new OutGetNamedGroup(); string strSql = "select * from VIEW_Nameplate_TrainmanJiaolu_Named where strGroupGUID= @strGroupGUID order by nCheciOrder"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strGroupGUID", InParams.GroupGUID) }; OutParams.Exist = 0; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; if (dt.Rows.Count > 0) { OutParams.Exist = 1; PS.PSNameBoard.NamedGroupFromDB(OutParams.Group, dt.Rows[0]); } output.data = OutParams; output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.GetNamedGroup:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 1.8.12 查询请假记录 /// </summary> public InterfaceOutPut GetLeaves(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { InGetLeaves InParams = JsonConvert.DeserializeObject <InGetLeaves>(Data); LeaveMgr_AskLeaveQueryCondition query = new LeaveMgr_AskLeaveQueryCondition(); query.strBeginDateTime = InParams.strBeginDateTime; query.strEndDateTime = InParams.strEndDateTime; query.strLeaveTypeGUID = InParams.strLeaveTypeGUID; query.strStatus = InParams.strStatus; query.strWorkShopGUID = InParams.strWorkShopGUID; query.strPost = InParams.strPost; query.strGroupGUID = InParams.strGroupGUID; query.strNumber = InParams.strNumber; query.ShowAllUnEnd = InParams.ShowAllUnEnd; OutGetLeaves OutParams = new OutGetLeaves(); DBLCAskLeave db = new DBLCAskLeave(); OutParams.leavesArray = db.GetLeavesDataList(query); output.data = OutParams; output.result = 0; output.resultStr = "返回成功"; } catch (Exception ex) { output.resultStr = "返回失败:" + ex.Message; throw ex; } return(output); }
/// <summary> /// 清除乘务员的指纹信息 /// <summary> public InterfaceOutPut ClearFingerPrint(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { CommonJsonModel cjm = new CommonJsonModel(Data); string strTrainmanGUID = ObjectConvertClass.static_ext_string(cjm.GetValue("strTrainmanGUID")); string strSql = @"update TAB_Org_Trainman set Fingerprint1=null,Fingerprint2=null Where strTrainmanGUID =@strTrainmanGUID"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("strTrainmanGUID", strTrainmanGUID), }; int count = SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters); if (count > 0) { output.result = 0; output.resultStr = "指纹信息清除成功"; } } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.ClearFingerPrint:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 1.8.6 判断是否存在请假类型 /// </summary> public InterfaceOutPut ExistLeaveTypeWhenEdit(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { ResultOutPut res = new ResultOutPut(); InExistLeaveTypeWhenEdit InParams = JsonConvert.DeserializeObject <InExistLeaveTypeWhenEdit>(Data); DBLCLeaveType db = new DBLCLeaveType(); output.result = 0; if (db.ExistsLeaveTypeWhenEdit(InParams.leaveType)) { res.result = true; output.data = res; output.resultStr = "存在"; } else { res.result = false; output.data = res; output.resultStr = "不存在"; } } catch (Exception ex) { output.resultStr = ex.Message; throw ex; } return(output); }
/// <summary> /// 设置计划的寓休信息 /// </summary> public InterfaceOutPut SetPlanRest(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InSetPlanRest InParams = javaScriptSerializer.Deserialize <InSetPlanRest>(Data); string strSql = "update TAB_Plan_Train set nNeedRest=@nNeedRest,dtArriveTime=@dtArriveTime,dtCallTime=@dtCallTime where strTrainPlanGUID = @strTrainPlanGUID"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("nNeedRest", InParams.RestInfo.nNeedRest), new SqlParameter("dtArriveTime", InParams.RestInfo.dtArriveTime), new SqlParameter("dtCallTime", InParams.RestInfo.dtCallTime), new SqlParameter("strTrainPlanGUID", InParams.PlanGUID), }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams); output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.SetPlanRest:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 获取计划变动日志 /// </summary> public InterfaceOutPut GetChangeTrainPlanLog(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InGetChangeTrainPlanLog InParams = javaScriptSerializer.Deserialize <InGetChangeTrainPlanLog>(Data); OutGetChangeTrainPlanLog OutParams = new OutGetChangeTrainPlanLog(); string strSql = "select * from TAB_Plan_ChangeLog where strTrainPlanGUID = @strTrainPlanGUID ORDER BY dtChangeTime DESC"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strTrainPlanGUID", InParams.TrainPlanGUID) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { TrainPlanChangeLog log = new TrainPlanChangeLog(); PS.PSPlan.TrainPlanChangeLogFromDB(log, dt.Rows[i]); OutParams.Logs.Add(log); } output.data = OutParams; output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.GetChangeTrainPlanLog:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 修改车次规则 /// </summary> public InterfaceOutPut ModifyCheCiInfo(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InModifyCheCiInfo InParams = javaScriptSerializer.Deserialize <InModifyCheCiInfo>(Data); string strSql = @"update Tab_MealTicket_CheCi set strWorkShopGUID=strWorkShopGUID,iType=@iType,strQuDuan=@strQuDuan, strRuleGUID=@strRuleGUID,strCheCi=@strCheCi,dtStartTime=@dtStartTime,dtEndTime = @dtEndTime where strGUID = @strGUID"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strWorkShopGUID", InParams.Rule.strWorkShopGUID), new SqlParameter("iType", InParams.Rule.iType), new SqlParameter("strQuDuan", InParams.Rule.strQuDuan), new SqlParameter("strRuleGUID", InParams.Rule.strRuleGUID), new SqlParameter("strGUID", InParams.CheCiGUID), new SqlParameter("strCheCi", InParams.Rule.strCheCi), new SqlParameter("dtStartTime", InParams.Rule.dtStartTime), new SqlParameter("dtEndTime", InParams.Rule.dtEndTime) }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams); output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.ModifyCheCiInfo:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 根据RULE的GUID查询下面的所有车次 /// </summary> public InterfaceOutPut QueryCheCiInfo(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InQueryCheCiInfo InParams = javaScriptSerializer.Deserialize <InQueryCheCiInfo>(Data); OutQueryCheCiInfo OutParams = new OutQueryCheCiInfo(); output.data = OutParams; string strSql = @"SELECT * from Tab_MealTicket_CheCi where strRuleGUID = @strRuleGUID "; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strRuleGUID", InParams.RuleGUID) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { MealTicketCheCi cc = new MealTicketCheCi(); PS.PSMealTicket.MealTicketCheciFromDB(cc, dt.Rows[i]); OutParams.RuleList.Add(cc); } output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.QueryCheCiInfo:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 修改规则 /// </summary> public InterfaceOutPut ModifyRule(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InModifyRule InParams = javaScriptSerializer.Deserialize <InModifyRule>(Data); string strSql = @"update Tab_MealTicket_Rule set strName=@strName,strWorkShopGUID=@strWorkShopGUID, iA=@iA,iB=@iB,iType=@iType where strGUID = @strGUID"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strName", InParams.Rule.strName), new SqlParameter("strGUID", InParams.RuleGUID), new SqlParameter("strWorkShopGUID", InParams.Rule.strWorkShopGUID), new SqlParameter("iA", InParams.Rule.iA), new SqlParameter("iB", InParams.Rule.iB), new SqlParameter("iType", InParams.Rule.iType) }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams); output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.ModifyRule:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 获取计划最后到达时间 /// </summary> public InterfaceOutPut GetLastArrvieTime(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InGetLastArrvieTime InParams = javaScriptSerializer.Deserialize <InGetLastArrvieTime>(Data); OutGetLastArrvieTime OutParams = new OutGetLastArrvieTime(); DateTime ArriveTime = DateTime.Now; bool isLastArrvieTime = getGetLastArrvieTime(InParams.TrainPlanGUID, ref ArriveTime); if (!isLastArrvieTime) { output.resultStr = "不存在此计划信息"; return(output); } else { OutParams.ArriveTime = ArriveTime; } output.data = OutParams; output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.GetLastArrvieTime:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 1.8.9 判断是否有未销假的记录 /// </summary> public InterfaceOutPut CheckWhetherAskLeaveByID(String Data) { InterfaceOutPut output = new InterfaceOutPut(); ResultOutPut res = new ResultOutPut(); try { InCheckWhetherAskLeaveByID InParams = JsonConvert.DeserializeObject <InCheckWhetherAskLeaveByID>(Data); DBLCAskLeave db = new DBLCAskLeave(); if (db.CheckWhetherAskLeaveByID(InParams.strTrainManID)) { res.result = true; output.data = res; output.result = 0; output.resultStr = "已存在"; } else { res.result = false; output.data = res; output.resultStr = "不存在"; } } catch (Exception ex) { output.result = 1; output.resultStr = ex.Message; throw ex; } return(output); }
/// <summary> /// 获取测酒记录 /// </summary> public InterfaceOutPut GetTrainmanDrinkInfo(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; Boolean bExist; try { InGetTrainmanDrinkInfo InParams = JsonConvert.DeserializeObject <InGetTrainmanDrinkInfo>(Data); OutGetTrainmanDrinkInfo OutParams = new OutGetTrainmanDrinkInfo(); DBLCDrink db = new DBLCDrink(); OutParams.drinkInfo = db.GetTrainmanDrinkInfo(InParams.strTrainmanGUID, InParams.strTrainPlanGUID, InParams.WorkType, out bExist); OutParams.bExist = bExist; output.data = OutParams; output.result = 0; output.resultStr = "返回成功"; } catch (Exception ex) { output.resultStr = "返回失败:" + ex.Message; throw ex; } return(output); }
/// <summary> /// 获取退勤计划 /// </summary> public InterfaceOutPut GetTuiQinPlan(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InGetTuiQinPlan InParams = javaScriptSerializer.Deserialize <InGetTuiQinPlan>(Data); OutGetTuiQinPlan OutParams = new OutGetTuiQinPlan(); string strSql = "select top 1 * from VIEW_Plan_EndWork_Full where strTrainPlanGUID = @strTrainPlanGUID"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strTrainPlanGUID", InParams.TuiQinPlanGUID) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; if (dt.Rows.Count == 0) { output.resultStr = "没有找到指定编号的退勤计划"; return(output); } PS.PSPlan.EndworkFromDB(OutParams.Plan, dt.Rows[0]); output.data = OutParams; output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.GetTuiQinPlan:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 获取数据 /// </summary> public InterfaceOutPut GetObjectData(String InputString) { InterfaceOutPut output = new InterfaceOutPut(); output.Success = 0; try { InGetObjectData inParams = (InGetObjectData)Newtonsoft.Json.JsonConvert.DeserializeObject <InGetObjectData>(InputString); OutGetObjectData OutParams = new OutGetObjectData(); TF.YA.Soft.DBSyncObject uStore = new TF.YA.Soft.DBSyncObject(GetDBConn()); OutParams.IsExist = 0; OutParams.Data.Json = ""; OutParams.Data.Key = ""; OutParams.Data.Version = ""; if (uStore.GetObjectData(inParams.ObjectName, inParams.Key, OutParams.Data)) { OutParams.IsExist = 1; byte[] buffer = System.Text.Encoding.UTF8.GetBytes(OutParams.Data.Json); OutParams.Data.Json = Convert.ToBase64String(buffer); } output.Data = OutParams; output.Success = 1; } catch (Exception ex) { output.ResultText = ex.Message; throw ex; } return(output); }
/// <summary> /// 获取差异更新数据索引 /// </summary> public InterfaceOutPut GetUserIndex(String InputString) { InterfaceOutPut output = new InterfaceOutPut(); output.Success = 0; try { InGetUserIndex inParams = (InGetUserIndex)Newtonsoft.Json.JsonConvert.DeserializeObject <InGetUserIndex>(InputString); OutGetUserIndex OutParams = new OutGetUserIndex(); TF.YA.Soft.DBSyncObject uStore = new TF.YA.Soft.DBSyncObject(GetDBConn()); List <TF.YA.Soft.UserIndex> userIndexes = new List <TF.YA.Soft.UserIndex>(); OutParams.IsReg = 1; if (!uStore.GetUserIndex(inParams.UserID, inParams.ObjectName, userIndexes)) { OutParams.IsReg = 0; } OutParams.UserIndexes = userIndexes; output.Data = OutParams; output.Success = 1; } catch (Exception ex) { output.ResultText = ex.Message; throw ex; } return(output); }
/// <summary> /// 查询规则 /// </summary> public InterfaceOutPut QueryRule(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InQueryRule InParams = javaScriptSerializer.Deserialize <InQueryRule>(Data); OutQueryRule OutParams = new OutQueryRule(); output.data = OutParams; string strSql = "SELECT * from Tab_MealTicket_Rule where strWorkShopGUID = @strWorkShopGUID and iType = @iType"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strWorkShopGUID", InParams.WorkShopGUID), new SqlParameter("iType", InParams.AType) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { MealTicketRule rule = new MealTicketRule(); PS.PSMealTicket.MealTicketRuleFromDB(rule, dt.Rows[i]); OutParams.RuleList.Add(rule); } output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.QueryRule:" + ex.Message); throw ex; } return(output); }
public InterfaceOutPut GetUserLimit(string Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InGetUserLimit InParams = javaScriptSerializer.Deserialize <InGetUserLimit>(Data); OutGetUserLimit userlimitOutput = new OutGetUserLimit(); userlimitOutput.SetNameboard = 0; NameplateLimit limit = new NameplateLimit(); if (LCNameplateLimit.GetUserLimit(InParams.UserNumber, limit)) { userlimitOutput.SetNameboard = limit.SetNameboard; } output.data = userlimitOutput; output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; TF.CommonUtility.LogClass.log("Interface.GetPrepareTrainmans:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 1.13.6 删除学员 /// </summary> public InterfaceOutPut DeleteStudent(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { InDeleteStudent InParams = JsonConvert.DeserializeObject <InDeleteStudent>(Data); DBTeacherXYRel db = new DBTeacherXYRel(); db.DeleteStudent(InParams.TeacherGUID, InParams.StudentGUID); //添加操作日志 XyOperateLog OperateLog = new XyOperateLog(); OperateLog.RelationOP = 3;//删除学员 OperateLog.strTeacherGUID = InParams.TeacherGUID; OperateLog.strDutyUserGUID = InParams.DutyUserGUID; OperateLog.strStudentGUID = InParams.StudentGUID; db.AddLog(OperateLog); output.result = 0; output.resultStr = "删除成功"; } catch (Exception ex) { output.resultStr = ex.Message; throw ex; } return(output); }
/// <summary> /// 判断指定的包乘机车组是否已经存在 /// </summary> public InterfaceOutPut ExistTrain(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InExistTrain InParams = javaScriptSerializer.Deserialize <InExistTrain>(Data); string strSql = "select top 1 * from TAB_Nameplate_TrainmanJiaolu_Train where strTrainTypeName = @strTrainTypeName and strTrainNumber = @strTrainNumber "; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strTrainTypeName", InParams.TrainTypeName), new SqlParameter("strTrainNumber", InParams.TrainNumber) }; OutExistTrain OutParams = new OutExistTrain(); OutParams.Exist = 0; if (SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0].Rows.Count > 0) { OutParams.Exist = 1; } output.data = OutParams; output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.ExistTrain:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 添加包乘机车信息 /// </summary> public InterfaceOutPut AddTrain(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InAddTrain InParams = javaScriptSerializer.Deserialize <InAddTrain>(Data); string strSql = @"insert into TAB_Nameplate_TrainmanJiaolu_Train (strTrainGUID,strTrainmanJiaoluGUID,strTrainTypeName,strTrainNumber,dtCreateTime) values (@strTrainGUID,@strTrainmanJiaoluGUID,@strTrainTypeName,@strTrainNumber,getdate())"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strTrainGUID", InParams.TrainGUID), new SqlParameter("strTrainmanJiaoluGUID", InParams.TrainmanJiaoluGUID), new SqlParameter("strTrainTypeName", InParams.TrainTypeName), new SqlParameter("strTrainNumber", InParams.TrainNumber) }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams); output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.AddTrain:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 修改包乘组的机车信息 /// </summary> public InterfaceOutPut UpdateTrainInfo(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InUpdateTrainInfo InParams = javaScriptSerializer.Deserialize <InUpdateTrainInfo>(Data); string strSql = "update TAB_Nameplate_TrainmanJiaolu_Train set strTrainTypeName=@strTrainTypeName,strTrainNumber=@strTrainNumber where strTrainGUID = @strTrainGUID"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strTrainTypeName", InParams.TrainTypeName), new SqlParameter("strTrainNumber", InParams.TrainNumber), new SqlParameter("strTrainGUID", InParams.TrainGUID) }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams); output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.UpdateTrainInfo:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 获取包乘机车中机组正在值乘的假话信息 /// </summary> public InterfaceOutPut GetPlanOfTrain(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InGetPlanOfTrain InParams = javaScriptSerializer.Deserialize <InGetPlanOfTrain>(Data); OutGetPlanOfTrain OutParams = new OutGetPlanOfTrain(); string strSql = @"Select dtStartTime,strTrainNo,strTrainJiaoluName from VIEW_Plan_Trainman where strTrainPlanGUID in (select strTrainPlanGUID from VIEW_Nameplate_TrainmanJiaolu_TogetherTrain where strTrainGUID = @strTrainGUID)"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strTrainGUID", InParams.TrainGUID) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; OutParams.Exist = 0; if (dt.Rows.Count > 0) { OutParams.Exist = 1; PSNameBoard.TrainPlanMinFromDB(OutParams.Plan, dt.Rows[0]); } output.data = OutParams; output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.GetPlanOfTrain:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 删除指定的包乘机车信息 /// </summary> public InterfaceOutPut DeleteTogetherTrain(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InDeleteTogetherTrain InParams = javaScriptSerializer.Deserialize <InDeleteTogetherTrain>(Data); string strSql = "delete from TAB_Nameplate_TrainmanJiaolu_Train where strTrainGUID = @strTrainGUID"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strTrainGUID", InParams.TrainGUID) }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams); output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.DeleteTogetherTrain:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 获得对象信息 /// <summary> public InterfaceOutPut GetEntry(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 0; try { CommonJsonModel cjm = new CommonJsonModel(Data); Base_TrainNoQueryCondition _Base_TrainNoQueryCondition = new Base_TrainNoQueryCondition(); _Base_TrainNoQueryCondition.strGUID = ObjectConvertClass.static_ext_string(cjm.GetValue("strGUID")); DBBase_TrainNo dbBase_TrainNo = new DBBase_TrainNo(ThinkFreely.DBUtility.SqlHelper.ConnString); Base_TrainNo _Base_TrainNo = dbBase_TrainNo.GetModel(_Base_TrainNoQueryCondition); if (_Base_TrainNo == null) { output.resultStr = "没有对应数据"; } else { output.result = 1; List <Base_TrainNo> Base_TrainNoList = new List <Base_TrainNo>(); Base_TrainNoList.Add(_Base_TrainNo); output.data = Base_TrainNoList; } } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("InterfaceBase_TrainNo.GetEntry:" + ex.Message); } return(output); }
/// <summary> /// 获取指定车间指定人员交路未在牌人员的人员列表 /// </summary> public InterfaceOutPut GetTMNotInNameGroup(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InGetPrepareTrainmans InParams = javaScriptSerializer.Deserialize <InGetPrepareTrainmans>(Data); OutGetPrepareTrainmans OutParams = new OutGetPrepareTrainmans(); string str = ""; if (!string.IsNullOrEmpty(InParams.WorkShopGUID)) { str += " and strWorkShopGUID = @strWorkShopGUID"; } if (!string.IsNullOrEmpty(InParams.TrainmanJiaoluGUID)) { str += " and strTrainmanJiaoluGUID = @strTrainmanJiaoluGUID"; } string strSql = string.Format(@"SELECT * FROM TAB_Org_Trainman where ( nTrainmanState=7 or len(nTrainmanState)=0 or ( nTrainmanState=1 and (len(strTrainmanJiaoluGUID)=0 or strTrainmanJiaoluGUID not in(select strTrainmanJiaoluGUID from TAB_Base_TrainmanJiaolu)) ) ) {0} order by strTrainmanNumber ", str); SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strWorkShopGUID", InParams.WorkShopGUID), new SqlParameter("strTrainmanJiaoluGUID", InParams.TrainmanJiaoluGUID) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { TrainmanNamePlate trainman = new TrainmanNamePlate(); PSNameBoard.TrainmanNamePlateFromDB(trainman, dt.Rows[i]); OutParams.Trainmans.Add(trainman); } output.data = OutParams; output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.GetPrepareTrainmans:" + ex.Message); throw ex; } return(output); }