private static long?GetGoodsIdByName2(IDmoSessionWithTransaction session, string name)
{
var query = new DQueryDom(new JoinAlias(typeof(Goods)));
query.Where.Conditions.Add(DQCondition.EQ("Name", name));
query.Columns.Add(DQSelectColumn.Field("ID"));
var goodsID = query.EExecuteScalar <long?>(session);
return(goodsID);
}
private static void SetProductPlan(FrozenInStore dmo, IDmoSessionWithTransaction session)
{
var query = new DQueryDom(new JoinAlias(typeof(ProductPlan)));
query.Columns.Add(DQSelectColumn.Field("ID"));
query.Where.Conditions.Add(DQCondition.LessThanOrEqual("Date", dmo.Date));
query.Where.Conditions.Add(DQCondition.GreaterThanOrEqual("EndDate", dmo.Date));
query.Where.Conditions.Add(DQCondition.EQ("BillState", 单据状态.已审核));
var planid = query.EExecuteScalar <long?>(session);
dmo.ProductionPlan_ID = planid;
}
private static long?GetPlanIDByName(IDmoSessionWithTransaction session, string name)
{
var query = new DQueryDom(new JoinAlias(typeof(ProductPlan)));
query.Columns.Add(DQSelectColumn.Field("ID"));
query.Where.Conditions.Add(DQCondition.EQ("PlanNumber", name));
var id = session.ExecuteScalar(query);
if (id != null)
{
return(Convert.ToInt64(id));
}
return(null);
}
