public ActionResult AddCustomData(string CustomName, string CustomValue)
{
this.Internationalization();
TugDataEntities db = new TugDataEntities();
try
{
System.Linq.Expressions.Expression<Func<CustomField, bool>> exp = u => u.CustomName == CustomName && u.CustomLabel == CustomValue;
CustomField tmpCustom = db.CustomField.Where(exp).FirstOrDefault();
if (tmpCustom != null)
{
throw new Exception(CustomValue + "已存在！");
}
CustomField custom = new CustomField();
custom.CustomName = CustomName;
custom.CustomValue = "";
custom.CustomLabel = CustomValue;
custom.Description = "";
custom.UserID = Session.GetDataFromSession<int>("userid");
custom.CreateDate = custom.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
custom = db.CustomField.Add(custom);
db.SaveChanges();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult GetAlert()
{
int curUserId = 0;
int NeedApprovedCount, RejectBillingCount, RejectOrderCount;
curUserId = Session.GetDataFromSession<int>("userid");
TugDataEntities db = new TugDataEntities();
//待审核任务
List<V_NeedApproveBilling> objs = db.V_NeedApproveBilling.Where(u => u.FlowUserID == curUserId && u.Phase != 0).OrderByDescending(u => u.IDX).ToList<V_NeedApproveBilling>();
NeedApprovedCount = objs.Count;
//被驳回账单
List<Billing> rejectBilling = db.Billing.Where(u => u.UserID == curUserId && u.Phase == 0 && u.Status == "被駁回").OrderByDescending(u => u.IDX).ToList<Billing>();
RejectBillingCount = rejectBilling.Count;
//被驳回订单
//List<V_OrderService> rejectOrder = db.V_OrderService.Where(u => u.OrderUserId == curUserId && (u.ServiceJobStateLabel == "被駁回" || u.ServiceJobStateValue == "3")).ToList<V_OrderService>();
List<V_OrderService> rejectOrder = db.V_OrderService.Where(u => (u.ServiceJobStateLabel == "被駁回" || u.ServiceJobStateValue == "3")).ToList<V_OrderService>();
RejectOrderCount = rejectOrder.Count;
return Json(new
{
code = Resources.Common.SUCCESS_CODE,
message = Resources.Common.SUCCESS_MESSAGE,
NeedApprovedCount,
RejectBillingCount,
RejectOrderCount
}, JsonRequestBehavior.AllowGet);
}
//这个Tuple类型数组的amountlist中依次存储 int SchedulerID, int TugID, float Amount, float Hours
//一个账单调用一次
public void AmountSumAdd_Update(int CustomerID, int CustomerShipID, int BillingID, DateTime BillingDate, Tuple<int, int, float, float>[] amountlist)
{
try
{
TugDataEntities db = new TugDataEntities();
//先删除
System.Linq.Expressions.Expression<Func<AmountSum, bool>> exp = u => u.BillingID == BillingID;
var entitys = db.AmountSum.Where(exp);
entitys.ToList().ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.AmountSum.RemoveRange(entitys);
db.SaveChanges();
//新增
foreach(var obj in amountlist)
{
TugDataModel.AmountSum newobj = new AmountSum();
newobj.CustomerID = CustomerID;
newobj.CustomerShipID = CustomerShipID;
newobj.BillingID = BillingID;
newobj.BillingDateTime = BillingDate;
newobj.SchedulerID = obj.Item1;//SchedulerID;
newobj.TugID = obj.Item2;;
newobj.Amount = obj.Item3; ;
newobj.Hours = obj.Item4; ;
newobj.OwnerID = -1;
newobj.CreateDate = newobj.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ;//.ToString("yyyy-MM-dd");
newobj.UserID = Session.GetDataFromSession<int>("userid");
newobj.UserDefinedCol1 = "";
newobj.UserDefinedCol2 = "";
newobj.UserDefinedCol3 = "";
newobj.UserDefinedCol4 = "";
//if (Request.Form["UserDefinedCol5"].Trim() != "")
// newobj.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
//if (Request.Form["UserDefinedCol6"].Trim() != "")
// newobj.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
//if (Request.Form["UserDefinedCol7"].Trim() != "")
// newobj.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
//if (Request.Form["UserDefinedCol8"].Trim() != "")
// newobj.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
newobj.UserDefinedCol9 = "";
newobj.UserDefinedCol10 = "";
newobj = db.AmountSum.Add(newobj);
}
db.SaveChanges();
//var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
//return Json(ret);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult ApproveCount()
{
int curUserId = 0, ApprovedCount;
TugDataEntities db = new TugDataEntities();
curUserId = Session.GetDataFromSession<int>("userid"); //當前用戶ID
List<Approve> ApproveList = db.Approve.Where(u => u.PersonID == curUserId).Select(u => u).ToList<Approve>();
if (ApproveList.Count != 0)
{
List<Billing> BillList = db.Billing.Where(u => u.IDX == -1).Select(u => u).ToList<Billing>();
foreach (Approve obj in ApproveList)
{
if (Convert.ToInt32(obj.Accept) > 2) continue;
System.Linq.Expressions.Expression<Func<Billing, bool>> expB = u => u.IDX == obj.BillingID;
Billing billData = db.Billing.Where(expB).FirstOrDefault();
if (billData != null)
{
//撤销提交的为待提交任务
if (Convert.ToInt32(billData.Phase) == 0 && billData.Status == "已撤销提交") continue;
//驳回或撤销通过的为待完成任务
if (Convert.ToInt32(billData.Phase) == 0 && billData.Status.ToString().Length >= 3) continue;
BillList.Add(billData);
}
}
ApprovedCount = BillList.Count;
return Json(new { message = ApprovedCount });
}
else
{
Response.StatusCode = 404;
return Json(new { message = "0" });
}
}
/// <summary>
/// 用于执行单条sql语句，并返回datatable...
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static DataTable GetDatatableBySql(string sql)
{
if (sql.Trim() == string.Empty) return null;
DataTable dt = null;
System.Data.DataSet ds = new System.Data.DataSet();
try
{
using (TugDataEntities db = new TugDataEntities())
{
DbConnection con = db.Database.Connection;
DbCommand cmd = con.CreateCommand();
cmd.CommandText = sql;
cmd.CommandType = System.Data.CommandType.Text;
System.Data.Common.DbDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter();
adapter.SelectCommand = cmd;
adapter.Fill(ds);
}
if (ds.Tables.Count > 0)
{
dt = ds.Tables[0];
ds.Tables.RemoveAt(0);
}
return dt;
}
catch (System.Exception ex)
{
throw ex;
}
}
public static DataTable GetDatatableBySP(string spName, SqlParameter[] param = null)
{
DataTable dt = null;
System.Data.DataSet ds = new System.Data.DataSet();
try
{
//TugDataEntities db = new TugDataEntities();
using (TugDataEntities db = new TugDataEntities())
{
DbConnection con = db.Database.Connection;
DbCommand cmd = con.CreateCommand();
cmd.CommandText = spName;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (param != null && param.Length > 0) cmd.Parameters.AddRange(param);
System.Data.Common.DbDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter();
adapter.SelectCommand = cmd;
adapter.Fill(ds);
}
if (ds.Tables.Count > 0)
{
dt = ds.Tables[0];
ds.Tables.RemoveAt(0);
if (dt != null) dt.TableName = spName;
}
return dt;
}
catch (System.Exception ex)
{
throw ex;
}
}
public ActionResult AddCredit(int billingId, string billingCode, string creditContent, double creditAmount, string creditdate, string remark)
{
TugDataModel.Credit credit;
this.Internationalization();
try
{
TugDataEntities db = new TugDataEntities();
{
credit = new Credit();
credit.BillingID = billingId;
credit.CreditCode = "C" + billingCode.Substring(1, billingCode.Length - 1 );
credit.CreditContent = creditContent;
credit.CreditAmount = creditAmount;
credit.UserDefinedCol10 = creditdate;
credit.Remark = remark;
credit.CreateDate = credit.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
credit.OwnerID = -1;
credit.UserID = credit.UserID = Session.GetDataFromSession<int>("userid");
//credit.UserDefinedCol1 = "";
//credit.UserDefinedCol2 = "";
//credit.UserDefinedCol3 = "";
//credit.UserDefinedCol4 = "";
//credit.UserDefinedCol5 = 0;
//credit.UserDefinedCol6 = 0;
//credit.UserDefinedCol7 = 0;
//credit.UserDefinedCol8 = 0;
//credit.UserDefinedCol9 = "";
//credit.UserDefinedCol10 = "";
credit = db.Credit.Add(credit);
db.SaveChanges();
//更新账单中的回扣金额
{
TugBusinessLogic.Module.FinanceLogic.UpdateTotalRebateOfBilling(billingId);
}
}
var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE, billing_id = credit.IDX };
return Json(ret, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
return Json(ret, JsonRequestBehavior.AllowGet);
}
}
/// <summary>
/// 获取拖轮一日的时间安排状态
/// </summary>
/// <param name="tugId">拖轮ID</param>
/// <param name="tugEx">拖轮对象</param>
/// <param name="workDate">指定日期</param>
/// <returns></returns>
public static TugEx GetTugSchedulerBusyState(int tugId, TugEx tugEx, string workDate)
{
TugDataEntities db = new TugDataEntities();
//string now = DateTime.Now.ToString("yyyy-MM-dd");
List<V_OrderScheduler> schedulers = db.V_OrderScheduler.Where(u => u.TugID == tugId && u.ServiceWorkDate == workDate)
.Select(u => u).OrderByDescending(u => u.IDX).ToList<V_OrderScheduler>();
//schedulers[0].DepartBaseTime;
//schedulers[0].ArrivalBaseTime;
if(schedulers != null)
{
foreach (V_OrderScheduler item in schedulers)
{
if(item.DepartBaseTime != null && item.ArrivalBaseTime != null)
tugEx = SetTugBusyState(item.DepartBaseTime.Trim(), item.ArrivalBaseTime.Trim(), tugEx);
//tugEx = SetTugBusyState("00:20", "00:30", tugEx);
}
}
return tugEx;
}
public ActionResult AddEditService2()
{
this.Internationalization();
#region Edit
using (System.Transactions.TransactionScope trans = new System.Transactions.TransactionScope())
{
if (Request.Form["oper"].Equals("edit"))
{
try
{
TugDataEntities db = new TugDataEntities();
int idx = Util.toint(Request.Form["OrderServiceID"].Trim());
int orderid = Util.toint(Request.Form["OrderID"].Trim());
var customerName = Request.Form["CustomerName"].Trim();
var shipName = Request.Form["ShipName"].Trim();
int customerid;// = Util.toint(Request.Form["CustomerID"].Trim());
int shipid;//= Util.toint(Request.Form["ShipID"].Trim());
//判断客户名称是否存在
System.Linq.Expressions.Expression<Func<Customer, bool>> expctm = u => u.Name1 == customerName;
Customer objctm = db.Customer.Where(expctm).FirstOrDefault();
if (objctm == null)
{
//throw new Exception("客戶名稱不存在！");
return Json(new { code = Resources.Common.ERROR_CODE, message = "客戶名稱不存在！" });
}
else
customerid = objctm.IDX;
//判断客户船名称是否存在//
System.Linq.Expressions.Expression<Func<CustomerShip, bool>> expcts = u => u.Name1 == shipName;
CustomerShip objcts = db.CustomerShip.Where(expcts).FirstOrDefault();
if (objcts == null)
{
//throw new Exception("客戶船名稱不存在！");
return Json(new { code = Resources.Common.ERROR_CODE, message = "客戶船名稱不存在！" });
}
else
shipid = objcts.IDX;
OrderService aOrderService = db.OrderService.Where(u => u.IDX == idx).FirstOrDefault();
if (aOrderService == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
aOrderService.ServiceWorkDate = Request.Form["ServiceWorkDate"];
aOrderService.ServiceWorkTime = Request.Form["ServiceWorkTime"];
aOrderService.ServiceNatureID = TugBusinessLogic.Module.Util.toint(Request.Form["ServiceNatureID"]);
aOrderService.ServiceWorkPlace = Request.Form["ServiceWorkPlace"];
aOrderService.BigTugNum = Util.toint(Request.Form["BigTugNum"].Trim());
aOrderService.MiddleTugNum = Util.toint(Request.Form["MiddleTugNum"].Trim());
aOrderService.SmallTugNum = Util.toint(Request.Form["SmallTugNum"].Trim());
aOrderService.UserDefinedCol9 = Request.Form["TugIDs"];
aOrderService.UserDefinedCol10 = Request.Form["TugNames"];
aOrderService.OwnerID = -1;
aOrderService.UserID = Session.GetDataFromSession<int>("userid");
aOrderService.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
db.Entry(aOrderService).State = System.Data.Entity.EntityState.Modified;
if (0 < db.SaveChanges()) //修改成功
{
//更新订单
OrderInfor aOrder = db.OrderInfor.Where(u => u.IDX == orderid).FirstOrDefault();
if (aOrder != null)
{
aOrder.CustomerID = customerid;// Util.toint(Request.Form["CustomerID"].Trim());
aOrder.CustomerName = Request.Form["CustomerName"].Trim();
aOrder.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
////aOrder.IsGuest = Request.Form["IsGuest"].Trim();
aOrder.LinkMan = Request.Form["LinkMan"].Trim();
aOrder.LinkPhone = Request.Form["LinkPhone"].Trim();
aOrder.LinkEmail = Request.Form["LinkEmail"].Trim();
//aOrder.OrdDate = Request.Form["OrdDate"].Trim();
aOrder.ShipID = shipid;//Util.toint(Request.Form["ShipID"].Trim());
aOrder.ShipName = Request.Form["ShipName"].Trim();
//aOrder.Remark = Request.Form["Remark"].Trim();
//aOrder.UserDefinedCol1 = Request.Form["UserDefinedCol1"].Trim();
//aOrder.UserDefinedCol2 = Request.Form["UserDefinedCol2"].Trim();
//aOrder.UserDefinedCol3 = Request.Form["UserDefinedCol3"].Trim();
//aOrder.UserDefinedCol4 = Request.Form["UserDefinedCol4"].Trim();
//if (Request.Form["UserDefinedCol5"].Trim() != "")
// aOrder.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
//if (Request.Form["UserDefinedCol6"].Trim() != "")
// aOrder.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
//if (Request.Form["UserDefinedCol7"].Trim() != "")
// aOrder.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
//if (Request.Form["UserDefinedCol8"].Trim() != "")
// aOrder.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
//aOrder.UserDefinedCol9 = Request.Form["UserDefinedCol9"].Trim();
//aOrder.UserDefinedCol10 = Request.Form["UserDefinedCol10"].Trim();
db.Entry(aOrder).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
//1.先删除原有的调度
var oldSchedulers = db.Scheduler.Where(u => u.OrderServiceID == idx).ToList();
if (oldSchedulers != null)
{
db.Scheduler.RemoveRange(oldSchedulers);
if (0 < db.SaveChanges())
{
OrderService os = db.OrderService.FirstOrDefault(u => u.IDX == idx);
os.JobStateID = 114;
db.Entry(os).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
//2.插入新更改的调度
#region 插入多个调度到数据库
{
if (aOrderService.UserDefinedCol9.Trim() != "")
{
List<string> lstTugIds = aOrderService.UserDefinedCol9.Split(',').ToList();
if (lstTugIds != null && lstTugIds.Count > 0)
{
List<Scheduler> lstSchedulers = new List<Scheduler>();
foreach (string item in lstTugIds)
{
TugDataModel.Scheduler aScheduler = new Scheduler();
aScheduler.OrderServiceID = idx;
aScheduler.TugID = Util.toint(item);
aScheduler.RopeUsed = "";
aScheduler.RopeNum = 0;
aScheduler.Remark = "";
aScheduler.IsCaptainConfirm = "";
aScheduler.InformCaptainTime = "";
aScheduler.CaptainConfirmTime = "";
aScheduler.JobStateID = 32;
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
aScheduler.CreateDate = aScheduler.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
aScheduler.UserDefinedCol1 = "";
aScheduler.UserDefinedCol2 = "";
aScheduler.UserDefinedCol3 = "";
aScheduler.UserDefinedCol4 = "";
aScheduler.UserDefinedCol9 = "";
aScheduler.UserDefinedCol10 = "";
lstSchedulers.Add(aScheduler);
}
db.Scheduler.AddRange(lstSchedulers);
if (0 < db.SaveChanges())
{
OrderService os = db.OrderService.FirstOrDefault(u => u.IDX == idx);
os.JobStateID = 115;
db.Entry(os).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
}
#endregion
}
trans.Complete();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception ex)
{
trans.Dispose();
throw ex;
//return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
}
#endregion Edit
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
public ActionResult AddEditScheduler()
{
this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.Scheduler aScheduler = new Scheduler();
aScheduler.ArrivalBaseTime = Request.Form["ArrivalBaseTime"].Trim();
aScheduler.ArrivalShipSideTime = Request.Form["ArrivalShipSideTime"].Trim();
aScheduler.CaptainConfirmTime = Request.Form["CaptainConfirmTime"].Trim();
aScheduler.DepartBaseTime = Request.Form["DepartBaseTime"].Trim();
aScheduler.InformCaptainTime = Request.Form["InformCaptainTime"].Trim();
aScheduler.WorkCommencedTime = Request.Form["WorkCommencedTime"].Trim();
aScheduler.WorkCompletedTime = Request.Form["WorkCompletedTime"].Trim();
aScheduler.JobStateID = Util.toint(Request.Form["JobStateID"].Trim()); ;
//aScheduler.OrderID = Util.toint(Request.Form["OrderID"].Trim());
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
aScheduler.Remark = Request.Form["Remark"].Trim(); ;
//aScheduler.RopeUsed = Request.Form["RopeUsed"].Trim();
//if (aScheduler.RopeUsed.Equals("是"))
// aScheduler.RopeNum = Util.toint(Request.Form["RopeNum"].Trim());
//else
// aScheduler.RopeNum = 0;
//aScheduler.ServiceNatureID = Util.toint(Request.Form["ServiceNatureLabel"].Trim().Split('~')[0]);
aScheduler.TugID = Util.toint(Request.Form["TugID"].Trim());
aScheduler.CreateDate = aScheduler.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
aScheduler.UserDefinedCol1 = Request.Form["UserDefinedCol1"].Trim();
aScheduler.UserDefinedCol2 = Request.Form["UserDefinedCol2"].Trim();
aScheduler.UserDefinedCol3 = Request.Form["UserDefinedCol3"].Trim();
aScheduler.UserDefinedCol4 = Request.Form["UserDefinedCol4"].Trim();
if (Request.Form["UserDefinedCol5"].Trim() != "")
aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
if (Request.Form["UserDefinedCol6"].Trim() != "")
aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
if (Request.Form["UserDefinedCol7"].Trim() != "")
aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
if (Request.Form["UserDefinedCol8"].Trim() != "")
aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
aScheduler.UserDefinedCol9 = Request.Form["UserDefinedCol9"].Trim();
aScheduler.UserDefinedCol10 = Request.Form["UserDefinedCol10"].Trim();
aScheduler = db.Scheduler.Add(aScheduler);
db.SaveChanges();
{
//更新订单状态
//OrderInfor tmpOrder = db.OrderInfor.Where(u => u.IDX == aScheduler.OrderID).FirstOrDefault();
//if(tmpOrder != null)
//{
// tmpOrder.WorkStateID = 3; //已排船
// db.Entry(tmpOrder).State = System.Data.Entity.EntityState.Modified;
// db.SaveChanges();
//}
}
{
//OrderService os = db.OrderService.Where(u => u.OrderID == aScheduler.OrderID && u.ServiceNatureID == aScheduler.ServiceNatureID).FirstOrDefault();
//if (os == null)
//{
// os = new OrderService();
// os.CreateDate = os.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// os.OrderID = aScheduler.OrderID;
// os.OwnerID = -1;
// os.ServiceNatureID = aScheduler.ServiceNatureID;
// os.ServiceWorkDate = Request.Form["ServiceWorkDate"].Trim();
// os.ServiceWorkPlace = Request.Form["ServiceWorkPlace"].Trim();
// os.UserID = Session.GetDataFromSession<int>("userid");
// os = db.OrderService.Add(os);
// db.SaveChanges();
//}
//else
//{
// os.ServiceWorkDate = Request.Form["ServiceWorkDate"].Trim();
// os.ServiceWorkPlace = Request.Form["ServiceWorkPlace"].Trim();
// os.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// db.Entry(os).State = System.Data.Entity.EntityState.Modified;
// db.SaveChanges();
//}
}
var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
return Json(ret);
}
}
catch (Exception)
{
var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
//Response.Write(@Resources.Common.EXCEPTION_MESSAGE);
return Json(ret);
}
}
#endregion Add
#region Edit
if (Request.Form["oper"].Equals("edit"))
{
try
{
TugDataEntities db = new TugDataEntities();
int idx = Util.toint(Request.Form["IDX"].Trim());
Scheduler aScheduler = db.Scheduler.Where(u => u.IDX == idx).FirstOrDefault();
if (aScheduler == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
//aScheduler.ArrivalBaseTime = Request.Form["ArrivalBaseTime"].Trim();
//aScheduler.ArrivalShipSideTime = Request.Form["ArrivalShipSideTime"].Trim();
//aScheduler.CaptainConfirmTime = Request.Form["CaptainConfirmTime"].Trim();
//aScheduler.DepartBaseTime = Request.Form["DepartBaseTime"].Trim();
//aScheduler.InformCaptainTime = Request.Form["InformCaptainTime"].Trim();
//aScheduler.WorkCommencedTime = Request.Form["WorkCommencedTime"].Trim();
//aScheduler.WorkCompletedTime = Request.Form["WorkCompletedTime"].Trim();
//aScheduler.JobStateID = Util.toint(Request.Form["JobStateID"].Trim()); ;
//aScheduler.OrderID = Util.toint(Request.Form["OrderID"].Trim());
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
aScheduler.Remark = Request.Form["Remark"].Trim();
aScheduler.IsCaptainConfirm = Request.Form["IsCaptainConfirm"].Trim();
//aScheduler.RopeUsed = Request.Form["RopeUsed"].Trim();
//if (aScheduler.RopeUsed.Equals("是"))
// aScheduler.RopeNum = Util.toint(Request.Form["RopeNum"].Trim());
//else
// aScheduler.RopeNum = 0;
//aScheduler.ServiceNatureID = Util.toint(Request.Form["ServiceNatureLabel"].Trim().Split('~')[0]);
//aScheduler.TugID = Util.toint(Request.Form["TugID"].Trim());
aScheduler.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//aScheduler.UserDefinedCol1 = Request.Form["UserDefinedCol1"].Trim();
//aScheduler.UserDefinedCol2 = Request.Form["UserDefinedCol2"].Trim();
//aScheduler.UserDefinedCol3 = Request.Form["UserDefinedCol3"].Trim();
//aScheduler.UserDefinedCol4 = Request.Form["UserDefinedCol4"].Trim();
//if (Request.Form["UserDefinedCol5"].Trim() != "")
// aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
//if (Request.Form["UserDefinedCol6"].Trim() != "")
// aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
//if (Request.Form["UserDefinedCol7"].Trim() != "")
// aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
//if (Request.Form["UserDefinedCol8"].Trim() != "")
// aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
//aScheduler.UserDefinedCol9 = Request.Form["UserDefinedCol9"].Trim();
//aScheduler.UserDefinedCol10 = Request.Form["UserDefinedCol10"].Trim();
db.Entry(aScheduler).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
{
//OrderService os = db.OrderService.Where(u => u.OrderID == aScheduler.OrderID && u.ServiceNatureID == aScheduler.ServiceNatureID).FirstOrDefault();
//if (os == null)
//{
// os = new OrderService();
// os.CreateDate = os.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// os.OrderID = aScheduler.OrderID;
// os.OwnerID = -1;
// os.ServiceNatureID = aScheduler.ServiceNatureID;
// os.ServiceWorkDate = Request.Form["ServiceWorkDate"].Trim();
// os.ServiceWorkPlace = Request.Form["ServiceWorkPlace"].Trim();
// os.UserID = Session.GetDataFromSession<int>("userid");
// os = db.OrderService.Add(os);
// db.SaveChanges();
//}
//else
//{
// os.ServiceWorkDate = Request.Form["ServiceWorkDate"].Trim();
// os.ServiceWorkPlace = Request.Form["ServiceWorkPlace"].Trim();
// os.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// db.Entry(os).State = System.Data.Entity.EntityState.Modified;
// db.SaveChanges();
//}
}
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception exp)
{
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
#endregion Edit
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
//判断订单下的服务是否有已完工
public ActionResult IsWanGong()
{
var f = Request.Form;
bool IsWanGong = false;
//int idx = Util.toint(Request.Form["orderId"]);
string oderMark = Request.Form["ordermark"];
TugDataEntities db = new TugDataEntities();
//System.Linq.Expressions.Expression<Func<V_OrderService_Scheduler, bool>> exps = u => u.OrderID == idx;
System.Linq.Expressions.Expression<Func<V_OrderService, bool>> exps = u => u.UserDefinedCol1 == oderMark & (u.ServiceJobStateLabel == "已完工" || u.ServiceJobStateValue=="2");
List<V_OrderService> objs = db.V_OrderService.Where(exps).Select(u => u).ToList<V_OrderService>();
if (objs.Count != 0)
{
IsWanGong = true; //已有排船信息
return Json(new { code = Resources.Common.SUCCESS_CODE, message = IsWanGong });
}
else
{
return Json(new { code = Resources.Common.SUCCESS_CODE, message = IsWanGong });
}
}
public ActionResult GetUnCompleteServiceState(bool _search, string sidx, string sord, int page, int rows)
{
this.Internationalization();
//string s = Request.QueryString[6];
try
{
TugDataEntities db = new TugDataEntities();
////List<V_OrderService> objs = db.V_OrderService.Where(u => u.ServiceJobStateLabel!="已完工").Select(u => u).OrderByDescending(u => u.ServiceWorkDate).OrderByDescending(u=>u.ServiceWorkTime).ToList<V_OrderService>();
//List<V_OrderService> objs = db.V_OrderService.Where(u => u.ServiceJobStateLabel != "已完工").Select(u => u).OrderByDescending(u => u.ServiceWorkDate).ThenByDescending(u => u.ServiceWorkTime).ToList<V_OrderService>();
//int totalRecordNum = objs.Count;
//if (page != 0 && totalRecordNum % rows == 0) page -= 1;
//int pageSize = rows;
//int totalPageNum = (int)Math.Ceiling((double)totalRecordNum / pageSize);
////List<V_OrderService> page_V_OrderServices = V_OrderServices.Skip((page - 1) * rows).Take(rows).OrderBy(u => u.IDX).ToList<V_OrderService>();
//var jsonData = new { page = page, records = totalRecordNum, total = totalPageNum, rows = objs };
//return Json(jsonData, JsonRequestBehavior.AllowGet);
if (_search == true)
{
string searchOption = Request.QueryString["filters"];
//List<V_OrderService> objs = db.V_OrderService.Where(u => u.ServiceJobStateLabel != "已完工").Select(u => u)
// .OrderByDescending(u => u.ServiceWorkDate).ThenByDescending(u => u.ServiceWorkTime).ToList<V_OrderService>();
List<V_OrderService> objs = TugBusinessLogic.Module.OrderLogic.SearchForServiceScheduler2(sidx, sord, searchOption);
int totalRecordNum = objs.Count;
if (page != 0 && totalRecordNum % rows == 0) page -= 1;
int pageSize = rows;
int totalPageNum = (int)Math.Ceiling((double)totalRecordNum / pageSize);
List<V_OrderService> page_orders = objs.Skip((page - 1) * rows).Take(rows).ToList<V_OrderService>();
var jsonData = new { page = page, records = totalRecordNum, total = totalPageNum, rows = page_orders };
return Json(jsonData, JsonRequestBehavior.AllowGet);
//return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE }, JsonRequestBehavior.AllowGet);
}
else
{
//List<V_OrderInfor> orders = db.V_OrderInfor.Select(u => u).OrderByDescending(u => u.IDX).ToList<V_OrderInfor>();
//List<V_OrderService> objs = db.V_OrderService.Where(u => u.ServiceJobStateLabel != "已完工")
// .Select(u => u).OrderByDescending(u => u.ServiceWorkDate).ThenByDescending(u => u.ServiceWorkTime).ToList<V_OrderService>();
List<V_OrderService> objs = TugBusinessLogic.Module.OrderLogic.LoadDataForServiceScheduler2(sidx, sord);
int totalRecordNum = objs.Count;
if (page != 0 && totalRecordNum % rows == 0) page -= 1;
int pageSize = rows;
int totalPageNum = (int)Math.Ceiling((double)totalRecordNum / pageSize);
List<V_OrderService> page_orders = objs.Skip((page - 1) * rows).Take(rows).ToList<V_OrderService>();
var jsonData = new { page = page, records = totalRecordNum, total = totalPageNum, rows = page_orders };
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
}
catch (Exception)
{
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
public ActionResult GetTugRelatedOrders(bool _search, string sidx, string sord, int page, int rows, int tugId, string workDate)
{
this.Internationalization();
try
{
TugDataEntities db = new TugDataEntities();
if (_search == true)
{
string s = Request.QueryString["filters"];
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE }, JsonRequestBehavior.AllowGet);
}
else
{
//string now = DateTime.Now.ToString("yyyy-MM-dd");
List<V_OrderScheduler> schedulers = db.V_OrderScheduler.Where(u => u.TugID == tugId && u.ServiceWorkDate == workDate)
.Select(u => u).OrderByDescending(u => u.IDX).ToList<V_OrderScheduler>();
//List<V_OrderScheduler> orders = TugBusinessLogic.Module.OrderLogic.LoadDataForOrderScheduler(sidx, sord, orderId);
List<V_OrderInfor> orders = new List<V_OrderInfor>();
if (schedulers != null)
{
foreach (V_OrderScheduler item in schedulers)
{
orders.AddRange(db.V_OrderInfor.Where(u => u.IDX == item.OrderID).Select(u => u).OrderByDescending(u => u.IDX).ToList<V_OrderInfor>());
};
}
int totalRecordNum = orders.Count;
if (page != 0 && totalRecordNum % rows == 0) page -= 1;
int pageSize = rows;
int totalPageNum = (int)Math.Ceiling((double)totalRecordNum / pageSize);
//List<V_OrderScheduler> page_orders = orders.Skip((page - 1) * rows).Take(rows).ToList<V_OrderScheduler>();
var jsonData = new { page = page, records = totalRecordNum, total = totalPageNum, rows = orders };
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
}
catch (Exception)
{
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }, JsonRequestBehavior.AllowGet);
}
}
public ActionResult GetServiceState(bool _search, string sidx, string sord, int page, int rows)
{
this.Internationalization();
//string s = Request.QueryString[6];
try
{
TugDataEntities db = new TugDataEntities();
//List<V_OrderService> objs = db.V_OrderService.Where(u => u.ServiceJobStateLabel!="已完工").Select(u => u).OrderByDescending(u => u.ServiceWorkDate).OrderByDescending(u=>u.ServiceWorkTime).ToList<V_OrderService>();
List<V_OrderService> objs = db.V_OrderService.Select(u => u).OrderByDescending(u => u.ServiceWorkDate).ThenByDescending(u => u.ServiceWorkTime).ToList<V_OrderService>();
int totalRecordNum = objs.Count;
if (page != 0 && totalRecordNum % rows == 0) page -= 1;
int pageSize = rows;
int totalPageNum = (int)Math.Ceiling((double)totalRecordNum / pageSize);
//List<V_OrderService> page_V_OrderServices = V_OrderServices.Skip((page - 1) * rows).Take(rows).OrderBy(u => u.IDX).ToList<V_OrderService>();
var jsonData = new { page = page, records = totalRecordNum, total = totalPageNum, rows = objs };
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
public ActionResult AddEdit()
{
this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.OrderInfor aOrder = new OrderInfor();
aOrder.Code = TugBusinessLogic.Utils.AutoGenerateOrderSequenceNo();
aOrder.CreateDate = aOrder.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
aOrder.CustomerID = Util.toint(Request.Form["CustomerID"]);
aOrder.CustomerName = Request.Form["CustomerName"].Trim();
aOrder.OrdDate = Request.Form["OrdDate"].Trim();
//aOrder.WorkDate = Request.Form["WorkDate"].Trim();
//aOrder.WorkTime = Request.Form["WorkTime"].Trim();
//aOrder.EstimatedCompletionTime = Request.Form["EstimatedCompletionTime"].Trim();
aOrder.IsGuest = "否"; // Request.Form["IsGuest"].Trim();
aOrder.LinkMan = Request.Form["LinkMan"].Trim();
aOrder.LinkPhone = Request.Form["LinkPhone"].Trim();
aOrder.LinkEmail = Request.Form["LinkEmail"].Trim();
//if (Request.Form["BigTugNum"].Trim() != "")
// aOrder.BigTugNum = Util.toint(Request.Form["BigTugNum"].Trim());
//if (Request.Form["MiddleTugNum"].Trim() != "")
// aOrder.MiddleTugNum = Util.toint(Request.Form["MiddleTugNum"].Trim());
//if (Request.Form["SmallTugNum"].Trim() != "")
// aOrder.SmallTugNum = Util.toint(Request.Form["SmallTugNum"].Trim());
aOrder.OwnerID = -1;
aOrder.Remark = Request.Form["Remark"].Trim();
aOrder.ShipID = Util.toint(Request.Form["ShipID"].Trim());
aOrder.ShipName = Request.Form["ShipName"].Trim();
aOrder.UserID = Session.GetDataFromSession<int>("userid");
//aOrder.WorkPlace = Request.Form["WorkPlace"].Trim();
//Dictionary<string, string> dic = TugBusinessLogic.Utils.ResolveServices(Request.Form["ServiceNatureNames"].Trim());
//aOrder.ServiceNatureIDS = dic["ids"];
//aOrder.ServiceNatureNames = dic["labels"];
//aOrder.WorkStateID = Util.toint(Request.Form["WorkStateID"].Trim());
aOrder.WorkStateID = 2; //CustomField表里面的OrderInfor.WorkStateID的IDX
aOrder.UserDefinedCol1 = Request.Form["UserDefinedCol1"].Trim();
aOrder.UserDefinedCol2 = Request.Form["UserDefinedCol2"].Trim();
aOrder.UserDefinedCol3 = Request.Form["UserDefinedCol3"].Trim();
aOrder.UserDefinedCol4 = Request.Form["UserDefinedCol4"].Trim();
if (Request.Form["UserDefinedCol5"].Trim() != "")
aOrder.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
if (Request.Form["UserDefinedCol6"].Trim() != "")
aOrder.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
if (Request.Form["UserDefinedCol7"].Trim() != "")
aOrder.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
if (Request.Form["UserDefinedCol8"].Trim() != "")
aOrder.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
aOrder.UserDefinedCol9 = Request.Form["UserDefinedCol9"].Trim();
aOrder.UserDefinedCol10 = Request.Form["UserDefinedCol10"].Trim();
aOrder = db.OrderInfor.Add(aOrder);
db.SaveChanges();
var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
return Json(ret);
}
}
catch (Exception)
{
var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
//Response.Write(@Resources.Common.EXCEPTION_MESSAGE);
return Json(ret);
}
}
#endregion Add
#region Edit
if (Request.Form["oper"].Equals("edit"))
{
try
{
TugDataEntities db = new TugDataEntities();
int idx = Util.toint(Request.Form["IDX"].Trim());
OrderInfor aOrder = db.OrderInfor.Where(u => u.IDX == idx).FirstOrDefault();
if (aOrder == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
aOrder.CustomerID = Util.toint(Request.Form["CustomerID"].Trim());
aOrder.CustomerName = Request.Form["CustomerName"].Trim();
aOrder.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//aOrder.IsGuest = Request.Form["IsGuest"].Trim();
aOrder.LinkMan = Request.Form["LinkMan"].Trim();
aOrder.LinkPhone = Request.Form["LinkPhone"].Trim();
aOrder.LinkEmail = Request.Form["LinkEmail"].Trim();
aOrder.OrdDate = Request.Form["OrdDate"].Trim();
//aOrder.WorkDate = Request.Form["WorkDate"].Trim();
//aOrder.WorkTime = Request.Form["WorkTime"].Trim();
//aOrder.EstimatedCompletionTime = Request.Form["EstimatedCompletionTime"].Trim();
aOrder.ShipID = Util.toint(Request.Form["ShipID"].Trim());
aOrder.ShipName = Request.Form["ShipName"].Trim();
//if (Request.Form["BigTugNum"].Trim() != "")
// aOrder.BigTugNum = Util.toint(Request.Form["BigTugNum"].Trim());
//if (Request.Form["MiddleTugNum"].Trim() != "")
// aOrder.MiddleTugNum = Util.toint(Request.Form["MiddleTugNum"].Trim());
//if (Request.Form["SmallTugNum"].Trim() != "")
// aOrder.SmallTugNum = Util.toint(Request.Form["SmallTugNum"].Trim());
//aOrder.WorkPlace = Request.Form["WorkPlace"].Trim();
//Dictionary<string, string> dic = TugBusinessLogic.Utils.ResolveServices(Request.Form["ServiceNatureNames"].Trim());
//aOrder.ServiceNatureIDS = dic["ids"];
//aOrder.ServiceNatureNames = dic["labels"];
//aOrder.WorkStateID = Util.toint(Request.Form["WorkStateID"].Trim());
aOrder.Remark = Request.Form["Remark"].Trim();
aOrder.UserDefinedCol1 = Request.Form["UserDefinedCol1"].Trim();
aOrder.UserDefinedCol2 = Request.Form["UserDefinedCol2"].Trim();
aOrder.UserDefinedCol3 = Request.Form["UserDefinedCol3"].Trim();
aOrder.UserDefinedCol4 = Request.Form["UserDefinedCol4"].Trim();
if (Request.Form["UserDefinedCol5"].Trim() != "")
aOrder.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
if (Request.Form["UserDefinedCol6"].Trim() != "")
aOrder.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
if (Request.Form["UserDefinedCol7"].Trim() != "")
aOrder.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
if (Request.Form["UserDefinedCol8"].Trim() != "")
aOrder.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
aOrder.UserDefinedCol9 = Request.Form["UserDefinedCol9"].Trim();
aOrder.UserDefinedCol10 = Request.Form["UserDefinedCol10"].Trim();
db.Entry(aOrder).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception exp)
{
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
#endregion Edit
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
public ActionResult GetServiceLocations(string term)
{
TugDataEntities db = new TugDataEntities();
List<CustomField> customers = db.CustomField.Where(u => u.CustomName == "OrderService.Location" && u.CustomLabel.ToLower().Trim().Contains(term.Trim().ToLower()))
.Select(u => u).OrderBy(u => u.CustomLabel).ToList<CustomField>();
List<object> list = new List<object>();
if (customers != null)
{
foreach (CustomField item in customers)
{
list.Add(new { CustomerID = item.IDX, CustomerName1 = item.CustomLabel });
}
}
var jsonData = new { list = list };
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 获得拖轮的服务项
/// </summary>
/// <returns></returns>
public ActionResult GetServices()
{
TugDataEntities db = new TugDataEntities();
List<CustomField> list = db.CustomField.Where(u => u.CustomName == "OrderInfor.ServiceNatureID").OrderBy(u => u.CustomValue).ToList<CustomField>();
var jsonData = new { list = list };
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
public ActionResult GetLinkMans(string term)
{
TugDataEntities db = new TugDataEntities();
List<LinkMan> mans = db.LinkMan.Where(u => u.LinkManName.ToLower().Trim().Contains(term.Trim().ToLower()))
.Select(u => u).OrderBy(u => u.LinkManName).ToList<LinkMan>();
List<object> list = new List<object>();
if (mans != null)
{
foreach (LinkMan item in mans)
{
list.Add(new { LinkManID = item.IDX, LinkManName = item.LinkManName, LinkPhone = item.LinkPhone,LinkEmail = item.LinkEmail });
}
}
var jsonData = new { list = list };
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
public ActionResult GetServiceSubSchedulerData(bool _search, string sidx, string sord, int page, int rows, int orderServiceId)
{
this.Internationalization();
try
{
//
TugDataEntities db = new TugDataEntities();
if (_search == true)
{
string s = Request.QueryString["filters"];
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE }, JsonRequestBehavior.AllowGet);
}
else
{
//List<V_OrderScheduler> orders = db.V_OrderScheduler.Where(u => u.OrderID == orderId).Select(u => u).OrderByDescending(u => u.IDX).ToList<V_OrderScheduler>();
List<V_OrderScheduler> orders = TugBusinessLogic.Module.OrderLogic.LoadDataForServiceScheduler(sidx, sord, orderServiceId);
int totalRecordNum = orders.Count;
if (page != 0 && totalRecordNum % rows == 0) page -= 1;
int pageSize = rows;
int totalPageNum = (int)Math.Ceiling((double)totalRecordNum / pageSize);
List<V_OrderScheduler> page_orders = orders.Skip((page - 1) * rows).Take(rows).ToList<V_OrderScheduler>();
var jsonData = new { page = page, records = totalRecordNum, total = totalPageNum, rows = page_orders };
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
}
catch (Exception)
{
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }, JsonRequestBehavior.AllowGet);
}
}
public ActionResult GetOrder(string ordermark)
{
try
{
TugDataEntities db = new TugDataEntities();
OrderInfor aOrder = db.OrderInfor.Where(u => u.UserDefinedCol1 == ordermark).FirstOrDefault();
if (aOrder != null)
{
return Json(new { CustomerID = aOrder.CustomerID, CustomerName = aOrder.CustomerName, OrdDate = aOrder.OrdDate,
ShipID = aOrder.ShipID, ShipName = aOrder.ShipName, LinkMan =aOrder.LinkMan,LinkPhone=aOrder.LinkPhone,
LinkEmail = aOrder.LinkEmail,
Remark=aOrder.Remark}, JsonRequestBehavior.AllowGet);
}
else
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_CODE }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception)
{
throw;
}
}
public ActionResult GetTugsBySimpleName(string value)
{
TugDataEntities db = new TugDataEntities();
List<TugInfor> source = db.TugInfor.Where(u => u.SimpleName.Contains(value))
.OrderBy(u => u.Name1).ToList<TugInfor>();
var jsonData = new { list = source };
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
public ActionResult GetOrderService(int orderServiceId)
{
TugDataEntities db = new TugDataEntities();
V_OrderService os = db.V_OrderService.Where(u => u.OrderServiceID == orderServiceId).FirstOrDefault();
if (os != null)
{
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE, order_service = os }, JsonRequestBehavior.AllowGet);
}
else
{
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE, order_service = "" }, JsonRequestBehavior.AllowGet);
}
}
public ActionResult IsScheduler()
{
var f = Request.Form;
bool IsScheduler = false;
//int idx = Util.toint(Request.Form["orderId"]);
string oderMark = Request.Form["ordermark"];
TugDataEntities db = new TugDataEntities();
//System.Linq.Expressions.Expression<Func<V_OrderService_Scheduler, bool>> exps = u => u.OrderID == idx;
System.Linq.Expressions.Expression<Func<V_OrderService_Scheduler, bool>> exps = u => u.UserDefinedCol1 == oderMark;
List<V_OrderService_Scheduler> schedulerInfor = db.V_OrderService_Scheduler.Where(exps).Select(u => u).ToList<V_OrderService_Scheduler>();
if (schedulerInfor.Count != 0)
{
IsScheduler = true; //已有排船信息
return Json(new { code = Resources.Common.SUCCESS_CODE, message = IsScheduler });
}
else
{
return Json(new { code = Resources.Common.SUCCESS_CODE, message = IsScheduler });
}
}
public ActionResult GetOrderServiceData(string ordermark)
{
try
{
TugDataEntities db = new TugDataEntities();
List<V_OrderService> list = db.V_OrderService.Where(u => u.UserDefinedCol1 == ordermark).OrderBy(u => u.OrderServiceID).ToList<V_OrderService>();
List<string[]> jsonData = new List<string[]>();
foreach (var itm in list)
{
string[] sev = new string[7] { itm.ServiceNatureLabel, itm.ServiceWorkDate,itm.ServiceWorkTime, itm.BigTugNum.ToString(),itm.MiddleTugNum.ToString(),itm.SmallTugNum.ToString(),itm.ServiceWorkPlace};
jsonData.Add(sev);
}
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public ActionResult RejectOrderServiceToScheduler(string orderIds)
{
List<string> list = orderIds.Split(',').ToList();
List<int> rejectedOrderIds = new List<int>();
if (list != null)
{
foreach (string item in list)
{
int rowId = Convert.ToInt32(item.Split(':')[0]);
int orderId = Convert.ToInt32(item.Split(':')[1]);
int ret = TugBusinessLogic.Module.OrderLogic.HasBilling(orderId);
if (ret != -1)
{
return Json(new
{
code = Resources.Common.SUCCESS_CODE,
message = Resources.Common.SUCCESS_MESSAGE,
has_invoice = ret,
rowId = rowId
}, JsonRequestBehavior.AllowGet);
}
else
{
rejectedOrderIds.Add(orderId);
}
}
}
//int ret = TugBusinessLogic.Module.OrderLogic.HasBilling(orderId);
//沒有帳單，可以駁回
//if (ret == -1)
{
using (System.Transactions.TransactionScope trans = new System.Transactions.TransactionScope())
{
try
{
TugDataEntities db = new TugDataEntities();
foreach (var orderId in rejectedOrderIds)
{
var lstOrderService = db.OrderService.Where(u => u.OrderID == orderId).ToList();
if (lstOrderService != null)
{
foreach (var item in lstOrderService)
{
var lstScheduler = db.Scheduler.Where(u => u.OrderServiceID == item.IDX).ToList();
if (lstScheduler != null)
{
foreach (var item2 in lstScheduler)
{
item2.DepartBaseTime = "";
item2.ArrivalBaseTime = "";
item2.RopeUsed = "否";
item2.Remark = "";
db.Entry(item2).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
item.JobStateID = 124;
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
//订单状态该为未排船
{
OrderInfor oi = db.OrderInfor.FirstOrDefault(u => u.IDX == orderId);
if (oi != null)
{
oi.WorkStateID = 2; //所有服务都未完成，因此订单状态变成“未排船”
oi.UserDefinedCol4 = "0"; //0是所有时间未录入完成
db.Entry(oi).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
var ord_services = db.OrderService.Where(u => u.OrderID == orderId).ToList();
if (ord_services != null)
{
foreach (var item in ord_services)
{
item.UserDefinedCol4 = "0"; //0是所有时间未录入完成
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
}
}
}
trans.Complete();
}
catch(Exception ex)
{
trans.Dispose();
return Json(new
{
code = Resources.Common.EXCEPTION_CODE,
message = Resources.Common.EXCEPTION_MESSAGE,
}, JsonRequestBehavior.AllowGet);
}
}
}
return Json(new
{
code = Resources.Common.SUCCESS_CODE,
message = Resources.Common.SUCCESS_MESSAGE,
has_invoice = -1
}, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 获取订单的服务项
/// </summary>
/// <param name="orderId">订单ID</param>
/// <returns></returns>
public ActionResult GetOrderServices(int orderId)
{
try
{
TugDataEntities db = new TugDataEntities();
List<MyOrderService> orderServices = db.V_OrderService.Where(u => u.OrderID == orderId).OrderBy(u => u.OrderServiceID)
.Select(u => new MyOrderService
{
OrderServiceId = u.OrderServiceID,
ServiceNatureId = (int)u.ServiceNatureID,
ServiceNatureValue = u.ServiceNatureValue,
ServiceNatureLabel = u.ServiceNatureLabel,
ServiceWorkDate = u.ServiceWorkDate,
ServiceWorkTime = u.ServiceWorkTime,
ServiceEstimatedCompletionTime = u.EstimatedCompletionTime,
ServiceWorkPlace = u.ServiceWorkPlace
}).ToList<MyOrderService>();
var jsonData = new { services = orderServices };
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
}
/// <summary>
/// 服务修改
/// </summary>
/// <returns></returns>
public ActionResult AddEditService()
{
this.Internationalization();
#region Edit
if (Request.Form["oper"].Equals("edit"))
{
try
{
TugDataEntities db = new TugDataEntities();
int idx = Util.toint(Request.Form["OrderServiceID"].Trim());
OrderService aScheduler = db.OrderService.Where(u => u.IDX == idx).FirstOrDefault();
if (aScheduler == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
//aScheduler.ServiceNatureID = TugBusinessLogic.Module.Util.toint(Request.Form["ServiceNatureID"]);
aScheduler.ServiceWorkDate = Request.Form["ServiceWorkDate"];
aScheduler.ServiceWorkPlace = Request.Form["ServiceWorkPlace"];
aScheduler.ServiceWorkTime = Request.Form["ServiceWorkTime"];
aScheduler.BigTugNum = Util.toint(Request.Form["BigTugNum"].Trim());
aScheduler.MiddleTugNum = Util.toint(Request.Form["MiddleTugNum"].Trim());
aScheduler.SmallTugNum = Util.toint(Request.Form["SmallTugNum"].Trim());
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
aScheduler.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
db.Entry(aScheduler).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception exp)
{
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
#endregion Edit
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
public ActionResult GetServiceDateAndPlace(int orderId, int serviceNatureId)
{
TugDataEntities db = new TugDataEntities();
OrderService os = db.OrderService.Where(u => u.OrderID == orderId && u.ServiceNatureID == serviceNatureId).FirstOrDefault();
if (os != null) {
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE, service_place = os.ServiceWorkPlace, service_date = os.ServiceWorkDate }, JsonRequestBehavior.AllowGet);
}
else
{
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE, service_place = "", service_date = DateTime.Now.ToString("yyyy-MM-dd") }, JsonRequestBehavior.AllowGet);
}
}
public ActionResult AddScheduler(int orderId, int orderServiceId, int serviceNatureId, string serviceWorkDate, string serviceWorkTime, string serviceWorkPlace, string tugId,
string isCaptainConfirm, string informCaptainTime, string captainConfirmTime, string ropeUsed, int ropeNum, string remark)
{
this.Internationalization();
try
{
TugDataEntities db = new TugDataEntities();
{
//插入多个调度到数据库
{
List<string> lstTugIds = tugId.Split(',').ToList();
if (lstTugIds != null && lstTugIds.Count > 0)
{
List<Scheduler> lstSchedulers = new List<Scheduler>();
foreach (string item in lstTugIds)
{
TugDataModel.Scheduler aScheduler = new Scheduler();
//aScheduler.OrderID = orderId;
//aScheduler.ServiceNatureID = serviceNatureId;
aScheduler.OrderServiceID = orderServiceId;
aScheduler.TugID = Util.toint(item);
aScheduler.RopeUsed = ropeUsed;
aScheduler.RopeNum = ropeNum;
aScheduler.Remark = remark;
aScheduler.IsCaptainConfirm = isCaptainConfirm;
aScheduler.InformCaptainTime = informCaptainTime;
aScheduler.CaptainConfirmTime = captainConfirmTime;
aScheduler.JobStateID = 32;
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
aScheduler.CreateDate = aScheduler.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
aScheduler.UserDefinedCol1 = "";
aScheduler.UserDefinedCol2 = "";
aScheduler.UserDefinedCol3 = "";
aScheduler.UserDefinedCol4 = "";
//if (Request.Form["UserDefinedCol5"].Trim() != "")
// aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
//if (Request.Form["UserDefinedCol6"].Trim() != "")
// aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
//if (Request.Form["UserDefinedCol7"].Trim() != "")
// aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
//if (Request.Form["UserDefinedCol8"].Trim() != "")
// aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
aScheduler.UserDefinedCol9 = "";
aScheduler.UserDefinedCol10 = "";
lstSchedulers.Add(aScheduler);
}
db.Scheduler.AddRange(lstSchedulers);
db.SaveChanges();
}
}
{
//更新订单状态
//OrderInfor tmpOrder = db.OrderInfor.Where(u => u.IDX == orderId).FirstOrDefault();
//if (tmpOrder != null)
//{
// tmpOrder.WorkStateID = 3; //已排船
// db.Entry(tmpOrder).State = System.Data.Entity.EntityState.Modified;
// db.SaveChanges();
//}
}
//更新服务状态
{
OrderService os = db.OrderService.Where(u => u.IDX == orderServiceId).FirstOrDefault();
if (os == null)
{
os = new OrderService();
os.CreateDate = os.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
os.OrderID = orderId;
os.OwnerID = -1;
os.ServiceNatureID = serviceNatureId;
os.ServiceWorkDate = serviceWorkDate;
os.ServiceWorkTime = serviceWorkTime;
os.ServiceWorkPlace = serviceWorkPlace;
os.JobStateID = 115;
os.UserID = Session.GetDataFromSession<int>("userid");
os = db.OrderService.Add(os);
db.SaveChanges();
}
else
{
os.ServiceWorkDate = serviceWorkDate;
os.ServiceWorkTime = serviceWorkTime;
os.ServiceWorkPlace = serviceWorkPlace;
os.JobStateID = 115;
os.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
db.Entry(os).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
return Json(ret);
}
}
catch (Exception)
{
var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
//Response.Write(@Resources.Common.EXCEPTION_MESSAGE);
return Json(ret);
}
}
public string GetServiceLabels()
{
string[] labels =null;//
int i = 0;
if (labels == null)
{
TugDataEntities db = new TugDataEntities();
List<CustomField> list = db.CustomField.Where(u => u.CustomName == "OrderInfor.ServiceNatureID").OrderBy(u => u.SortCode).ToList<CustomField>();
labels = new string[list.Count];
foreach (var itm in list)
{
labels[i] = itm.CustomLabel;
i++;
}
}
//return labels;
return JsonConvert.SerializeObject(labels);
}
