protected int TransferProduct(string sku, string lotNo, string des, string wh, int qty, string loc, string doNo, int tId, string toWh, string toLoc)
{
int pId = 0;
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(WhTransfer), "Id='" + tId + "'");
WhTransfer transfer = C2.Manager.ORManager.GetObject(query) as WhTransfer;
bool action = false;
string transferNo = "";
if (transfer == null)
{
action = true;
transfer = new WhTransfer();
transferNo = C2Setup.GetNextNo("Transfer");
}
string userId = HttpContext.Current.User.Identity.Name;
transfer.TransferNo = transferNo;
transfer.RequestPerson = userId;
transfer.RequestDate = DateTime.Now;
transfer.TransferDate = DateTime.Now;
transfer.Pic = "";
transfer.ConfirmPerson = "";
transfer.ConfirmDate = DateTime.Now;
transfer.StatusCode = "CLS";
if (action)
{
transfer.TransferNo = transferNo;
transfer.CreateBy = HttpContext.Current.User.Identity.Name;
transfer.CreateDateTime = DateTime.Now;
C2Setup.SetNextNo("Transfer", transferNo);
Manager.ORManager.StartTracking(transfer, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(transfer);
pId = transfer.Id;
}
int id = 0;
Wilson.ORMapper.OPathQuery query1 = new Wilson.ORMapper.OPathQuery(typeof(WhTransferDet), "Id='" + id + "'");
WhTransferDet det = C2.Manager.ORManager.GetObject(query1) as WhTransferDet;
if (det == null)
{
det = new WhTransferDet();
}
det.TransferNo = transferNo;
det.Product = sku;
det.LotNo = lotNo;
det.Qty1 = qty;
det.FromWarehouseId = wh;
det.FromLocId = loc;
det.ToWarehouseId = toWh;
det.ToLocId = toLoc;
det.Des1 = des;
det.CreateBy = userId;
det.CreateDateTime = DateTime.Now;
det.UpdateBy = userId;
det.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(det);
id = det.Id;
string sql = @"Insert Into Wh_DoDet2(DoNo,DoType,Product,Qty1,Qty2,Qty3,Price,LotNo,Uom1,Uom2,Uom3,Uom4,[QtyPackWhole],[QtyWholeLoose],[QtyLooseBase],[CreateBy],[CreateDateTime],[UpdateBy],[UpdateDateTime],Att1,Att2,Att3,Att4,Att5,Att6,Des1,Packing,Location,ProcessStatus)";
sql += string.Format(@"select DoNo, 'OUT' as DoType,Product
,'{2}' as Qty1
,0 as Qty2
,0 as Qty3
,Price
,'{3}' as LotNo
, Uom1,Uom2,Uom3, Uom4
,QtyPackWhole,QtyWholeLoose,QtyLooseBase
,'{4}' as CreateBy,getdate() as CreateDateTime,'{4}' as UpdateBy,getdate() as UpdateDateTime
,Att1,Att2,Att3,Att4,Att5,Att6,'{5}' as Des1,'' as Packing,'{6}' as Location,'Delivered' as ProcessStatus
from wh_dodet2 det where DoType='IN' and DoNo='{0}' and Product='{1}' and LotNo='{3}' and Location='{6}' select @@identity", doNo, sku, qty, lotNo, EzshipHelper.GetUserName(), des, loc);
int doOutId = SafeValue.SafeInt(ConnectSql.ExecuteScalar(sql), 0);
sql = @"Insert Into Wh_DoDet2(DoNo,DoType,Product,Qty1,Qty2,Qty3,Price,LotNo,Uom1,Uom2,Uom3,Uom4,[QtyPackWhole],[QtyWholeLoose],[QtyLooseBase],[CreateBy],[CreateDateTime],[UpdateBy],[UpdateDateTime],Att1,Att2,Att3,Att4,Att5,Att6,Des1,Packing,Location,ProcessStatus)";
sql += string.Format(@"select DoNo, 'IN' as DoType,Product
,'{2}' as Qty1
,0 as Qty2
,0 as Qty3
,Price
,'{3}' as LotNo
, Uom1,Uom2,Uom3, Uom4
,QtyPackWhole,QtyWholeLoose,QtyLooseBase
,'{4}' as CreateBy,getdate() as CreateDateTime,'{4}' as UpdateBy,getdate() as UpdateDateTime
,Att1,Att2,Att3,Att4,Att5,Att6,'{5}' as Des1,'' as Packing,'{6}' as Location,'Delivered' as ProcessStatus
from wh_dodet2 det where DoType='IN' and DoNo='{0}' and Product='{1}' and LotNo='{3}' and Location='{7}' select @@identity", doNo, sku, qty, lotNo, EzshipHelper.GetUserName(), des, toLoc, wh);
int doInId = SafeValue.SafeInt(ConnectSql.ExecuteScalar(sql), 0);
sql = string.Format(@"update wh_TransferDet set DoInId='{1}',DoOutId='{2}' where Id={0}", id, doInId, doOutId);
C2.Manager.ORManager.ExecuteCommand(sql);
return(pId);
}
protected void AddOrUpdate()
{
ASPxTextBox txt_pId = this.grid.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
string pId = SafeValue.SafeString(txt_pId.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(WhTransfer), "Id='" + pId + "'");
WhTransfer transfer = C2.Manager.ORManager.GetObject(query) as WhTransfer;
bool action = false;
string transferNo = "";
if (transfer == null)
{
action = true;
transfer = new WhTransfer();
transferNo = C2Setup.GetNextNo("Transfer");
}
ASPxTextBox txt_TransferNo = this.grid.FindEditFormTemplateControl("txt_TransferNo") as ASPxTextBox;
transfer.TransferNo = txt_TransferNo.Text.Trim();
ASPxTextBox txt_RequestPerson = this.grid.FindEditFormTemplateControl("txt_RequestPerson") as ASPxTextBox;
transfer.RequestPerson = txt_RequestPerson.Text;
ASPxDateEdit de_RequestDate = this.grid.FindEditFormTemplateControl("de_RequestDate") as ASPxDateEdit;
transfer.RequestDate = de_RequestDate.Date;
ASPxDateEdit de_TransferDate = this.grid.FindEditFormTemplateControl("de_TransferDate") as ASPxDateEdit;
transfer.TransferDate = de_TransferDate.Date;
//ASPxComboBox cbo_StatusCode =this.grid.FindEditFormTemplateControl("cbo_StatusCode") as ASPxComboBox;
//transfer.StatusCode = cbo_StatusCode.Text;
ASPxTextBox txt_Pic = this.grid.FindEditFormTemplateControl("txt_Pic") as ASPxTextBox;
transfer.Pic = txt_Pic.Text;
ASPxTextBox txt_ConfirmPerson = this.grid.FindEditFormTemplateControl("txt_ConfirmPerson") as ASPxTextBox;
transfer.ConfirmPerson = txt_ConfirmPerson.Text;
ASPxDateEdit de_ConfirmDate = this.grid.FindEditFormTemplateControl("de_ConfirmDate") as ASPxDateEdit;
transfer.ConfirmDate = de_ConfirmDate.Date;
ASPxTextBox txt_UomWhole = this.grid.FindEditFormTemplateControl("txt_UomWhole") as ASPxTextBox;
ASPxButtonEdit txt_PartyId = this.grid.FindEditFormTemplateControl("txt_PartyId") as ASPxButtonEdit;
transfer.PartyId = txt_PartyId.Text;
ASPxTextBox txt_PartyName = this.grid.FindEditFormTemplateControl("txt_PartyName") as ASPxTextBox;
transfer.PartyName = txt_PartyName.Text;
if (action)
{
transfer.TransferNo = transferNo;
transfer.CreateBy = HttpContext.Current.User.Identity.Name;
transfer.CreateDateTime = DateTime.Now;
C2Setup.SetNextNo("Transfer", transferNo);
Manager.ORManager.StartTracking(transfer, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(transfer);
Session["NameWhere"] = "TransferNo='" + transferNo + "'";
this.dsTransfer.FilterExpression = Session["NameWhere"].ToString();
if (this.grid.GetRow(0) != null)
{
this.grid.StartEdit(0);
}
}
else
{
transfer.UpdateBy = HttpContext.Current.User.Identity.Name;
transfer.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(transfer, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(transfer);
}
}