/// <summary>
/// CarInfoEditSave
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <param name="RID"></param>
/// <returns></returns>
public static string CarInfoEditSave(CarInfoModel Model, string LoginUserID, string RID)
{
using (var db = new VehicleEntities())
{
var List = db.T_Car.Where(t => t.RID == RID).FirstOrDefault();
List.LastUpdDate = DateTime.Now;
List.LastUpdUser = LoginUserID;
List.seatNum = Convert.ToInt32(Model.seatNum);
List.carID = Model.carID;
List.type = Model.type;
List.carName = Model.carName;
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "保存成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "保存失败"
}));
}
}
}
/// <summary>
/// 更新存儲
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <param name="RID"></param>
/// <returns></returns>
public static string UserEditSave(UserModel Model, string RID)
{
using (var db = new VehicleEntities())
{
var List = db.T_UserMaster.Where(t => t.RID == RID).FirstOrDefault();
List.name = Model.name;
List.username = Model.username;
List.type = Model.type;
List.userid = Model.userid;
List.tel = Model.tel;
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "更新成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "更新失败"
}));
}
}
}
/// <summary>
/// 新增存儲
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <returns></returns>
public static string UserAddSave(UserModel Model)
{
using (var db = new VehicleEntities())
{
T_UserMaster List = new T_UserMaster();
List.name = Model.name;
List.userid = Model.userid;
List.username = Model.username;
List.type = Model.type;
List.tel = Model.tel;
List.text1 = "CN";
List.RID = Guid.NewGuid().ToString();
db.AddToT_UserMaster(List);
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "保存成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "保存失败"
}));
}
}
}
/// <summary>
/// LocationInfodelete
/// </summary>
/// <param name="deleteItem"></param>
/// <returns></returns>
public static string LocationInfodelete(string deleteItem)
{
string[] ridArr = deleteItem.Split(',');
using (var db = new VehicleEntities())
{
foreach (var ds in ridArr)
{
string Rid = ds;
var model = db.T_Location.FirstOrDefault(p => p.RID == Rid);
db.DeleteObject(model);
}
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "刪除成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "刪除失败"
}));
}
}
}
/// <summary>
/// LocationInfoEditSave
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <param name="RID"></param>
/// <returns></returns>
public static string LocationInfoEditSave(LocationInfoModel Model, string LoginUserID, string RID)
{
using (var db = new VehicleEntities())
{
var List = db.T_Location.Where(t => t.RID == RID).FirstOrDefault();
List.LastUpdDate = DateTime.Now;
List.LastUpdUser = LoginUserID;
List.name = Model.name;
List.longitude = Model.longitude;
List.latitude = Model.latitude;
if (Model.Radius != "")
{
List.Radius = Convert.ToInt32(Model.Radius);
}
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "保存成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "保存失败"
}));
}
}
}
/// <summary>
/// DriverInfoEditSave
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <param name="RID"></param>
/// <returns></returns>
public static string DriverInfoEditSave(DriveInfoModel Model, string LoginUserID, string RID)
{
using (var db = new VehicleEntities())
{
var List = db.T_UserMaster.Where(t => t.RID == RID).FirstOrDefault();
List.username = Model.Driver_Name;
List.tel = Model.Driver_Tel;
List.userid = Model.Driver_Number;
List.text3 = Model.CarInfo;
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "保存成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "保存失败"
}));
}
}
}
public void AddPhone(int custID, string phoneType, string phoneNumber)
{
using (var context = new VehicleEntities())
{
PhoneNumber queryAdd = new PhoneNumber
{
customerID = custID,
phoneType = phoneType,
number = phoneNumber
};
try
{
context.PhoneNumbers.AddObject(queryAdd);
context.SaveChanges();
// if context.SaveChanges() succeeded add text to the label Add -> lbl.Add.Text
// lblAdd.Text += string.Format("<br/>Added: number {0} of type: {1}", queryAdd.number.ToString(), queryAdd.phoneType);
//if context.savechanges() succeded then delete phone only if old values are DIFFERENT then new values
// Delete phone !only! if NEW values AREN'T same as OLD values!!
phoneTypeOld = ViewState["phoneTypeOld"].ToString();
phoneNumberOld = ViewState["phoneNumberOld"].ToString();
if (phoneType != phoneTypeOld || phoneNumber != phoneNumberOld)
{
DeletePhone(custID, phoneTypeOld, phoneNumberOld);
}
}
catch (OptimisticConcurrencyException ocex)
{
// Resolve the concurrency conflict by refreshing the
// object context before re-saving changes
context.Refresh(RefreshMode.StoreWins, queryAdd);
lblAdd.Text = ocex.ToString();
//throw;
}
catch (InvalidOperationException ioex)
{
context.Refresh(RefreshMode.StoreWins, queryAdd);
lblAdd.Text = ioex.ToString();
}
catch (SqlException sqlexc)
{
context.Refresh(RefreshMode.StoreWins, queryAdd);
lblAdd.Text = sqlexc.ToString();
}
catch (Exception)
{
if (phoneType == phoneTypeOld && phoneNumber == phoneNumberOld)
{
lblAdd.Text = "";
}
else
{
lblAdd.Text = "Error while trying to update record. The object could not be added." +
"Make sure that the same phone does not aleady exist.";
}
}
}
}
/// <summary>
/// 作廢
/// </summary>
/// <param name="deleteItem"></param>
/// <returns></returns>
public static string Planremove(string removeItem)
{
string[] ridArr = removeItem.Split(',');
using (var db = new VehicleEntities())
{
foreach (var ds in ridArr)
{
string planID = ds;
var Planitem = db.M_Plan.FirstOrDefault(p => p.planID == planID && p.valid == "1");
Planitem.valid = "0";
}
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "作廢成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "作廢失败"
}));
}
}
}
/// <summary>
/// CarInfoAddSave
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <returns></returns>
public static string CarInfoAddSave(CarInfoModel Model, string LoginUserID)
{
using (var db = new VehicleEntities())
{
T_Car List = new T_Car();
List.CreateUser = LoginUserID;
List.CreateDate = Convert.ToDateTime(Model.Create_Time);
List.LastUpdDate = Convert.ToDateTime(Model.Create_Time);
List.LastUpdUser = LoginUserID;
List.seatNum = Convert.ToInt32(Model.seatNum);
List.carID = Model.carID;
List.carName = Model.carName;
List.RID = Guid.NewGuid().ToString();
db.AddToT_Car(List);
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "保存成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "保存失败"
}));
}
}
}
public void DeletePhone(int custID, string phoneType, string phoneNumber)
{
using (var context = new VehicleEntities())
{
PhoneNumber queryDelete = new PhoneNumber();
queryDelete = context.PhoneNumbers.First(p => p.customerID == custID && p.phoneType == phoneType && p.number == phoneNumber);
context.DeleteObject(queryDelete);
context.SaveChanges();
}
}
/// <summary>
/// 刪除存儲
/// </summary>
/// <param name="deleteItem"></param>
/// <returns></returns>
public static string Plandelete(string deleteItem)
{
string[] ridArr = deleteItem.Split(',');
using (var db = new VehicleEntities())
{
foreach (var ds in ridArr)
{
string planID = ds;
var Planitem = db.M_Plan.FirstOrDefault(p => p.planID == planID && p.valid == "1");
db.DeleteObject(Planitem);
var PlanRid = Planitem.RID;
var RoadListitem = db.D_RoadList.Where(p => p.PlanRID == PlanRid);
foreach (var item in RoadListitem)
{
db.DeleteObject(item);
}
var PassengerListitem = db.D_PassengerList.Where(p => p.PlanRID == PlanRid);
foreach (var item in PassengerListitem)
{
db.DeleteObject(item);
}
}
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "刪除成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "刪除失败"
}));
}
}
}
/// <summary>
/// DriverInfoAddSave
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <returns></returns>
public static string DriverInfoAddSave(DriveInfoModel Model, string LoginUserID)
{
using (var db = new VehicleEntities())
{
string CarInfoRID = "";
//if (Model.CarInfo != "")
//{
// CarInfoRID = db.Car.Where(p => p.Car_License == Model.CarInfo).FirstOrDefault().RID;
//}
//DateTime Dt = Convert.ToDateTime(Model.Create_Time);
//DriverInfo List = new DriverInfo();
//List.Update_Time = Dt;
//List.Update_User = LoginUserID;
//List.Create_User = LoginUserID;
//List.Create_Time = Dt;
//List.Driver_Name = Model.Driver_Name;
//List.Driver_Number = Model.Driver_Number;
//List.Driver_Company = Model.Driver_Company;
//List.Driver_Tel = Model.Driver_Tel;
//List.RID = Guid.NewGuid().ToString();
//List.CarInfoRID = CarInfoRID;
//db.AddToDriverInfo(List);
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "保存成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "保存失败"
}));
}
}
}
/// <summary>
/// LocationInfoAddSave
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <returns></returns>
public static string LocationInfoAddSave(LocationInfoModel Model, string LoginUserID)
{
using (var db = new VehicleEntities())
{
int LocationIDMax = Convert.ToInt32(db.T_Location.Select(t => t.locationID).Max());
int LocationID = LocationIDMax + 1;
T_Location List = new T_Location();
List.CreateUser = LoginUserID;
List.CreateDate = Convert.ToDateTime(Model.Create_Time);
List.LastUpdDate = Convert.ToDateTime(Model.Create_Time);
List.LastUpdUser = LoginUserID;
List.name = Model.name;
List.longitude = Model.longitude;
List.latitude = Model.latitude;
if (Model.Radius != "")
{
List.Radius = Convert.ToInt32(Model.Radius);
}
List.locationID = LocationID.ToString();
List.RID = Guid.NewGuid().ToString();
db.AddToT_Location(List);
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "保存成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "保存失败"
}));
}
}
}
public void LoadVehicles()
{
using (var entities = new VehicleEntities())
{
var modernVehicle = entities.VehicleTypes.FirstOrDefault(x => x.TypeCode == "MDN");
var classicVehicle = entities.VehicleTypes.FirstOrDefault(x => x.TypeCode == "CLASS");
foreach (var model in entities.Models)
{
if (model.Vehicles.Count == 0)
{
var vehicle = new Vehicle();
vehicle.Model = model;
vehicle.ImageUrl = string.Format("http://cdn.carvalet.com/img/veh/{0}_{1}_1.png", model.MakeCode, model.ModelCode);
vehicle.Name = model.ModelName + " v1";
vehicle.ProducedFromUtc = new DateTime(_Random.Next(1970, 2008), 01, 01);
vehicle.ProducedToUtc = _Random.Next() % 2 == 0 ? new DateTime?(vehicle.ProducedFromUtc.AddYears(_Random.Next(0, 5))) : null;
vehicle.VehicleType = vehicle.ProducedFromUtc.Year < 1980 ? classicVehicle : modernVehicle;
entities.Vehicles.Add(vehicle);
}
}
entities.SaveChanges();
}
}
public void InsertPhone(int custID, string phoneType, string phoneNumber)
{
using (var context = new VehicleEntities())
{
PhoneNumber queryInsert = new PhoneNumber
{
customerID = custID,
phoneType = phoneType,
number = phoneNumber
};
try
{
context.PhoneNumbers.AddObject(queryInsert);
context.SaveChanges();
}
catch (OptimisticConcurrencyException)
{
// Resolve the concurrency conflict by refreshing the
// object context before re-saving changes
context.Refresh(RefreshMode.StoreWins, queryInsert);
lblInsertPhone.Text = "The phone number you attempted to insert was already inserted by " +
"another user. The insert operation was canceled.";
}
catch (UpdateException)
{
lblInsertPhone.Text += "There is already same phone number";
}
catch (Exception)
{
lblInsertPhone.Text += "Exception on Inserting New Phone number";
}
}
}
/// <summary>
/// 新增存儲
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <returns></returns>
public static string PlanAddSave(PlanModel PlanModel, List <PassengerModel> PassengerModel, List <stepModel> stepModel, string LoginUserID)
{
var ToDay = DateTime.Now.ToString("yyyy-MM-dd");
using (var db = new VehicleEntities())
{
var Rid = Guid.NewGuid().ToString();
var PlanID = GetPlanNo();
var stepLen_b = stepModel.Count;
var stepLen = stepLen_b - 1;
string LocationID = "";
string DestinationID = "";
foreach (var item in stepModel)
{
if (item.sequence == 0)
{
LocationID = item.locationID;
}
if (item.sequence == stepLen)
{
DestinationID = item.locationID;
}
}
//存儲主檔
M_Plan Plan = new M_Plan();
Plan.RID = Rid;
Plan.planID = PlanID;
Plan.carID = PlanModel.carID;
Plan.driverID = PlanModel.driverID;
Plan.driverTel = PlanModel.driverTel;
Plan.locationID = LocationID;
Plan.destinationID = DestinationID;
Plan.time = Convert.ToDateTime(PlanModel.time);
Plan.status = Convert.ToInt32(PlanModel.status);
Plan.step = 0;
Plan.CreateDate = Convert.ToDateTime(PlanModel.CreateDate);
Plan.CreateUser = LoginUserID;
Plan.LastUpdDate = Convert.ToDateTime(PlanModel.CreateDate);
Plan.LastUpdUser = LoginUserID;
Plan.valid = "1";
Plan.IsSend = "0";
Plan.batch = PlanID;
db.AddToM_Plan(Plan);
//存儲站點表
foreach (var item in stepModel)
{
D_RoadList RoadList = new D_RoadList();
RoadList.RID = item.RID;
RoadList.PlanRID = Rid;
RoadList.planID = PlanID;
RoadList.locationID = Convert.ToInt32(item.locationID);
RoadList.sequence = item.sequence;
db.AddToD_RoadList(RoadList);
}
//存儲乘客表
foreach (var item in PassengerModel)
{
D_PassengerList PassengerList = new D_PassengerList();
PassengerList.RID = item.RID;
PassengerList.PlanRID = Rid;
PassengerList.planID = PlanID;
PassengerList.passengerID = item.passengerID;
PassengerList.time = Convert.ToDateTime(item.time);
PassengerList.status = item.status;
PassengerList.remark = item.remark;
PassengerList.returnTime = "";
PassengerList.locationID = item.locationID;
PassengerList.destinationID = item.destinationID;
db.AddToD_PassengerList(PassengerList);
}
var YearText = DateTime.Now.ToString("yyyyMMdd").Substring(2, 2);
int?number = null;
var List = db.T_SystemApply.Where(t => t.FunctionName == "PlanNo" && t.DateTime == YearText);
if (List.Count() > 0)
{
var num = List.Max(t => t.Number);
//number = List.OrderByDescending(t => t.Create_Date).First().Number;
number = num + 1;
}
else
{
number = 1;
}
//存儲單號記錄
T_SystemApply SystemApply = new T_SystemApply();
SystemApply.Create_Date = DateTime.Now;
SystemApply.DateTime = PlanModel.CreateDate.ToString("yyyy-MM-dd").Substring(2, 2);
SystemApply.Number = number;
SystemApply.FunctionName = "PlanNo";
SystemApply.RID = Guid.NewGuid().ToString();
db.AddToT_SystemApply(SystemApply);
int success = db.SaveChanges();
if (success > 0)
{
//在這寫
ViewModel.Result result = new Result();
result.success = true;
result.message = "提交保存成功";
WeChatWS.WeChatWSSoapClient ws = new WeChatWS.WeChatWSSoapClient();
ws.seedsmsToDriver(Rid);
using (var plan = new VehicleEntities())
{
var rst = plan.M_Plan.Where(t => t.RID == Rid).FirstOrDefault();
rst.IsSend = "1";
plan.SaveChanges();
}
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "保存失败"
}));
}
}
}
/// <summary>
/// 更新存儲
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <param name="RID"></param>
/// <returns></returns>
public static string PlanEditSave(PlanModel PlanModel, List <PassengerModel> PassengerModel, List <stepModel> stepModel, string LoginUserID)
{
using (var db = new VehicleEntities())
{
DateTime LastUpdDate = DateTime.Now;
string LocationID = "";
string DestinationID = "";
var stepLen = stepModel.Count - 1;
var RID = "";
foreach (var item in stepModel)
{
if (item.sequence == 0)
{
LocationID = item.locationID;
}
if (item.sequence == stepLen)
{
DestinationID = item.locationID;
}
}
var PlanList = db.M_Plan.Where(t => t.planID == PlanModel.planID);
if (PlanList.Count() > 1)
{
foreach (var item in PlanList)
{
var itemRID = item.RID;
item.LastUpdDate = LastUpdDate;
item.locationID = LocationID;
item.destinationID = DestinationID;
var PassengerList = db.D_PassengerList.Where(t => t.PlanRID == item.RID);
if (PassengerList.Count() > 0)
{
item.carID = PlanModel.carID;
item.driverTel = PlanModel.driverTel;
item.driverID = PlanModel.driverID;
item.locationID = LocationID;
item.destinationID = DestinationID;
item.status = Convert.ToInt32(PlanModel.status);
item.time = Convert.ToDateTime(PlanModel.time);
item.LastUpdUser = LoginUserID;
var PlanID = item.planID;
RID = item.RID;
//站點表
var RoadList = db.D_RoadList.Where(t => t.planID == PlanID);
foreach (var del in RoadList)
{
db.DeleteObject(del);
}
foreach (var setpitem in stepModel)
{
D_RoadList RoadListitem = new D_RoadList();
RoadListitem.RID = Guid.NewGuid().ToString();
RoadListitem.PlanRID = RID;
RoadListitem.planID = PlanID;
RoadListitem.locationID = Convert.ToInt32(setpitem.locationID);
RoadListitem.sequence = setpitem.sequence;
if (setpitem.atime != null)
{
RoadListitem.atime = Convert.ToDateTime(setpitem.atime);
}
if (setpitem.ltime != null)
{
RoadListitem.ltime = Convert.ToDateTime(setpitem.ltime);
}
db.AddToD_RoadList(RoadListitem);
}
//乘客表
var PassengerListModel = db.D_PassengerList.Where(t => t.PlanRID == RID);
foreach (var del in PassengerList)
{
db.DeleteObject(del);
}
foreach (var Passengeritem in PassengerModel)
{
D_PassengerList PassengerListitem = new D_PassengerList();
PassengerListitem.RID = Guid.NewGuid().ToString();
PassengerListitem.PlanRID = RID;
PassengerListitem.planID = PlanID;
PassengerListitem.returnTime = Passengeritem.returnTime;
PassengerListitem.passengerID = Passengeritem.passengerID;
PassengerListitem.time = Convert.ToDateTime(Passengeritem.time);
PassengerListitem.status = Passengeritem.status;
PassengerListitem.remark = Passengeritem.remark;
PassengerListitem.locationID = Passengeritem.locationID;
PassengerListitem.destinationID = Passengeritem.destinationID;
if (Passengeritem.confirmTime != null)
{
PassengerListitem.confirmTime = Convert.ToDateTime(Passengeritem.confirmTime);
}
db.AddToD_PassengerList(PassengerListitem);
}
}
}
}
else
{
RID = db.M_Plan.Where(t => t.planID == PlanModel.planID).FirstOrDefault().RID;
//主檔
var Plan = db.M_Plan.Where(t => t.RID == RID).FirstOrDefault();
Plan.carID = PlanModel.carID;
Plan.driverTel = PlanModel.driverTel;
Plan.driverID = PlanModel.driverID;
Plan.locationID = LocationID;
Plan.destinationID = DestinationID;
Plan.status = Convert.ToInt32(PlanModel.status);
Plan.time = Convert.ToDateTime(PlanModel.time);
Plan.LastUpdDate = LastUpdDate;
Plan.LastUpdUser = LoginUserID;
//站點表
var RoadList = db.D_RoadList.Where(t => t.PlanRID == RID);
foreach (var del in RoadList)
{
db.DeleteObject(del);
}
foreach (var item in stepModel)
{
D_RoadList RoadListitem = new D_RoadList();
RoadListitem.RID = Guid.NewGuid().ToString();
RoadListitem.PlanRID = RID;
RoadListitem.planID = Plan.planID;
RoadListitem.locationID = Convert.ToInt32(item.locationID);
RoadListitem.sequence = item.sequence;
if (item.atime != null)
{
RoadListitem.atime = Convert.ToDateTime(item.atime);
}
if (item.ltime != null)
{
RoadListitem.ltime = Convert.ToDateTime(item.ltime);
}
db.AddToD_RoadList(RoadListitem);
}
//乘客表
var PassengerList = db.D_PassengerList.Where(t => t.PlanRID == RID);
foreach (var del in PassengerList)
{
db.DeleteObject(del);
}
foreach (var item in PassengerModel)
{
D_PassengerList PassengerListitem = new D_PassengerList();
PassengerListitem.RID = Guid.NewGuid().ToString();
PassengerListitem.PlanRID = RID;
PassengerListitem.planID = Plan.planID;
PassengerListitem.passengerID = item.passengerID;
PassengerListitem.time = Convert.ToDateTime(item.time);
PassengerListitem.status = item.status;
PassengerListitem.returnTime = item.returnTime;
PassengerListitem.remark = item.remark;
PassengerListitem.locationID = item.locationID;
PassengerListitem.destinationID = item.destinationID;
if (item.confirmTime != null)
{
PassengerListitem.confirmTime = Convert.ToDateTime(item.confirmTime);
}
db.AddToD_PassengerList(PassengerListitem);
}
}
int success = db.SaveChanges();
if (success > 0)
{
var IsSend = "";
//在這寫
using (var plan = new VehicleEntities())
{
var SendPlan = plan.M_Plan.Where(t => t.RID == RID).FirstOrDefault();
IsSend = SendPlan.IsSend;
if (IsSend != "1")
{
WeChatWS.WeChatWSSoapClient ws = new WeChatWS.WeChatWSSoapClient();
ws.seedsmsToDriver(RID);
SendPlan.IsSend = "1";
plan.SaveChanges();
}
;
}
ViewModel.Result result = new Result();
result.success = true;
result.message = "提交保存成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "保存失败"
}));
}
}
}
/// <summary>
/// 合併wf派車單
/// </summary>
/// <returns></returns>
public static string MergePlan(List <MergePlanModel> M_PlanModel)
{
string rst = "success";
var Now = DateTime.Now;
int success = 0;
List <M_Plan> PlanList = new List <M_Plan>();
List <D_PassengerList> PassengerList = new List <D_PassengerList>();
var PlanID = GetPlanNo();
var LastUpdDate = "";
var CreateDate = "";
var NewRid = Guid.NewGuid().ToString();
using (var db = new VehicleEntities())
{
foreach (var item in M_PlanModel)
{
var changePlanModel = db.M_Plan.Where(t => t.planID == item.PlanID).FirstOrDefault();
LastUpdDate = changePlanModel.LastUpdDate.ToString();
CreateDate = changePlanModel.CreateDate.ToString();
}
foreach (var item in M_PlanModel)
{
var changePlanModel = db.M_Plan.Where(t => t.planID == item.PlanID).FirstOrDefault();
M_Plan Planitem = new M_Plan();
Planitem.RID = Guid.NewGuid().ToString();
Planitem.batch = changePlanModel.batch;
Planitem.carID = changePlanModel.carID;
Planitem.LastUpdUser = changePlanModel.LastUpdUser;
Planitem.CreateUser = changePlanModel.CreateUser;
Planitem.driverID = changePlanModel.driverID;
Planitem.driverTel = changePlanModel.driverTel;
Planitem.time = changePlanModel.time;
Planitem.status = changePlanModel.status;
Planitem.step = changePlanModel.step;
Planitem.LastUpdDate = Convert.ToDateTime(LastUpdDate);
Planitem.CreateDate = Convert.ToDateTime(CreateDate);
Planitem.planID = PlanID;
Planitem.valid = "0";
PlanList.Add(Planitem);
var PassengerModel = db.D_PassengerList.Where(t => t.planID == item.PlanID);
foreach (var Passger_Item in PassengerModel)
{
D_PassengerList itemList = new D_PassengerList();
itemList.RID = Guid.NewGuid().ToString();
itemList.planID = PlanID;
itemList.locationID = Passger_Item.locationID;
itemList.confirmTime = Passger_Item.confirmTime;
itemList.destinationID = Passger_Item.destinationID;
itemList.passengerID = Passger_Item.passengerID;
itemList.returnTime = Passger_Item.returnTime;
itemList.PlanRID = NewRid;
itemList.remark = Passger_Item.remark;
itemList.status = Passger_Item.status;
itemList.time = Passger_Item.time;
PassengerList.Add(itemList);
}
}
foreach (var item in M_PlanModel)
{
var PlanModel = db.M_Plan.Where(t => t.planID == item.PlanID).FirstOrDefault();
db.DeleteObject(PlanModel);
var PassengerModel = db.D_PassengerList.Where(t => t.planID == item.PlanID);
foreach (var PassengerItem in PassengerModel)
{
if (item.PlanID == PassengerItem.planID)
{
db.DeleteObject(PassengerItem);
}
}
}
foreach (var addPlanitem in PlanList)
{
db.AddToM_Plan(addPlanitem);
}
foreach (var adPassengerditem in PassengerList)
{
db.AddToD_PassengerList(adPassengerditem);
}
var YearText = DateTime.Now.ToString("yyyyMMdd").Substring(2, 2);
int?number = null;
var List = db.T_SystemApply.Where(t => t.FunctionName == "PlanNo" && t.DateTime == YearText);
if (List.Count() > 0)
{
var num = List.Max(t => t.Number);
//number = List.OrderByDescending(t => t.Create_Date).First().Number;
number = num + 1;
}
else
{
number = 1;
}
//存儲單號記錄
T_SystemApply SystemApply = new T_SystemApply();
SystemApply.Create_Date = DateTime.Now;
SystemApply.DateTime = Now.ToString("yyyy-MM-dd").Substring(2, 2);
SystemApply.Number = number;
SystemApply.FunctionName = "PlanNo";
SystemApply.RID = Guid.NewGuid().ToString();
db.AddToT_SystemApply(SystemApply);
success = db.SaveChanges();
}
var modelRID = "";
using (var db = new VehicleEntities())
{
var model = db.M_Plan.Where(t => t.planID == PlanID).FirstOrDefault();
modelRID = model.RID;
var demodel = db.D_PassengerList.Where(t => t.planID == PlanID);
foreach (var deitem in demodel)
{
deitem.PlanRID = modelRID;
}
db.SaveChanges();
}
using (var db = new VehicleEntities())
{
var modelPlanvalid = db.M_Plan.Where(t => t.RID == modelRID).FirstOrDefault();
modelPlanvalid.valid = "1";
modelPlanvalid.IsSend = "0";
db.SaveChanges();
}
if (success > 0)
{
return(rst);
}
else
{
rst = "fail";
return(rst);
}
}
