public InterfaceRet UpdateTrainman(string data)
{
_ret.Clear();
try
{
Get_InUpTrainmanMgr input = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InUpTrainmanMgr>(data);
DBTrainman db = new DBTrainman();
if (!db.UpdateTrainman(input.trainman))
{
_ret.result = 1;
_ret.resultStr = "未找到待修改的人员，刷新后再试！";
}
else
{
AddLog(2, Newtonsoft.Json.JsonConvert.SerializeObject(input.trainman), input.trainman.strTrainmanGUID, strIdentifier_user);
}
}
catch (Exception ex)
{
_ret.result = 1;
_ret.resultStr = "提交失败：" + ex.Message;
}
return(_ret);
}
public Get_OutAddTrainmanMgr AddTrainman(string data)
{
Get_InAddTrainmanMgr model = null;
Get_OutAddTrainmanMgr json = new Get_OutAddTrainmanMgr();
//data = HttpUtility.UrlDecode(data);
try
{
model = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InAddTrainmanMgr>(data);
DBTrainman db = new DBTrainman();
if (db.AddTrainman(model.Trainman))
{
json.result = "0";
json.resultStr = "返回成功，成功插入一条数据！";
AddLog(1, Newtonsoft.Json.JsonConvert.SerializeObject(model.Trainman), model.Trainman.strTrainmanGUID, strIdentifier_user);
}
else
{
json.result = "1";
json.resultStr = "返回失败，请查找原因！";
}
}
catch (Exception ex)
{
json.result = "1";
json.resultStr = "提交失败：" + ex.Message;
}
return(json);
}
public Get_OutSetTrainmanState SetTrainmanState(string data)
{
Get_InSetTrainmanState model = null;
Get_OutSetTrainmanState json = new Get_OutSetTrainmanState();
try
{
model = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InSetTrainmanState>(data);
DBTrainman db = new DBTrainman();
int i = db.SetTrainmanState(model.nTrainmanState, model.strTrainmanGUID);
if (i >= 1)
{
json.result = "0";
json.resultStr = "返回成功，成功更新" + i + "条数据！";
}
else if (i == 0)
{
json.result = "1";
json.resultStr = "找不到该记录！";
}
}
catch (Exception ex)
{
json.result = "1";
json.resultStr = "提交失败：" + ex.Message;
}
return(json);
}
public Get_OutClearFinger ClearFinger(string data)
{
Get_InClearFinger model = null;
Get_OutClearFinger json = new Get_OutClearFinger();
try
{
model = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InClearFinger>(data);
DBTrainman db = new DBTrainman();
if (db.ClearFinger(model.TrainmanGUID))
{
json.result = "0";
json.resultStr = "返回成功，成功更新一条数据！";
AddLog(3, "", db.GetTrainmanNumberByGuid(model.TrainmanGUID), strIdentifier_zhiwen);
}
else
{
json.result = "1";
json.resultStr = "返回失败，请查找原因！";
}
}
catch (Exception ex)
{
json.result = "1";
json.resultStr = "提交失败：" + ex.Message;
}
return(json);
}
public Get_OutUpdateTrainmanTel UpdateTrainmanTel(string data)
{
Get_InUpdateTrainmanTel model = null;
Get_OutUpdateTrainmanTel json = new Get_OutUpdateTrainmanTel();
try
{
model = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InUpdateTrainmanTel>(data);
DBTrainman db = new DBTrainman();
if (db.UpdateTrainmanTel(model.TrainmanGUID, model.TrainmanTel, model.TrainmanMobile, model.TrainmanAddress, model.TrainmanRemark))
{
LCYAPlatTrainman.UpdateUserTel(model.TrainmanGUID, model.TrainmanTel);
json.result = "0";
json.resultStr = "返回成功，成功更新一条数据！";
}
else
{
json.result = "1";
json.resultStr = "返回失败，更新0条数据！";
}
}
catch (Exception ex)
{
json.result = "1";
json.resultStr = "提交失败：" + ex.Message;
}
return(json);
}
public Get_OutUpdateFingerAndPicr UpdateFingerAndPic(string data)
{
Get_InUpdateFingerAndPic model = null;
Get_OutUpdateFingerAndPicr json = new Get_OutUpdateFingerAndPicr();
try
{
//data = HttpUtility.UrlDecode(data);
model = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InUpdateFingerAndPic>(data);
DBTrainman db = new DBTrainman();
bool updateFingerPrint = false;
bool updatePicture = false;
int i = db.UpdateFingerAndPic(model.trainman, out updateFingerPrint, out updatePicture);
if (i == 1)
{
json.result = "0";
json.resultStr = "返回成功，成功更新一条数据！";
if (updateFingerPrint) //指纹
{
FingerPrint FingerPrint_m = new FingerPrint();
FingerPrint_m.ID = model.trainman.nID;
FingerPrint_m.Number = model.trainman.strTrainmanNumber;
FingerPrint_m.Finger1 = model.trainman.FingerPrint1;
FingerPrint_m.Finger2 = model.trainman.FingerPrint2;
AddLog(2, Newtonsoft.Json.JsonConvert.SerializeObject(FingerPrint_m), model.trainman.strTrainmanNumber, strIdentifier_zhiwen);
}
if (updatePicture) //图片
{
Picture Picture_m = new Picture();
Picture_m.ID = model.trainman.nID;
Picture_m.Number = model.trainman.strTrainmanNumber;
Picture_m.Pic = model.trainman.Picture;
AddLog(2, Newtonsoft.Json.JsonConvert.SerializeObject(Picture_m), model.trainman.strTrainmanNumber, strIdentifier_zhaopian);
}
}
else if (i == 2)
{
json.result = "1";
json.resultStr = "所传对象为空！修改失败！";
}
else if (i == 3)
{
json.result = "0";
json.resultStr = "未修改任何照片或指纹！";
}
else if (i == 0)
{
json.result = "1";
json.resultStr = "找不到该记录！";
}
}
catch (Exception ex)
{
json.result = "1";
json.resultStr = "提交失败：" + ex.Message;
}
return(json);
}
public InterfaceRet DelTrainman(string data)
{
_ret.Clear();
try
{
//反序列化传入的参数
Get_InDelTrainmanMgr input = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InDelTrainmanMgr>(data);
DBTrainman db = new DBTrainman();
if (!db.CheckIsCanUpdata(input.TrainmanGUID))
{
throw new Exception("请将该人员移除名牌后，再进行修改操作！");
}
if (!db.CheckIsCanUpdataByPlan(input.TrainmanGUID))
{
throw new Exception("该司机有出勤计划，不能删除！");
}
if (!db.CheckIsCanDelUnRun(input.TrainmanGUID))
{
throw new Exception("该司机处于请假状态，不能删除");
}
//获取待删除人员的所有信息
_ret.result = 1;
_ret.resultStr = "未找到要修改的人员，刷新后再试！";
DBTrainman.Tm tm = db.getTmByID(input.TrainmanGUID);
if (db.DelTrainman(input.TrainmanGUID))
{
_ret.result = 0;
_ret.resultStr = "返回成功";
AddLog(3, "", input.TrainmanGUID, strIdentifier_user);
//添加名牌变动日志
db.addLog4DelTrainMan(tm, input.DutyUserGUID, input.DutyUserNumber, input.DutyUserName);
}
}
catch (Exception ex)
{
_ret.result = 1;
_ret.resultStr = "提交失败：" + ex.Message;
}
return(_ret);
}
public Get_OutGetTrainman GetTrainman(string data)
{
Get_OutGetTrainman json = new Get_OutGetTrainman();
try
{
Get_InGetTrainman input = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InGetTrainman>(data);
DBTrainman db = new DBTrainman();
ResultGetTrainman r = new ResultGetTrainman();
r.trainmanArray = db.GetTrainman(input.TrainmanGUID, input.Option);
json.data = r;
json.result = "0";
json.resultStr = "返回成功";
}
catch (Exception ex)
{
json.result = "1";
json.resultStr = "提交失败：" + ex.Message;
}
return(json);
}
public Get_OutExistNumber ExistNumber(string data)
{
Get_OutExistNumber json = new Get_OutExistNumber();
try
{
Get_InExistNumber input = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InExistNumber>(data);
DBTrainman db = new DBTrainman();
ResultExistNumber r = new ResultExistNumber();
r.result = db.ExistNumber(input.TrainmanGUID, input.TrainmanNumber);
json.data = r;
json.result = "0";
json.resultStr = "返回成功";
}
catch (Exception ex)
{
json.result = "1";
json.resultStr = "提交失败：" + ex.Message;
}
return(json);
}
public void UpdateTrainJiaoLu(TmOrg input, DBTrainman.Tm tm)
{
if (string.IsNullOrEmpty(input.TrainmanNumber))
{
throw new Exception("传入人员工号为空，无法修改");
}
DBTrainman db = new DBTrainman();
//判断是否在牌 如果在牌 则需要移除
if (!db.CheckIsCanUpdata(tm.strTrainmanGUID))
{
throw new Exception("请将该人员移除名牌后，再进行修改操作！");
}
//执行修改操作
if (!db.UpdateTrainJiaolu(tm.strTrainmanGUID, input.TrainJiaoluGUID))
{
throw new Exception("未找到待修改的人员！");
}
//添加名牌变动日志
db.addLog4UpdateTrainmanJiaolu(tm, input.TrainJiaoluGUID, input.DutyUserGUID, input.DutyUserNumber, input.DutyUserName);
}
public Get_OutGetTrainmansBrief GetTrainmansBrief(string data)
{
Get_OutGetTrainmansBrief json = new Get_OutGetTrainmansBrief();
try
{
Get_InGetTrainmansBrief input = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InGetTrainmansBrief>(data);
DBTrainman db = new DBTrainman();
ResultGetTrainmansBrief r = new ResultGetTrainmansBrief();
r.trainmanArray = db.GetTrainmansBrief(input.startNid, input.nCount, input.option, out r.nTotalCount);
json.data = r;
json.result = "0";
json.resultStr = "返回成功";
}
catch (Exception ex)
{
json.result = "1";
json.resultStr = "提交失败：" + ex.Message;
}
return(json);
}
public Get_OutQueryTrainmans_blobFlag QueryTrainmans_blobFlag(string data)
{
Get_OutQueryTrainmans_blobFlag json = new Get_OutQueryTrainmans_blobFlag();
try
{
Get_InQueryTrainmans_blobFlag input = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InQueryTrainmans_blobFlag>(data);
DBTrainman db = new DBTrainman();
Result r = new Result();
int allcount = 0;
r.trainmanArray = db.QueryTrainmans_blobFlag(input.QueryTrainman, input.pageindex, ref allcount);;
r.nTotalCount = allcount;
json.data = r;
json.result = "0";
json.resultStr = "返回成功";
}
catch (Exception ex)
{
json.result = "1";
json.resultStr = "提交失败：" + ex.Message;
}
return(json);
}
public Get_OutGetPopupTrainmans GetPopupTrainmans(string data)
{
Get_OutGetPopupTrainmans json = new Get_OutGetPopupTrainmans();
try
{
Get_InGetPopupTrainmans input = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InGetPopupTrainmans>(data);
DBTrainman db = new DBTrainman();
ResultGetPopupTrainmans r = new ResultGetPopupTrainmans();
int allcount = 0;
r.trainmanArray = db.GetPopupTrainmans(input.WorkShopGUID, input.strKeyName, input.pageindex, out allcount);;
r.nTotalCount = allcount;
json.data = r;
json.result = "0";
json.resultStr = "返回成功";
}
catch (Exception ex)
{
json.result = "1";
json.resultStr = "提交失败：" + ex.Message;
}
return(json);
}
public InterfaceRet UpdateTMOrg(string data)
{
InterfaceRet _ret = new InterfaceRet();
_ret.Clear();
DBTrainman db = new DBTrainman();
TmOrg input = Newtonsoft.Json.JsonConvert.DeserializeObject <TmOrg>(data);
try
{
DBTrainman.Tm tm = db.getTm(input.TrainmanNumber);
if (tm == null)
{
throw new Exception("找不到该司机,请从新输入工号");
}
//判断所传机务段是否是空，如果是空直接停止修改
//if (!string.IsNullOrEmpty(input.AreaGUID))
//{
//if (tm.strJiWuDuanGUID != input.AreaGUID) 暂时先不检测
UpdateArea(input, tm);
// }
//判断所传车间是否是空
if (!string.IsNullOrEmpty(input.WorkShopGUID))
{
if (tm.strWorkShopGUID != input.WorkShopGUID)
{
UpdateWorkShop(input, tm);
////判断车间是否位于机务段下
//if (db.checkWorkShopInArea(input.AreaGUID, input.WorkShopGUID))
//else
// throw new Exception("所选车间不属于所选机务段内！");
}
}
else
{
UpdateWorkShop(input, tm);
}
//判断所传区段是否是空，如果是空直接停止修改
if (!string.IsNullOrEmpty(input.TrainJiaoluGUID))
{
if (tm.strTrainJiaoluGUID != input.TrainJiaoluGUID)
{
//判断车间是否位于机务段下
if (db.checkJiaoluInWorkShop(input.WorkShopGUID, input.TrainJiaoluGUID))
{
UpdateTrainJiaoLu(input, tm);
}
else
{
throw new Exception("所选区段不在所选车间内！");
}
}
}
else
{
UpdateTrainJiaoLu(input, tm);
}
return(_ret);
}
catch (Exception ex)
{
_ret.resultStr = ex.Message;
_ret.result = 1;
}
return(_ret);
}
