public string TestAddPart(string ponum, string oastatus, string oaresult)
{
string sr = "";
try
{
Session epicorSession = createSession();
POImpl poAdapter = Ice.Lib.Framework.WCFServiceSupport.CreateImpl <POImpl>(epicorSession, Epicor.ServiceModel.Channels.ImplBase <POSvcContract> .UriPath);//
PODataSet pods = poAdapter.GetByID(int.Parse(ponum));
string echo = string.Format("OA03: {0} OA05:{1}", pods.POHeader.Rows[0]["OA03_c"], pods.POHeader.Rows[0]["OA05_c"]);
//lb_log.Items.Add("count: " + pods.POHeader.Rows.Count);
//lb_log.Items.Add(echo);
//foreach (DataColumn col in pods.POHeader.Columns)
//{
// lb_log.Items.Add(string.Format("colname: {0} colvalue: {1}", col.ColumnName, pods.POHeader.Rows[0][col.ColumnName]));
//}
pods.POHeader.Rows[0]["OA03_c"] = oastatus;
pods.POHeader.Rows[0]["OA02_c"] = oaresult;
if (oastatus.Equals('Y'))
{
pods.POHeader.Rows[0]["Approve"] = true;
}
else
{
pods.POHeader.Rows[0]["Approve"] = false;
}
//PartImplpartAdapter = Ice.Lib.Framework.WCFServiceSupport.CreateImpl<PartImpl>(epicorSession, Epicor.ServiceModel.Channels.ImplBase<PartSvcContract>.UriPath);
//string partnum = "TestPartAdd";
//PartDataSetds = new PartDataSet();
//partAdapter.GetNewPart(ds);
//ds.Tables[0].Rows[0]["PartNum"] = partnum;
//ds.Tables[0].Rows[0]["PartDescription"] = partnum;
//partAdapter.ChangePartNum(partnum, ds);
//partAdapter.Update(ds);
poAdapter.Update(pods);
closeSession();
sr = "OK";
}
catch (Exception ex)
{
sr = ex.Message.ToString();
}
return(sr);
}
public string TestAddPart()
{
string userName = "******";
string passWord = "******";
string appServerUrl = "net.tcp://epicor-ser/ERP102300"; // "net.tcp://192.168.6.25/ERP102300";//net.tcp://epicor-ser/ERP102300
Session epicorSession = new Session(userName, passWord, appServerUrl, Ice.Core.Session.LicenseType.Default, @"C:\Epicor\ERP10\LocalClients\ERP102300\config\ERP102300.sysconfig", false, "ONOFF01", null);
POImpl poAdapter = Ice.Lib.Framework.WCFServiceSupport.CreateImpl <POImpl>(epicorSession, Epicor.ServiceModel.Channels.ImplBase <POSvcContract> .UriPath); //
PODataSet pods = poAdapter.GetByID(int.Parse(txt_ponum.Text));
string echo = string.Format("OA03: {0} OA05:{1}", pods.POHeader.Rows[0]["OA03_c"], pods.POHeader.Rows[0]["OA05_c"]);
lb_log.Items.Add("count: " + pods.POHeader.Rows.Count);
lb_log.Items.Add(echo);
foreach (DataColumn col in pods.POHeader.Columns)
{
lb_log.Items.Add(string.Format("colname: {0} colvalue: {1}", col.ColumnName, pods.POHeader.Rows[0][col.ColumnName]));
}
lb_log.Items.Add("Podetail count: " + pods.PODetail.Rows.Count);
foreach (PODetailRow dr in pods.PODetail.Rows)
{
foreach (DataColumn col in pods.PODetail.Columns)
{
lb_log.Items.Add(string.Format("colname: {0} colvalue: {1}", col.ColumnName, dr[col.ColumnName]));
}
}
pods.POHeader.Rows[0]["OA05_c"] = "Y";
pods.POHeader.Rows[0]["OA03_c"] = "Test";
//PartImplpartAdapter = Ice.Lib.Framework.WCFServiceSupport.CreateImpl<PartImpl>(epicorSession, Epicor.ServiceModel.Channels.ImplBase<PartSvcContract>.UriPath);
//string partnum = "TestPartAdd";
//PartDataSetds = new PartDataSet();
//partAdapter.GetNewPart(ds);
//ds.Tables[0].Rows[0]["PartNum"] = partnum;
//ds.Tables[0].Rows[0]["PartDescription"] = partnum;
//partAdapter.ChangePartNum(partnum, ds);
//partAdapter.Update(ds);
poAdapter.Update(pods);
epicorSession.Dispose();
return("");
}
/// <summary>初始化数据(InitializeCustomCode中调用该方法)</summary>
/// <param name="csm1">接受从Epicor中传过来的CustomScriptManager对象</param>
public void Initialize(Ice.Lib.Customization.CustomScriptManager csm1)
{
csm = csm1;
//((Ice.Core.Session)(csm.GetGlobalInstance("oTrans")));//(Ice.Core.Session)(csm.GetGlobalInstance("oTrans"));//
oTrans = ((Erp.UI.App.POEntry.Transaction)(csm.GetGlobalInstance("oTrans")));
session = (Ice.Core.Session)(oTrans.Session);
edvUD01 = ((EpiDataView)(oTrans.EpiDataViews["POHeader"]));
//oTrans.AdapterList[""];
poAdapter = new POAdapter(oTrans);
baseToolbarsManager = ((UltraToolbarsManager)(csm.GetGlobalInstance("baseToolbarsManager")));
standardTools = baseToolbarsManager.Toolbars["Standard Tools"];
TForm = ((Erp.UI.App.POEntry.POEntryForm)(this.csm.GetGlobalInstance("POEntryForm")));
epiBtNew = GetControlByName <EpiButton>(TForm, "eb_sendPO");//获取UI界面的控件
epiBtNew.Click += EpiBtNew_Click;
ds_po = oTrans.POData;
dt_poheder = ds_po.POHeader;
dt_podetail = ds_po.PODetail;
}
public bool UpdatePOReleaseQty(Session epiSession, string poNum, out string msgError)
{
msgError = "";
bool result = false;
if (epiSession.IsValidSession(epiSession.SessionID, epiSession.UserID))
{
try
{
PO myPO = new PO(epiSession.ConnectionPool);
bool morePages = false;
PODataSet dsPO = new PODataSet();
dsPO = myPO.GetRows("PONum = " + poNum, "", "", "", "", "", "", "", "", 0, 1, out morePages);
DataRow drPO = dsPO.Tables["POHeader"].Select().Single();
string cal = drPO["ShortChar06"].ToString();
DataTable POLine = dsPO.Tables["PODetail"];
int i = 0;
foreach (DataRow list in dsPO.Tables["PORel"].Rows)
{
var item = POLine.Rows[i].ItemArray.ToArray();
decimal qty = 0;
if (cal == "1" || cal == "3" || cal == "4") { qty = Convert.ToDecimal(item[67].ToString()); } //67=Number11,
else if (cal == "2") { qty = Convert.ToDecimal(item[76].ToString()); } //76=Number20
list.BeginEdit();
list["XRelQty"] = qty;
list["RelQty"] = qty;
list["BaseQty"] = qty;
list.EndEdit();
i++;
}
myPO.Update(dsPO);
result = true;
epiSession.Dispose();
}
catch (Exception ex)
{
msgError = "Error : " + ex;
}
}
return result;
}
