protected void grid_InitNewRow(object sender, DevExpress.Web.Data.ASPxDataInitNewRowEventArgs e)
{
DateTime dt = DateTime.Now;
string refNo = C2Setup.GetNextSchNo("", "Materials-OUT", dt);
e.NewValues["RefNo"] = refNo;
e.NewValues["JobType"] = "OUT";
e.NewValues["JobDate"] = dt;
e.NewValues["WorkStatus"] = "Cancel";
}
protected string SaveNewSch(string id)
{
try
{
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(JobSchedule), "Id='" + id + "'");
JobSchedule jobSch = C2.Manager.ORManager.GetObject(query) as JobSchedule;
string issueN = "";
JobSchedule job = new JobSchedule();
DateTime dt = DateTime.Now;
issueN = C2Setup.GetNextSchNo("", "Schedule", dt);
job.JobDate = dt;
job.JobStage = jobSch.JobStage;
job.JobType = jobSch.JobType;
job.Mode = jobSch.Mode;
job.ViaWh = jobSch.ViaWh;
job.StorageStartDate = new DateTime(1900, 1, 1);
job.StorageFreeDays = jobSch.StorageFreeDays; //new DateTime(1900,1,1);
if (job.JobType == "Storage")
{
issueN = "SR-" + issueN;
job.ViaWh = "Normal";
}
if (job.JobType == "Outbound")
{
issueN = "OB-" + issueN;
job.Mode = "Lcl";
}
if (job.JobType == "Local Move")
{
issueN = "LM-" + issueN;
}
if (job.JobType == "Office Move")
{
issueN = "OM-" + issueN;
}
if (job.JobType == "Inbound")
{
issueN = "IB-" + issueN;
}
if (job.JobType == "Air")
{
issueN = "AR-" + issueN;
}
//Main Info
job.CustomerId = jobSch.CustomerId;
job.CustomerName = jobSch.CustomerName;
job.CustomerAdd = jobSch.CustomerAdd;
job.Postalcode = jobSch.Postalcode;
job.Contact = jobSch.Contact;
job.Tel = jobSch.Tel;
job.Email = jobSch.Email;
job.Fax = jobSch.Fax;
job.Remark = jobSch.Remark;
job.WorkStatus = jobSch.WorkStatus;
job.Currency = jobSch.Currency;
job.ExRate = jobSch.ExRate;
job.PayTerm = jobSch.PayTerm;
job.ExpiryDate = jobSch.ExpiryDate;
job.PackRmk = jobSch.PackRmk;
job.MoveRmk = jobSch.MoveRmk;
job.WareHouseId = jobSch.WareHouseId;
job.OriginPort = jobSch.OriginPort;
job.DestinationPort = jobSch.DestinationPort;
job.OriginAdd = jobSch.OriginAdd;
job.DestinationAdd = jobSch.DestinationAdd;
job.Volumne = jobSch.Volumne;
job.ItemDes = jobSch.ItemDes;
job.VolumneRmk = jobSch.VolumneRmk;
job.HeadCount = jobSch.HeadCount;
job.PackDate = jobSch.PackDate;
job.StorageStartDate = jobSch.StorageStartDate;
job.StorageFreeDays = jobSch.StorageFreeDays;
job.StorageTotalDays = jobSch.StorageTotalDays;
job.TripNo = jobSch.TripNo;
job.MoveDate = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " 09:00");
job.Charges = jobSch.Charges;
job.EntryPort = jobSch.EntryPort;
job.Mode = jobSch.Mode;
job.Eta = jobSch.Eta;
job.TruckNo = jobSch.TruckNo;
job.OriginCity = jobSch.OriginCity;
job.DestCity = jobSch.DestCity;
job.OriginPostal = jobSch.OriginPostal;
job.DestPostal = jobSch.DestPostal;
job.ServiceType = jobSch.ServiceType;
//Additional
job.Item1 = jobSch.Item1;
job.Item2 = jobSch.Item2;
job.ItemDetail1 = jobSch.ItemDetail1;
job.ItemDetail2 = jobSch.ItemDetail2;
job.Item3 = jobSch.Item3;
job.ItemValue3 = jobSch.ItemValue3;
job.ItemData3 = jobSch.ItemData3;
job.ItemPrice3 = jobSch.ItemPrice3;
job.Item4 = jobSch.Item4;
job.ItemDetail4 = jobSch.ItemDetail4;
job.ItemPrice4 = jobSch.ItemPrice4;
job.Item5 = jobSch.Item5;
job.ItemValue5 = jobSch.ItemValue5;
job.ItemPrice5 = jobSch.ItemPrice5;
job.Item6 = jobSch.Item6;
job.ItemDetail6 = jobSch.ItemDetail6;
job.ItemPrice6 = jobSch.ItemPrice6;;
job.Item7 = jobSch.Item7;
job.ItemValue7 = jobSch.ItemValue7;
job.ItemDetail7 = jobSch.ItemDetail7;
job.ItemPrice7 = jobSch.ItemPrice7;
job.Item8 = jobSch.Item8;
job.ItemValue8 = jobSch.ItemValue8;
job.ItemDetail8 = jobSch.ItemDetail8;
job.ItemPrice8 = jobSch.ItemPrice8;
job.Item9 = jobSch.Item9;
job.ItemValue9 = jobSch.ItemValue9;
job.ItemDetail9 = jobSch.ItemDetail9;
job.ItemPrice9 = jobSch.ItemPrice9;
job.Item10 = jobSch.Item10;
job.ItemValue10 = jobSch.ItemValue10;
job.ItemDetail10 = jobSch.ItemDetail10;
job.ItemPrice10 = jobSch.ItemPrice10;
job.Item11 = jobSch.Item11;
job.ItemDetail11 = jobSch.ItemDetail11;
job.Item12 = jobSch.Item12;
job.ItemDetail12 = jobSch.ItemDetail12;
job.Item13 = jobSch.Item13;
job.ItemValue13 = jobSch.ItemValue13;
job.ItemData13 = jobSch.ItemData13;
job.Item14 = jobSch.Item14;
job.ItemValue14 = jobSch.ItemValue14;
job.ItemDetail14 = jobSch.ItemDetail14;
job.ItemPrice14 = jobSch.ItemPrice14;
job.Answer1 = jobSch.Answer1;
job.Answer2 = jobSch.Answer2;
job.Answer3 = jobSch.Answer3;
job.Answer4 = jobSch.Answer4;
job.WorkStatus = jobSch.WorkStatus;
//Quotation
job.Attention1 = jobSch.Attention1;
job.Attention2 = jobSch.Attention2;
job.Attention3 = jobSch.Attention3;
job.Attention4 = jobSch.Attention4;
job.Attention5 = jobSch.Attention5;
job.DateTime2 = jobSch.DateTime2;
job.DateTime1 = jobSch.DateTime1;
job.DateTime3 = jobSch.DateTime3;
job.DateTime4 = jobSch.DateTime4;
//job.DateTime5 = jobSch.DateTime5;
//job.DateTime6 = jobSch.DateTime6;
//job.DateTime7 = jobSch.DateTime7;
//job.DateTime8 = jobSch.DateTime8;
job.Value1 = jobSch.Value1;
job.Value2 = jobSch.Value2;
job.Value3 = jobSch.Value3;
job.Value4 = jobSch.Value4;
//job.Value5 = jobSch.Value5;
//job.Value6 = jobSch.Value6;
//job.Value7 = jobSch.Value7;
//job.Value8 = jobSch.Value8;
job.Notes = jobSch.Notes;
string userId = HttpContext.Current.User.Identity.Name;
job.RefNo = jobSch.RefNo;
job.CreateBy = userId;
job.CreateDateTime = DateTime.Now;
job.UpdateBy = userId;
job.UpdateDateTime = DateTime.Now;
job.JobNo = issueN;
job.DateTime1 = DateTime.Now;
job.CustomerName = jobSch.CustomerName;
job.OriginAdd = jobSch.OriginAdd;
job.DestinationAdd = jobSch.DestinationAdd;
job.PackRmk = jobSch.PackRmk;
job.VolumneRmk = jobSch.VolumneRmk;
job.Contact = jobSch.Contact;
Manager.ORManager.StartTracking(job, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(job);
C2Setup.SetNextNo("", "Schedule", issueN, DateTime.Now);
#region Item List
string sql = string.Format(@"SELECT Id, RefNo, JobNo, ItemType, ItemName, ItemQty, ItemValue, ItemMark, ItemNote, CreateBy, CreateDateTime,
UpdateBy, UpdateDateTime FROM JobItemList where RefNo='{0}'", jobSch.JobNo);
DataTable tab = ConnectSql.GetTab(sql);
for (int i = 0; i < tab.Rows.Count; i++)
{
JobItemList list = new JobItemList();
list.RefNo = job.JobNo;
list.ItemName = SafeValue.SafeString(tab.Rows[i]["ItemName"]);
list.ItemNote = SafeValue.SafeString(tab.Rows[i]["ItemNote"]);
list.ItemMark = SafeValue.SafeString(tab.Rows[i]["ItemMark"]);
list.ItemQty = SafeValue.SafeInt(tab.Rows[i]["ItemQty"], 0);
list.ItemValue = SafeValue.SafeDecimal(tab.Rows[i]["ItemValue"]);
list.ItemType = SafeValue.SafeString(tab.Rows[i]["ItemType"]);
list.CreateBy = EzshipHelper.GetUserName();
list.CreateDateTime = DateTime.Now;
list.JobNo = SafeValue.SafeString(tab.Rows[i]["JobNo"]);
Manager.ORManager.StartTracking(list, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(list);
}
#endregion
#region JobMCST
sql = string.Format(@"SELECT Id, RefNo, McstNo, McstDate1, McstDate2, States, McstRemark1, McstRemark2, Amount1, Amount2, CondoTel,
McstRemark3, CreateBy, CreateDateTime, UpdateBy, UpdateDateTime FROM JobMCST where RefNo='{0}'", jobSch.JobNo);
DataTable tab_mcst = ConnectSql.GetTab(sql);
for (int i = 0; i < tab_mcst.Rows.Count; i++)
{
JobMCST list = new JobMCST();
list.RefNo = job.JobNo;
list.McstNo = SafeValue.SafeString(tab_mcst.Rows[i]["McstNo"]);
list.McstDate1 = SafeValue.SafeDate(tab_mcst.Rows[i]["McstDate1"], DateTime.Now);
list.McstDate2 = SafeValue.SafeDate(tab_mcst.Rows[i]["McstDate2"], DateTime.Now);
list.States = SafeValue.SafeString(tab_mcst.Rows[i]["States"]);
list.McstRemark1 = SafeValue.SafeString(tab_mcst.Rows[i]["McstRemark1"]);
list.McstRemark2 = SafeValue.SafeString(tab_mcst.Rows[i]["McstRemark2"]);
list.CreateBy = SafeValue.SafeString(tab_mcst.Rows[i]["CreateBy"]);
list.CreateDateTime = SafeValue.SafeDate(tab_mcst.Rows[i]["CreateDateTime"], DateTime.Now);
list.UpdateBy = SafeValue.SafeString(tab_mcst.Rows[i]["UpdateBy"]);
list.UpdateDateTime = SafeValue.SafeDate(tab_mcst.Rows[i]["UpdateDateTime"], DateTime.Now);
list.CondoTel = SafeValue.SafeString(tab_mcst.Rows[i]["CondoTel"]);
list.McstRemark3 = SafeValue.SafeString(tab_mcst.Rows[i]["McstRemark3"]);
list.Amount1 = SafeValue.SafeDecimal(tab_mcst.Rows[i]["Amount1"]);
list.Amount2 = SafeValue.SafeDecimal(tab_mcst.Rows[i]["Amount2"]);
Manager.ORManager.StartTracking(list, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(list);
}
#endregion
#region Materials
sql = string.Format(@"SELECT Id, Description, Unit, RequisitionNew, RequisitionUsed, AdditionalNew, AdditionalUsed, AdditionalNew1,
AdditionalUsed1, AdditionalNew2, AdditionalUsed2, ReturnedNew, ReturnedUsed, TotalNew, TotalUsed, RefNo,
RequisitionNew1, RequisitionUsed1, RequisitionNew2, RequisitionUsed2 FROM Materials where RefNo='{0}'", jobSch.JobNo);
DataTable tab_material = ConnectSql.GetTab(sql);
for (int i = 0; i < tab_material.Rows.Count; i++)
{
Material list = new Material();
list.RefNo = job.JobNo;
list.Description = SafeValue.SafeString(tab_material.Rows[i]["Description"]);
list.Unit = SafeValue.SafeString(tab_material.Rows[i]["Unit"]);
list.RequisitionNew = SafeValue.SafeInt(tab_material.Rows[i]["RequisitionNew"], 0);
list.RequisitionUsed = SafeValue.SafeInt(tab_material.Rows[i]["RequisitionUsed"], 0);
list.AdditionalNew = SafeValue.SafeInt(tab_material.Rows[i]["AdditionalNew"], 0);
list.AdditionalUsed = SafeValue.SafeInt(tab_material.Rows[i]["AdditionalUsed"], 0);
list.AdditionalNew1 = SafeValue.SafeInt(tab_material.Rows[i]["AdditionalNew1"], 0);
list.AdditionalUsed1 = SafeValue.SafeInt(tab_material.Rows[i]["AdditionalUsed1"], 0);
list.AdditionalNew2 = SafeValue.SafeInt(tab_material.Rows[i]["AdditionalNew2"], 0);
list.AdditionalUsed2 = SafeValue.SafeInt(tab_material.Rows[i]["AdditionalUsed2"], 0);
list.ReturnedNew = SafeValue.SafeInt(tab_material.Rows[i]["ReturnedNew"], 0);
list.ReturnedUsed = SafeValue.SafeInt(tab_material.Rows[i]["ReturnedUsed"], 0);
list.RequisitionNew1 = SafeValue.SafeInt(tab_material.Rows[i]["RequisitionNew1"], 0);
list.RequisitionUsed1 = SafeValue.SafeInt(tab_material.Rows[i]["RequisitionUsed1"], 0);
list.RequisitionNew2 = SafeValue.SafeInt(tab_material.Rows[i]["RequisitionNew2"], 0);
list.RequisitionUsed2 = SafeValue.SafeInt(tab_material.Rows[i]["RequisitionUsed2"], 0);
list.TotalNew = SafeValue.SafeInt(tab_material.Rows[i]["TotalNew"], 0);
list.TotalUsed = SafeValue.SafeInt(tab_material.Rows[i]["TotalUsed"], 0);
Manager.ORManager.StartTracking(list, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(list);
}
#endregion
return(job.JobNo);
}
catch { }
return("");
}
