public virtual void ReceivePurchase(PurchaseGroup purchase, string code)
{
try
{
using (var trans = RF.TransactionScope(BDEntityDataProvider.ConnectionStringName))
{
var existOrganization = DomainControllerFactory.Create <PurchaseGroupController>().GetPurchaseGroupByCode(purchase.Code) ?? purchase;
var userModel = DomainControllerFactory.Create <UserController>().FetchBy("", purchase.Name).FirstOrDefault() as User;
if (userModel != null)
{
existOrganization.BuyerId = userModel.Id;
}
existOrganization.Code = purchase.Code;
existOrganization.Name = purchase.Code;
existOrganization.Phone = purchase.Phone;
existOrganization.Fax = purchase.Fax;
//
InvOrgIdExtension.SetInvOrgId(existOrganization, PlatformEnvironment.InvOrgId);
RF.Save(existOrganization);
trans.Complete();
}
}
catch (Exception e)
{
throw new Exception("采购组基础主数据 下载异常:" + e.Message);
}
}
void SavePurchaseGroup()
{
using (ISession session = new Session())
{
try
{
PurchaseGroup purchasegroup = new PurchaseGroup();
purchasegroup.PurchGroupCode = this.txtPurchGroupCode.Text;
purchasegroup.PurchGroupText = this.txtPurchGroupText.Text;
if (this.IsAddNew())
{
//检测code是否重复
int existsCount = session.CreateEntityQuery <Magic.Basis.PurchaseGroup>().Where(Magic.Framework.ORM.Query.Exp.Eq("PurchGroupCode", purchasegroup.PurchGroupCode)).Count();
if (existsCount > 0)
{
WebUtil.ShowMsg(this, string.Format("采购组编号{0}已经存在", purchasegroup.PurchGroupCode), "错误");
return;
}
purchasegroup.Create(session);
}
else
{
purchasegroup.Update(session, "PurchGroupText");
}
this.Response.Redirect("PurchaseGroupManager.aspx");
}
catch (Exception ex)
{
logger.Info("保存Logistics", ex);
WebUtil.ShowMsg(this, "发生未处理的异常,请刷新页面重新操作，或者联系系统管理员");
}
}
}
void RetrievePurchaseGroupData(ISession session)
{
string PurchGroupCode = WebUtil.Param("id");
if (!string.IsNullOrEmpty(PurchGroupCode))
{
PurchaseGroup purchasegroup = Magic.Basis.PurchaseGroup.Retrieve(session, PurchGroupCode);
this.txtPurchGroupCode.Text = purchasegroup.PurchGroupCode;
this.txtPurchGroupCode.Enabled = false;
this.txtPurchGroupText.Text = purchasegroup.PurchGroupText;
this.txtCode.Value = purchasegroup.PurchGroupCode;
}
}
private static List <PurchaseGroup> ERP_MES_Purchase(Hashtable import)
{
RFC rfc = new RFC(ConfigurationManager.AppSettings["sapServer"].ToString());
//RFC rfc = new RFC("SAPTest");
var lst = new List <PurchaseGroup>();
//RFC调用函数名
string funcName = "ZWMS_T024";
//传输传给RFC函数的DataSet
DataSet ids = new DataSet();
//构建RFC传入表DataTable
//返回数据的DataSet框架
DataSet ods = new DataSet();
//构建Export参数DataTable
DataTable export = new DataTable();
export.TableName = "Export";
export.Columns.Add(new DataColumn("RTMSG", typeof(string)));//消息文本
ods.Tables.Add(export);
//构建RFC传出表DataTable
DataTable odt1 = new DataTable();
odt1.TableName = "T_TAB";
odt1.Columns.Add(new DataColumn("EKGRP", typeof(string)));
odt1.Columns.Add(new DataColumn("EKNAM", typeof(string)));
odt1.Columns.Add(new DataColumn("EKTEL", typeof(string)));
odt1.Columns.Add(new DataColumn("TELFX", typeof(string)));
ods.Tables.Add(odt1);
//执行RFC函数
bool ret = rfc.DownloadByRFC(funcName, import, ids, ref ods);
//根据RFC执行后返回的数据处理业务逻辑
DataTable dt = ods.Tables["T_TAB"];
for (int i = 0; i < dt.Rows.Count; i++)
{
string code = dt.Rows[i]["EKGRP"].ToString();
string employee = dt.Rows[i]["EKNAM"].ToString();//采购者
//DomainControllerFactory.Create<EmployeeController>().get
string phone = dt.Rows[i]["EKTEL"].ToString();
string fax = dt.Rows[i]["TELFX"].ToString();
var model = new PurchaseGroup()
{
Code = code, buyerName = employee, Phone = phone, Fax = fax
};
lst.Add(model);
}
return(lst);
}
void QueryAndBindData(ISession session)
{
string OrderNumber = WebUtil.Param("OrderNum");
string LineNumber = WebUtil.Param("CurrentLineNumber");
if (!string.IsNullOrEmpty(OrderNumber) && !string.IsNullOrEmpty(LineNumber))
{
//显示POHead内容
POHead poHead = POHead.Retrieve(session, OrderNumber);
if (poHead != null)
{
this.LabOrderNumber.Text = poHead.OrderNumber;
this.LabTaxAmt.Text = poHead.TaxAmt.ToString();
this.LabTaxExclusiveAmt.Text = poHead.TaxExclusiveAmt.ToString();
this.LabTaxInclusiveAmt.Text = poHead.TaxInclusiveAmt.ToString();
//供应商
Vendor vendor = Vendor.Retrieve(session, poHead.VendorID);
if (vendor != null)
{
this.LabVendorID.Text = vendor.FullName;
}
//采购组
PurchaseGroup purchasegroup = PurchaseGroup.Retrieve(session, poHead.PurchGroupCode);
if (purchasegroup != null)
{
this.LabPurchGroupCode.Text = purchasegroup.PurchGroupText;
}
}
//POLine.SKUID=ItemSpec.SKUID ItemSpec.ItemID=ItemMaster.ItemID
//货号ItemMaster.ItemCode 商品名称ItemMaster.ItemName
//颜色ItemSpec.ColorCode 尺码 ItemSpec.SizeCode
this.magicPagerSub.PageSize = 20;
int pageIndex = this.magicPagerMain.CurrentPageIndex;
int pageSize = this.magicPagerMain.PageSize;
ObjectQuery query = session.CreateObjectQuery(@"select m.ItemCode as ItemCode,m.ItemName as ItemName,s.ColorCode as ColorCode,s.SizeCode as SizeCode,p.LineStatus as LineStatus,p.PurchaseQty as PurchaseQty,p.PlanDate as PlanDate,p.Price as Price,p.TaxInclusiveAmt as TaxInclusiveAmt,p.TaxValue as TaxValue,p.TaxAmt as TaxAmt,p.LineNumber as LineNumber,p.OrderNumber as OrderNumber from POLine p,ItemSpec s,ItemMaster m WHERE p.SKUID=s.SKUID AND s.ItemID=m.ItemID AND p.OrderNumber=?").Attach(typeof(POLine)).Attach(typeof(ItemSpec)).Attach(typeof(ItemMaster)).SetValue(0, OrderNumber, "p.OrderNumber").SetPage(pageIndex, pageSize);
this.rptPL.DataSource = query.DataSet();
this.rptPL.DataBind();
this.magicPagerMain.RecordCount = this.magicPagerSub.RecordCount = query.Count();
WebUtil.SetMagicPager(magicPagerMain, pageSize, pageIndex);
WebUtil.SetMagicPager(magicPagerSub, pageSize, pageIndex);
}
}
public override int GetHashCode()
{
var hashCode = 640234196;
hashCode = hashCode * -1521134295 + PurchaseGroup.GetHashCode();
hashCode = hashCode * -1521134295 + Vendor.GetHashCode();
hashCode = hashCode * -1521134295 + Material.GetHashCode();
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Descr);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Rdd);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(ReschDate);
hashCode = hashCode * -1521134295 + PurchDoc.GetHashCode();
hashCode = hashCode * -1521134295 + Item.GetHashCode();
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(ExceptMsg);
hashCode = hashCode * -1521134295 + Plant.GetHashCode();
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(VendorName);
hashCode = hashCode * -1521134295 + MRPcont.GetHashCode();
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Name);
hashCode = hashCode * -1521134295 + EqualityComparer <double> .Default.GetHashCode(Quantity);
hashCode = hashCode * -1521134295 + EqualityComparer <double> .Default.GetHashCode(RemainQty);
hashCode = hashCode * -1521134295 + EqualityComparer <double> .Default.GetHashCode(QtyDelivered);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(POplndDelyTime);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(OrderUnit);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(ReschGRdueDate);
return(hashCode);
}
