I forgot the DateTime.Parse..
DateTime needDate = DateTime.Parse (edvOrderHed.dataView[0]["NeedByDate"].ToString());
DateTime shipDate= DateTime.Parse (edvOrderHed.dataView[0]["ShipByDate"].ToString());
---In vantage@yahoogroups.com, <don.n.doan@...> wrote:Here's the code i use for plugging projectID into sales orders.. I modified it for dates but it isn't tested. Make sure to use the wizard to create the beforeadaptermethod.
private void oTrans_ordAdapter_BeforeAdapterMethod(object sender, BeforeAdapterMethodArgs args)
{
// ** Argument Properties and Uses **
// ** args.MethodName **
// ** Add Event Handler Code **
// ** Use MessageBox to find adapter method name
// EpiMessageBox.Show(args.MethodName)
switch (args.MethodName)
{
case "Update":
EpiDataView edvOrderDtl = ((EpiDataView)(this.oTrans.EpiDataViews["OrderDtl"]));
EpiDataView edvOrderHed = ((EpiDataView)(this.oTrans.EpiDataViews["OrderHed"]));
if (edvOrderDtl.dataView.Count != 0)
{
DateTime needDate = edvOrderHed.dataView[0]["NeedByDate"].ToString();
DateTime shipDate = edvOrderHed.dataView[0]["ShipByDate"].ToString();
if (needDate != "")
{
for(int i = 0; i < edvOrderDtl.dataView.Count; i++)
{
edvOrderDtl.dataView[i]["NeedByDate"] = needDate;
edvOrderDtl.dataView[i]["ShipByDate"] = shipDate;
}
}
}
break;
}
}
Let me know how it works out.
---In vantage@yahoogroups.com, <clederer@...> wrote:Trying to change 2 sets of dates in Transfer Order Entry (Line --> Detail) that currently default to "blank," to default to the date that is entered in the previous line.
Ideally, I'd like to have the code say, "set table.date to previous line table.date" but I'm not sure how to say it