//这个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 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 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);
}
}
public ActionResult Delete()
{
this.Internationalization();
try
{
var f = Request.Form;
int idx = Util.toint(Request.Form["data[IDX]"]);
TugDataEntities db = new TugDataEntities();
CustomField custom = db.CustomField.FirstOrDefault(u => u.IDX == idx);
if (custom != null)
{
db.CustomField.Remove(custom);
db.SaveChanges();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
else
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
}
catch (Exception)
{
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
public ActionResult AddEditCustomerBillScheme(int custId)
{
//this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
//重名了
if (true == CheckBillingTemplateName(custId, Request.Form["BillingTemplateName"].Trim(), -1))
{
return Json(new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE });
}
else
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.BillingTemplate cstmer = new BillingTemplate();
cstmer.BillingTemplateCode = Request.Form["BillingTemplateCode"].Trim();
cstmer.BillingTemplateName = Request.Form["BillingTemplateName"].Trim();
cstmer.BillingTemplateTypeID = Util.toint(Request.Form["BillingTemplateTypeID"].Trim());
cstmer.CreateDate = cstmer.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
cstmer.CustomerID = custId; // Convert.ToInt32(customerId);
cstmer.TemplateCreditContent = Request.Form["TemplateCreditContent"].Trim();
cstmer.TimeTypeID = Util.toint(Request.Form["TimeTypeID"].Trim());
cstmer.Discount = Convert.ToDouble(Request.Form["Discount"].Trim());
cstmer.Remark = Request.Form["Remark"].Trim();
cstmer.OwnerID = -1;
cstmer.UserID = Session.GetDataFromSession<int>("userid");
cstmer.UserDefinedCol1 = Request.Form["UserDefinedCol1"].Trim();
cstmer.UserDefinedCol2 = Request.Form["UserDefinedCol2"].Trim();
cstmer.UserDefinedCol3 = Request.Form["UserDefinedCol3"].Trim();
cstmer.UserDefinedCol4 = Request.Form["UserDefinedCol4"].Trim();
if (Request.Form["UserDefinedCol5"].Trim() != "")
cstmer.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
if (Request.Form["UserDefinedCol6"].Trim() != "")
cstmer.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
if (Request.Form["UserDefinedCol7"].Trim() != "")
cstmer.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
if (Request.Form["UserDefinedCol8"].Trim() != "")
cstmer.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
cstmer.UserDefinedCol9 = Request.Form["UserDefinedCol9"].Trim();
cstmer.UserDefinedCol10 = Request.Form["UserDefinedCol10"].Trim();
cstmer = db.BillingTemplate.Add(cstmer);
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["BillingTemplateIDX"]);
BillingTemplate cstmer = db.BillingTemplate.Where(u => u.IDX == idx).FirstOrDefault();
if (cstmer == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
//重名了
if (true == CheckBillingTemplateName(Util.toint(Request.Form["CustomerID"].Trim()), Request.Form["BillingTemplateName"].Trim(), idx))
{
return Json(new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE });
}
else
{
cstmer.BillingTemplateCode = Request.Form["BillingTemplateCode"].Trim();
cstmer.BillingTemplateName = Request.Form["BillingTemplateName"].Trim();
cstmer.BillingTemplateTypeID = Util.toint(Request.Form["BillingTemplateTypeID"].Trim());
cstmer.CustomerID = Util.toint(Request.Form["CustomerID"].Trim());
cstmer.TemplateCreditContent = Request.Form["TemplateCreditContent"].Trim();
cstmer.TimeTypeID = Util.toint(Request.Form["TimeTypeID"].Trim());
cstmer.Discount = Convert.ToDouble(Request.Form["Discount"].Trim());
cstmer.ShipLength = (Request.Form["ShipLength"]);
cstmer.ShipTEUS = (Request.Form["ShipTEUS"]);
cstmer.ExpiryDate = Request.Form["ExpiryDate"].Trim();
cstmer.Remark = Request.Form["Remark"].Trim();
cstmer.OwnerID = -1;
cstmer.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
cstmer.UserID = Session.GetDataFromSession<int>("userid");
cstmer.UserDefinedCol1 = Request.Form["UserDefinedCol1"].Trim();
cstmer.UserDefinedCol2 = Request.Form["UserDefinedCol2"].Trim();
cstmer.UserDefinedCol3 = Request.Form["UserDefinedCol3"].Trim();
cstmer.UserDefinedCol4 = Request.Form["UserDefinedCol4"].Trim();
if (Request.Form["UserDefinedCol5"].Trim() != "")
cstmer.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
if (Request.Form["UserDefinedCol6"].Trim() != "")
cstmer.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
if (Request.Form["UserDefinedCol7"].Trim() != "")
cstmer.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
if (Request.Form["UserDefinedCol8"].Trim() != "")
cstmer.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
cstmer.UserDefinedCol9 = Request.Form["UserDefinedCol9"].Trim();
cstmer.UserDefinedCol10 = Request.Form["UserDefinedCol10"].Trim();
db.Entry(cstmer).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception)
{
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 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 RepealSubmit(Billing data)
{
int id = data.IDX;
int BillingType = 0;
int idx = Util.toint(Request.Form["data[IDX]"].Trim());
TugDataEntities db = new TugDataEntities();
System.Linq.Expressions.Expression<Func<Billing, bool>> exp = u => u.IDX == idx;
Billing billInfor = db.Billing.Where(exp).FirstOrDefault();
int Phase = Convert.ToInt32(billInfor.Phase);
int timeNo = Convert.ToInt32(billInfor.TimesNo);
int curUserId = Session.GetDataFromSession<int>("userid");
if (Phase > 1 || Phase == -1) //流程已进入审核环节或已完成全部审核，不能撤销
{
var ret = new { code = Resources.Common.ERROR_CODE, message = "流程已进入审核环节，不能撤销！" };
return Json(ret);
}
else
{
//更新Billing状态
billInfor.Phase = 0;
billInfor.Status = "已撤销提交";
db.Entry(billInfor).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
string billtype = billInfor.InvoiceType.ToString();
if (billtype == "特殊账单") BillingType = 1;
//修改訂單表
FinanceLogic.SetOrderServiceFlowingStatus(BillingType, idx, "否");
//写入Approve表
Approve addApprove = new Approve();
addApprove.BillingID = idx;
addApprove.FlowMark = billInfor.TimesNo;
addApprove.Phase = 0;
addApprove.Task = "创建";
addApprove.Accept = 3;
addApprove.PersonID = curUserId;
addApprove.UserID = curUserId;
addApprove.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
addApprove.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
addApprove = db.Approve.Add(addApprove);
db.SaveChanges();
return Json(new { 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 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 Add_EditOrder(string oper,string ordermark,int customerId, string customerName, string ordDate,
int shipId, string shipName, string linkMan, string linkPhone, string linkEmail, string remark,List<string[]> dataListFromTable)
{
//customerName中&符
customerName = customerName.Replace("~*~", "&");
TugDataModel.OrderInfor aOrder=null;
this.Internationalization();
using (System.Transactions.TransactionScope trans = new System.Transactions.TransactionScope())
{
try
{
TugDataEntities db = new TugDataEntities();
{
//判断客户名称是否存在
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("客戶名稱不存在！");
}
//判断客户船名称是否存在
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("客戶船名稱不存在！");
}
//获取服务项
System.Linq.Expressions.Expression<Func<OrderService, bool>> exp = u => u.UserDefinedCol1 == ordermark;
List<OrderService> entityos = db.OrderService.Where(exp).ToList();
//先刪除該訂單下的排船信息
for (int i = 0; i < entityos.Count(); i++)
{
int ordsrvid = Util.toint(entityos[i].IDX);
System.Linq.Expressions.Expression<Func<Scheduler, bool>> exp0 = u => u.OrderServiceID == ordsrvid;
var entitysch = db.Scheduler.Where(exp0);
entitysch.ToList().ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.Scheduler.RemoveRange(entitysch);
db.SaveChanges();
}
//先删除订单下的所有服务项
entityos.ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.OrderService.RemoveRange(entityos);
db.SaveChanges();
//删除订单
System.Linq.Expressions.Expression<Func<OrderInfor, bool>> exp2 = u => u.UserDefinedCol1 == ordermark;
var entityord = db.OrderInfor.Where(exp2);
entityord.ToList().ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.OrderInfor.RemoveRange(entityord);
db.SaveChanges();
//保存
//获取服务项
List<CustomField> listServ;
listServ = TugBusinessLogic.Utils.GetServices();
string mcode = TugBusinessLogic.Utils.AutoGenerateOrderSequenceNo();
for (int i = 0; i < dataListFromTable.Count - 1; i++)//最后一行空行
{
//保存订单
aOrder = new OrderInfor();
aOrder.Code = mcode;//TugBusinessLogic.Utils.AutoGenerateOrderSequenceNo();
aOrder.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
aOrder.HasInvoice = "否"; //没有账单
aOrder.HasInFlow = "否"; //没有在流程中
aOrder.IsGuest = "否";
//if (oper == "add")
//{
// aOrder = new OrderInfor();
// aOrder.Code = TugBusinessLogic.Utils.AutoGenerateOrderSequenceNo();
// aOrder.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// aOrder.HasInvoice = "否"; //没有账单
// aOrder.HasInFlow = "否"; //没有在流程中
// aOrder.IsGuest = "否";
//}
//else if (oper == "edit")
//{
// aOrder = db.OrderInfor.Where(u => u.IDX == orderId).FirstOrDefault();
//}
aOrder.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//aOrder.CustomerID = customerId;
aOrder.CustomerID = CustomerLogic.AutoAddCustomer("", customerName, "", "", linkMan, linkPhone, "", linkEmail, "", "", "", Session.GetDataFromSession<int>("userid"));
aOrder.CustomerName = customerName;
aOrder.OrdDate = ordDate;
aOrder.LinkMan = linkMan;
aOrder.LinkPhone = linkPhone;
aOrder.LinkEmail = linkEmail;
aOrder.OwnerID = -1;
aOrder.Remark = remark;
//aOrder.ShipID = shipId;
aOrder.ShipID = CustomerLogic.AutoAddCustomerShip((int)aOrder.CustomerID, shipName, "", "", "", "", "", "", "", "", Session.GetDataFromSession<int>("userid"));
aOrder.ShipName = shipName;
aOrder.UserID = Session.GetDataFromSession<int>("userid");
aOrder.WorkStateID = 2; //CustomField表里面的OrderInfor.WorkStateID的IDX 订单修改后订单改为未排船
aOrder.UserDefinedCol1 = mcode;
aOrder.UserDefinedCol2 = i.ToString();
aOrder.UserDefinedCol3 = dataListFromTable[i][0];
aOrder.UserDefinedCol4 = "";
//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 = "";
aOrder.UserDefinedCol10 = "";
aOrder = db.OrderInfor.Add(aOrder);
//if (oper == "add")
//{
// aOrder = db.OrderInfor.Add(aOrder);
//}
//else if (oper == "edit")
//{
// db.Entry(aOrder).State = System.Data.Entity.EntityState.Modified;
//}
db.SaveChanges();
//保存服务项
TugDataModel.OrderService obj = new OrderService();
obj.OrderID = aOrder.IDX;
string serName = dataListFromTable[i][0];
CustomField sv = listServ.Where(u => u.CustomLabel == serName).FirstOrDefault();
obj.ServiceNatureID = sv.IDX;
obj.ServiceWorkDate = TugBusinessLogic.Utils.CNDateTimeToDateTime(dataListFromTable[i][1]).ToString("yyyy-MM-dd");
obj.ServiceWorkTime = dataListFromTable[i][2];
//obj.EstimatedCompletionTime=
obj.ServiceWorkPlace = dataListFromTable[i][6];
obj.BigTugNum = Util.toint(dataListFromTable[i][3]);
obj.MiddleTugNum = Util.toint(dataListFromTable[i][4]);
obj.SmallTugNum = Util.toint(dataListFromTable[i][5]);
//obj.Remark = "";
obj.JobStateID = 114;
obj.HasBilling = "否";
obj.HasBillingInFlow = "否";
obj.OwnerID = -1;
obj.CreateDate = aOrder.CreateDate;
obj.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ;
obj.UserID = Session.GetDataFromSession<int>("userid");
obj.UserDefinedCol1 = mcode;
//obj.UserDefinedCol2 = "";
//obj.UserDefinedCol3 = "";
//obj.UserDefinedCol4 = "";
//if (Request.Form["UserDefinedCol5"] != "")
// obj.UserDefinedCol5 = Util.toint(Request.Form["UserDefinedCol5"]);
//obj.UserDefinedCol6 =;
//obj.UserDefinedCol7 =;
//obj.UserDefinedCol8 =;
//obj.UserDefinedCol9 = "";
//obj.UserDefinedCol10 = "";
obj = db.OrderService.Add(obj);
db.SaveChanges();
}
trans.Complete();
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)
{
trans.Dispose();
throw ex;
//var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
////Response.Write(@Resources.Common.EXCEPTION_MESSAGE);
//return Json(ret);
}
}
}
//删除拆分后的订单，一个订单一个服务
public ActionResult DeleteOrder_Service()
{
this.Internationalization();
using (TransactionScope trans = new TransactionScope())
{
try
{
var f = Request.Form;
int orderid = Util.toint(Request.Form["data[OrderID]"]);
int orderserviceid = Util.toint(Request.Form["data[OrderServiceID]"]);
TugDataEntities db = new TugDataEntities();
//System.Linq.Expressions.Expression<Func<V_OrderService_Scheduler, bool>> exps = u => u.UserDefinedCol1 == ordermark;
//List<V_OrderService_Scheduler> schedulerInfor = db.V_OrderService_Scheduler.Where(exps).Select(u => u).ToList<V_OrderService_Scheduler>();
//if (schedulerInfor.Count != 0)
//{
// return Json(new { code = Resources.Common.SUCCESS_CODE, message = "該訂單已排船，無法刪除！"});
//}
System.Linq.Expressions.Expression<Func<V_OrderService, bool>> exps = u => u.OrderID == orderid & (u.ServiceJobStateLabel == "已完工" || u.ServiceJobStateValue == "2");
List<V_OrderService> objs = db.V_OrderService.Where(exps).Select(u => u).ToList<V_OrderService>();
if (objs.Count != 0)
{
return Json(new { code = Resources.Common.SUCCESS_CODE, message = "該訂單的服务项已完工，無法刪除，如需刪除請先聯繫財務進行駁回操作!！" });//已完工
}
//获取服务项
System.Linq.Expressions.Expression<Func<OrderService, bool>> exp = u => u.OrderID == orderid;
List<OrderService> entityos = db.OrderService.Where(exp).ToList();
//先刪除該訂單下的排船信息
for (int i = 0; i < entityos.Count(); i++)
{
int ordsrvid = Util.toint(entityos[i].IDX);
System.Linq.Expressions.Expression<Func<Scheduler, bool>> exp0 = u => u.OrderServiceID == ordsrvid;
var entitysch = db.Scheduler.Where(exp0);
entitysch.ToList().ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.Scheduler.RemoveRange(entitysch);
db.SaveChanges();
}
//先删除订单下的所有服务项
entityos.ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.OrderService.RemoveRange(entityos);
db.SaveChanges();
//删除订单
System.Linq.Expressions.Expression<Func<OrderInfor, bool>> exp2 = u => u.IDX == orderid;
var entityord = db.OrderInfor.Where(exp2);
entityord.ToList().ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.OrderInfor.RemoveRange(entityord);
db.SaveChanges();
trans.Complete();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
catch (Exception)
{
trans.Dispose();
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
}
public ActionResult AddCustomer(string Code,string Name1,string Name2,string SimpleName,string ContactPerson,
string Telephone, string Fax, string Email, string Address, string MailCode, string Remark)
{
this.Internationalization();
try
{
TugDataEntities db = new TugDataEntities();
System.Linq.Expressions.Expression<Func<Customer, bool>> exp = u => u.Name1 == Name1;
Customer obj = db.Customer.Where(exp).FirstOrDefault();
if (obj != null)
{
throw new Exception("客户名称已存在！");
}
{
TugDataModel.Customer cstmer = new Customer();
cstmer.Code = Code;
cstmer.Name1 = Name1;
cstmer.Name2 = Name2;
cstmer.SimpleName = SimpleName;
cstmer.ContactPerson = ContactPerson;
cstmer.Telephone = Telephone;
cstmer.Fax = Fax;
cstmer.Email = Email;
cstmer.Address = Address;
cstmer.MailCode = MailCode;
cstmer.Remark = Remark;
cstmer.OwnerID = -1;
cstmer.CreateDate = cstmer.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ;//.ToString("yyyy-MM-dd");
cstmer.UserID = Session.GetDataFromSession<int>("userid");
cstmer.UserDefinedCol1 = "";
cstmer.UserDefinedCol2 = "";
cstmer.UserDefinedCol3 = "";
cstmer.UserDefinedCol4 = "";
//if (Request.Form["UserDefinedCol5"].Trim() != "")
// cstmer.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
//if (Request.Form["UserDefinedCol6"].Trim() != "")
// cstmer.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
//if (Request.Form["UserDefinedCol7"].Trim() != "")
// cstmer.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
//if (Request.Form["UserDefinedCol8"].Trim() != "")
// cstmer.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
cstmer.UserDefinedCol9 = "";
cstmer.UserDefinedCol10 = "";
cstmer = db.Customer.Add(cstmer);
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 AddEdit()
{
this.Internationalization();
//int idx = Util.toint(Request.Form["IDX"]);
//Fuelprice price = db.Fuelprice.Where(u => u.IDX == idx).FirstOrDefault();
#region Add
if (Request.Form["oper"].Equals("add"))
{
string CustomName = Request.Form["CustomName"].Trim();
string CustomValue = Request.Form["CustomLabel"].Trim();
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.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");
custom = db.CustomField.Add(custom);
db.SaveChanges();
var ret = new { code = Resources.Common.SUCCESS_CODE, message = 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"]);
CustomField customedit = db.CustomField.Where(u => u.IDX == idx).FirstOrDefault();
string oldLocation = customedit.CustomLabel;
string newLocation = Request.Form["CustomLabel"].Trim();
string CustomName = customedit.CustomName;
string CustomValue = Request.Form["CustomLabel"].Trim();
CustomField custom = db.CustomField.Where(u => u.CustomName == CustomName && u.CustomLabel==CustomValue).FirstOrDefault();
if (custom != null)
{
throw new Exception(CustomValue + "已存在！");
}
else
{
customedit.CustomLabel = CustomValue;
customedit.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd");
customedit.UserID = Session.GetDataFromSession<int>("userid");
db.Entry(customedit).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
var list = db.OrderService.Where(u => u.ServiceWorkPlace.Trim().ToLower() == oldLocation.Trim().ToLower()).Select(u => u).ToList();
if (list != null)
{
foreach (var item in list)
{
item.ServiceWorkPlace = newLocation.Trim();
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception ex)
{
throw ex;
}
}
#endregion Edit
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
public ActionResult AddEdit()
{
this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.Customer cstmer = new Customer();
cstmer.Code = Request.Form["Code"];
cstmer.Name1 = Request.Form["Name1"];
cstmer.Name2 = Request.Form["Name2"];
cstmer.SimpleName = Request.Form["SimpleName"];
cstmer.TypeID = Util.toint(Request.Form["TypeID"]);
cstmer.ContactPerson = Request.Form["ContactPerson"];
cstmer.Telephone = Request.Form["Telephone"];
cstmer.Fax = Request.Form["Fax"];
cstmer.Email = Request.Form["Email"];
cstmer.Address = Request.Form["Address"];
cstmer.MailCode = Request.Form["MailCode"];
cstmer.Remark = Request.Form["Remark"];
cstmer.OwnerID = -1;
cstmer.CreateDate = cstmer.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");;//.ToString("yyyy-MM-dd");
cstmer.UserID = Session.GetDataFromSession<int>("userid");
cstmer.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
cstmer.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
cstmer.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
cstmer.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
cstmer.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
cstmer.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
cstmer.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
cstmer.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
cstmer.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
cstmer.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
cstmer = db.Customer.Add(cstmer);
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
{
int idx = Util.toint(Request.Form["IDX"]);
string name1 = Request.Form["Name1"];
TugDataEntities db = new TugDataEntities();
System.Linq.Expressions.Expression<Func<Customer, bool>> exp = u => u.Name1 == name1 && u.IDX!=idx;
Customer obj = db.Customer.Where(exp).FirstOrDefault();
if (obj != null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = "客户名称已存在！" });//Resources.Common.ERROR_MESSAGE
}
Customer cstmer = db.Customer.Where(u => u.IDX == idx).FirstOrDefault();
if (cstmer == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
cstmer.Code = Request.Form["Code"];
cstmer.Name1 = Request.Form["Name1"];
cstmer.Name2 = Request.Form["Name2"];
cstmer.SimpleName = Request.Form["SimpleName"];
cstmer.TypeID =Util.toint(Request.Form["TypeID"]);
cstmer.ContactPerson = Request.Form["ContactPerson"];
cstmer.Telephone = Request.Form["Telephone"];
cstmer.Fax = Request.Form["Fax"];
cstmer.Email = Request.Form["Email"];
cstmer.Address = Request.Form["Address"];
cstmer.MailCode = Request.Form["MailCode"];
cstmer.Remark = Request.Form["Remark"];
cstmer.OwnerID = -1;
cstmer.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");;
cstmer.UserID = Session.GetDataFromSession<int>("userid");
cstmer.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
cstmer.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
cstmer.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
cstmer.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
cstmer.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
cstmer.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
cstmer.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
cstmer.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
cstmer.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
cstmer.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
db.Entry(cstmer).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
var orderList = db.OrderInfor.Where(u => u.CustomerID == idx).ToList();
if (orderList != null)
{
foreach (var item in orderList)
{
item.CustomerName = cstmer.Name1;
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception ex)
{
throw ex;
}
}
#endregion Edit
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
public ActionResult AddCustomerBillSchemeItem(int billingTemplateId, int itemId, string unitPrice, string currency, int typeId)
{
this.Internationalization();
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.BillingItemTemplate aScheduler = new BillingItemTemplate();
aScheduler.BillingTemplateID = billingTemplateId;
aScheduler.ItemID = itemId;
aScheduler.UnitPrice = Convert.ToDouble(unitPrice);
aScheduler.Currency = currency;
aScheduler.TypeID = typeId;
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"] != "")
// aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
//if (Request.Form["UserDefinedCol6"] != "")
// aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
//if (Request.Form["UserDefinedCol7"] != "")
// aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
//if (Request.Form["UserDefinedCol8"] != "")
// aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
aScheduler.UserDefinedCol9 = "";
aScheduler.UserDefinedCol10 = "";
aScheduler = db.BillingItemTemplate.Add(aScheduler);
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)
{
var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
//Response.Write(@Resources.Common.EXCEPTION_MESSAGE);
return Json(ret);
}
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
public ActionResult Delete_LinkMan()
{
this.Internationalization();
using (TransactionScope trans = new TransactionScope())
{
try
{
var f = Request.Form;
int idx = Util.toint(Request.Form["data[IDX]"]);
TugDataEntities db = new TugDataEntities();
//删除聯繫人
LinkMan cstmer = db.LinkMan.FirstOrDefault(u => u.IDX == idx);
db.LinkMan.Remove(cstmer);
db.SaveChanges();
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 });
}
}
}
public ActionResult DeleteCustomerBillSchemeItem()
{
this.Internationalization();
try
{
var f = Request.Form;
int idx = Util.toint(Request.Form["data[IDX]"]);
int billingTemplateID = Util.toint(Request.Form["data[BillingTemplateID]"]);
TugDataEntities db = new TugDataEntities();
//Billing obj = db.Billing.FirstOrDefault(u => u.BillingTemplateID == billingTemplateID);
//if (obj != null)
// throw new Exception("此計費方案项目已在賬單中使用過，不能被刪除！");
//else
{
BillingItemTemplate aScheduler = db.BillingItemTemplate.FirstOrDefault(u => u.IDX == idx);
if (aScheduler != null)
{
db.BillingItemTemplate.Remove(aScheduler);
db.SaveChanges();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
else
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
}
}
catch (Exception ex)
{
throw ex;
//return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
public static int AutoAddCustomerShip(int ctmId, string Name1, string Name2, string SimpleName, string DeadWeight, string Length,
string Width, string TEUS, string Class, string Remark, int UserID)
{
try
{
TugDataEntities db = new TugDataEntities();
System.Linq.Expressions.Expression<Func<CustomerShip, bool>> exp = u => u.Name1 == Name1;
CustomerShip obj = db.CustomerShip.Where(exp).FirstOrDefault();
if (obj != null)
{
//var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE, objid = obj.IDX };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
//return Json(ret);
//throw new Exception("船名称已存在！");
return obj.IDX;
}
{
TugDataModel.CustomerShip ship = new CustomerShip();
ship.CustomerID = ctmId;// Util.toint(Request.Form["CustomerID"]);
ship.ShipTypeID = -1;//Util.toint(Request.Form["ShipTypeID"]);
ship.Name1 = Name1;
ship.Name2 = Name2;
ship.SimpleName = SimpleName;
ship.DeadWeight = Util.toint(DeadWeight);
ship.Length = Util.toint(Length);
ship.Width = Util.toint(Width);
ship.TEUS = Util.toint(TEUS);
ship.Class = Class;
ship.Remark = Remark;
ship.OwnerID = -1;
ship.CreateDate = ship.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ;
ship.UserID = UserID;
ship.UserDefinedCol1 = "";
ship.UserDefinedCol2 = "";
ship.UserDefinedCol3 = "";
ship.UserDefinedCol4 = "";
//if (Request.Form["UserDefinedCol5"] != "")
// ship.UserDefinedCol5 = Util.tonumeric(Request.Form["UserDefinedCol5"]);
//if (Request.Form["UserDefinedCol6"] != "")
// ship.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
//if (Request.Form["UserDefinedCol7"] != "")
// ship.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
//if (Request.Form["UserDefinedCol8"] != "")
// ship.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
ship.UserDefinedCol9 = "";
ship.UserDefinedCol10 = "";
ship = db.CustomerShip.Add(ship);
db.SaveChanges();
//var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE, objid=ship.IDX };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
//return Json(ret);
return ship.IDX;
}
}
catch (Exception ex)
{
throw ex;
//var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
//return Json(ret);
}
}
public ActionResult AddScheduler2(int orderServiceId, string tugIds, string tugNames)
{
this.Internationalization();
try
{
TugDataEntities db = new TugDataEntities();
{
//1.先删除原有的调度
var oldSchedulers = db.Scheduler.Where(u => u.OrderServiceID == orderServiceId).ToList();
if (oldSchedulers != null)
{
db.Scheduler.RemoveRange(oldSchedulers);
if (0 < db.SaveChanges())
{
OrderService os = db.OrderService.FirstOrDefault(u => u.IDX == orderServiceId);
os.JobStateID = 114;
os.UserDefinedCol9 = tugIds;
os.UserDefinedCol10 = tugNames;
db.Entry(os).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
//2.插入新更改的调度
#region 插入多个调度到数据库
{
if (tugIds.Trim() != "")
{
List<string> lstTugIds = tugIds.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 = orderServiceId;
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 == orderServiceId);
os.JobStateID = 115;
os.UserDefinedCol9 = tugIds;
os.UserDefinedCol10 = tugNames;
db.Entry(os).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
}
#endregion
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 ActionResult AddEditCustomerBillSchemeItem()
{
this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.BillingItemTemplate aScheduler = new BillingItemTemplate();
aScheduler.BillingTemplateID = Util.toint(Request.Form["BillingTemplateID"].Trim());
aScheduler.ItemID = Util.toint(Request.Form["ItemID"].Trim());
aScheduler.UnitPrice = Convert.ToDouble(Request.Form["UnitPrice"].Trim());
aScheduler.Currency = Request.Form["Currency".Trim()];
aScheduler.TypeID = Util.toint(Request.Form["TypeID"].Trim());
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
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.BillingItemTemplate.Add(aScheduler);
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"]);
BillingItemTemplate aScheduler = db.BillingItemTemplate.Where(u => u.IDX == idx).FirstOrDefault();
if (aScheduler == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
aScheduler.BillingTemplateID = Util.toint(Request.Form["BillingTemplateID"].Trim());
aScheduler.ItemID = Util.toint(Request.Form["ItemID"].Trim());
aScheduler.UnitPrice = Convert.ToDouble(Request.Form["UnitPrice"].Trim());
aScheduler.Currency = Request.Form["Currency"].Trim();
aScheduler.TypeID = Util.toint(Request.Form["TypeID"].Trim());
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
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();
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 ChangeServiceStatusToComplete(int orderId, int orderServiceId)
{
TugDataEntities db = new TugDataEntities();
OrderService os = db.OrderService.FirstOrDefault(u => u.IDX == orderServiceId);
if (os != null)
{
int neededTotalShipNumbers = TugBusinessLogic.Module.Util.toint(os.BigTugNum) + TugBusinessLogic.Module.Util.toint(os.MiddleTugNum) + TugBusinessLogic.Module.Util.toint(os.SmallTugNum);
int realTotalShipNumbers = db.Scheduler.Where(u => u.OrderServiceID == os.IDX).ToList().Count;
if (realTotalShipNumbers != neededTotalShipNumbers)
{
var retJson = new { code = Resources.Common.FAIL_CODE, message = "已經排的拖輪和所需的拖輪數量不等，無法完成，請檢查實際排船數量！" };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
return Json(retJson);
}
os.JobStateID = 116;
db.Entry(os).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
var list = db.V_OrderService.Where(u => u.OrderID == orderId).ToList();
if (list != null)
{
bool flag = true;
foreach (var item in list) //查看该订单下有没有未完成的服务，如果有，flag = false; 如果没有flag = true
{
if(item.ServiceJobStateID != 116 || item.ServiceJobStateValue != "2" ||item.ServiceJobStateLabel != "已完工")
{
flag = false;
break;
}
}
if (flag == true) //flag是true说明该订单下的所有服务都已经是完成状态，将订单状态改为已排船，否则是未排船
{
//更新订单状态为已排船
OrderInfor oi = db.OrderInfor.FirstOrDefault(u => u.IDX == orderId);
if(oi != null)
{
oi.WorkStateID = 3; //所有服务都完成订单状态变成“已排船”
db.Entry(oi).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);
}
else
{
var ret = new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
return Json(ret);
}
}
public ActionResult AddEdit_LinkMan()
{
this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.LinkMan linkMan = new LinkMan();
linkMan.LinkManName = Request.Form["LinkManName"];
linkMan.LinkPhone = Request.Form["LinkPhone"];
linkMan.LinkEmail = Request.Form["LinkEmail"];
linkMan.Remark = Request.Form["Remark"];
linkMan.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
linkMan.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
linkMan.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
linkMan.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
linkMan.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
linkMan.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
linkMan.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
linkMan.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
linkMan.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
linkMan.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
linkMan.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
linkMan = db.LinkMan.Add(linkMan);
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
{
int idx = Util.toint(Request.Form["IDX"]);
string name = Request.Form["LinkMan"];
TugDataEntities db = new TugDataEntities();
System.Linq.Expressions.Expression<Func<LinkMan, bool>> exp = u => u.LinkManName == name && u.IDX != idx;
LinkMan obj = db.LinkMan.Where(exp).FirstOrDefault();
if (obj != null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = "客户名称已存在！" });//Resources.Common.ERROR_MESSAGE
}
LinkMan linkMan = db.LinkMan.Where(u => u.IDX == idx).FirstOrDefault();
if (linkMan == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
linkMan.LinkManName = Request.Form["LinkManName"];
linkMan.LinkPhone = Request.Form["LinkPhone"];
linkMan.LinkEmail = Request.Form["LinkEmail"];
linkMan.Remark = Request.Form["Remark"];
linkMan.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
linkMan.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
linkMan.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
linkMan.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
linkMan.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
linkMan.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
linkMan.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
linkMan.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
linkMan.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
linkMan.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
db.Entry(linkMan).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
var linkmanList = db.OrderInfor.Where(u => u.CustomerID == idx).ToList();
if (linkmanList != null)
{
foreach (var item in linkmanList)
{
item.CustomerName = linkMan.LinkManName;
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception ex)
{
throw ex;
}
}
#endregion Edit
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
public ActionResult DeleteScheduler()
{
this.Internationalization();
try
{
var f = Request.Form;
int idx = Util.toint(Request.Form["data[IDX]"].Trim());
int orderId = Util.toint(Request.Form["data[OrderID]"].Trim());
int orderServiceId = Util.toint(Request.Form["data[OrderServiceID]"].Trim());
TugDataEntities db = new TugDataEntities();
Scheduler aScheduler = db.Scheduler.FirstOrDefault(u => u.IDX == idx);
if (aScheduler != null)
{
//int orderId = (int)aScheduler.OrderID;
db.Scheduler.Remove(aScheduler);
db.SaveChanges();
//删除一个调度之后，要看是否还剩下调度
{
var list = db.V_OrderScheduler.Where(u => u.OrderID == orderId && u.OrderServiceID == orderServiceId).ToList();
if (list == null || list.Count == 0)
{
//更新服务状态
OrderService tmpOrder = db.OrderService.Where(u => u.IDX == orderServiceId).FirstOrDefault();
if (tmpOrder != null)
{
tmpOrder.JobStateID = 114; //未排船
db.Entry(tmpOrder).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
//else
//{
// //更新订单状态
// OrderInfor tmpOrder = db.OrderInfor.Where(u => u.IDX == orderId).FirstOrDefault();
// if (tmpOrder != null)
// {
// if (true == TugBusinessLogic.Module.OrderLogic.OrderJobInformationInputIsComplete(orderId))
// {
// tmpOrder.WorkStateID = 5; //已完工
// db.Entry(tmpOrder).State = System.Data.Entity.EntityState.Modified;
// db.SaveChanges();
// }
// }
//}
}
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
else
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
}
catch (Exception)
{
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
public ActionResult AddLinkMan(string LinkMan, string LinkPhone, string LinkEmail, string Remark)
{
this.Internationalization();
try
{
TugDataEntities db = new TugDataEntities();
System.Linq.Expressions.Expression<Func<LinkMan, bool>> exp = u => u.LinkManName == LinkMan;
LinkMan obj = db.LinkMan.Where(exp).FirstOrDefault();
if (obj != null)
{
throw new Exception("客户名称已存在！");
}
{
TugDataModel.LinkMan newLinkMan = new LinkMan();//
newLinkMan.LinkManName = LinkMan;
newLinkMan.LinkPhone = LinkPhone;
newLinkMan.LinkEmail = LinkEmail;
newLinkMan.Remark = Remark;
newLinkMan.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
newLinkMan.UserDefinedCol1 = "";
newLinkMan.UserDefinedCol2 = "";
newLinkMan.UserDefinedCol3 = "";
newLinkMan.UserDefinedCol4 = "";
newLinkMan.UserDefinedCol9 = "";
newLinkMan.UserDefinedCol10 = "";
newLinkMan = db.LinkMan.Add(newLinkMan);
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 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);
}
public ActionResult AddCustomerBillScheme(int custId, int billingTemplateTypeId, string billingTemplateCode,
string billingTemplateName, int timeTypeId, double discount, string shipLength, string shipTEUS, string expiryDate,
string templateCreditContent, string remark, List<string[]> dataListFromTable)
{
try
{
//重名了
if (true == CheckBillingTemplateName(custId, billingTemplateName, -1))
{
return Json(new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE });
}
else
{
TugDataEntities db = new TugDataEntities();
TugDataModel.BillingTemplate cstmer = new BillingTemplate();
cstmer.BillingTemplateCode = billingTemplateCode;
cstmer.BillingTemplateName = billingTemplateName;
cstmer.BillingTemplateTypeID = billingTemplateTypeId;
cstmer.ShipLength = shipLength;
cstmer.ShipTEUS = shipTEUS;
cstmer.ExpiryDate = expiryDate;
cstmer.CreateDate = cstmer.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
cstmer.CustomerID = custId; // Convert.ToInt32(customerId);
cstmer.TemplateCreditContent = templateCreditContent;
cstmer.TimeTypeID = timeTypeId;
cstmer.Discount = discount;
cstmer.Remark = remark;
cstmer.OwnerID = -1;
cstmer.UserID = Session.GetDataFromSession<int>("userid");
cstmer.UserDefinedCol1 = "";
cstmer.UserDefinedCol2 = "";
cstmer.UserDefinedCol3 = "";
cstmer.UserDefinedCol4 = "";
//if (Request.Form["UserDefinedCol5"] != "")
// cstmer.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
//if (Request.Form["UserDefinedCol6"] != "")
// cstmer.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
//if (Request.Form["UserDefinedCol7"] != "")
// cstmer.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
//if (Request.Form["UserDefinedCol8"] != "")
// cstmer.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
cstmer.UserDefinedCol9 = "";
cstmer.UserDefinedCol10 = "";
cstmer = db.BillingTemplate.Add(cstmer);
db.SaveChanges();
//保存收费项
for (int i = 0; i < dataListFromTable.Count - 1; i++)//最后一行空行
{
if (Util.checkdbnull(dataListFromTable[i][2]) == "") continue;
TugDataModel.BillingItemTemplate aScheduler = new BillingItemTemplate();
aScheduler.BillingTemplateID = cstmer.IDX;
aScheduler.ItemID =Util.toint(dataListFromTable[i][0]);
aScheduler.UnitPrice = Util.tonumeric(dataListFromTable[i][2]);
aScheduler.Currency = dataListFromTable[i][3];
aScheduler.TypeID = 13;
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"] != "")
// aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
//if (Request.Form["UserDefinedCol6"] != "")
// aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
//if (Request.Form["UserDefinedCol7"] != "")
// aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
//if (Request.Form["UserDefinedCol8"] != "")
// aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
aScheduler.UserDefinedCol9 = "";
aScheduler.UserDefinedCol10 = "";
aScheduler = db.BillingItemTemplate.Add(aScheduler);
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);
}
}
/// <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 Delete()
{
this.Internationalization();
using (TransactionScope trans = new TransactionScope())
{
try
{
var f = Request.Form;
int idx = Util.toint(Request.Form["data[IDX]"]);
TugDataEntities db = new TugDataEntities();
//先判断此客户是否已被使用过
OrderInfor obj = db.OrderInfor.FirstOrDefault(u => u.CustomerID == idx);
if (obj != null) throw new Exception("此客戶已在訂單中使用過，不能被刪除！");
//先删除客户船
System.Linq.Expressions.Expression<Func<CustomerShip, bool>> exp0 = u => u.CustomerID == idx;
var entitys = db.CustomerShip.Where(exp0);
entitys.ToList().ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.CustomerShip.RemoveRange(entitys);
db.SaveChanges();
//删除客户
Customer cstmer = db.Customer.FirstOrDefault(u => u.IDX == idx);
db.Customer.Remove(cstmer);
db.SaveChanges();
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 });
}
}
}
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 ActionResult DeleteCustomerBillScheme()
{
this.Internationalization();
try
{
var f = Request.Form;
int idx = Util.toint(Request.Form["data[BillingTemplateIDX]"]);
TugDataEntities db = new TugDataEntities();
//先判断此计费方案有没有被使用过
Billing obj = db.Billing.FirstOrDefault(u => u.BillingTemplateID == idx);
if (obj != null)
{
//throw new Exception("此計費方案已在賬單中使用過，不能被刪除！");
BillingTemplate cstmer = db.BillingTemplate.FirstOrDefault(u => u.IDX == idx);
cstmer.UserDefinedCol6 = -1;
db.Entry(cstmer).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
else
{
BillingTemplate cstmer = db.BillingTemplate.FirstOrDefault(u => u.IDX == idx);
if (cstmer != null)
{
List<BillingItemTemplate> items = db.BillingItemTemplate.Where(u => u.BillingTemplateID == cstmer.IDX).ToList();
if (items != null)
db.BillingItemTemplate.RemoveRange(items);
db.BillingTemplate.Remove(cstmer);
db.SaveChanges();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
else
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
}
}
catch (Exception ex)
{
//return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
throw ex;
}
}