/// <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);
}
