public bool Save()
{
if (this._model != null)
{
if (this._model.IdRegion == null)
{
this._model.IdRegion = new NIR.Data.Filter.VarRegionManu();
}
var args = this._model.IdRegion.Argus;
args["Xaxis"].Value = this.varRegionControl1.Xaxis;
var region = this.varRegionControl1.XaxisRegion;
if (region == null || region.Count == 0)
{
var p = new SelectRange()
{
Begin = this.varRegionControl1.Xaxis[0] - 0.1,
End = this.varRegionControl1.Xaxis[this.varRegionControl1.Xaxis.Length - 1] + 0.1
};
region = new List <SelectRange>();
region.Add(p);
this.varRegionControl1.XaxisRegion = region;
}
args["XaxisRegion"].Value = region.Select(d => new PointF((float)d.Begin, (float)d.End)).ToList();
this._model.IdRegion.Argus = args;
}
return(true);
}
//
public void EnterSearchQuery()
{
search.Click();
searchquery.SendKeys("Candles");
searchquery.SendKeys(Keys.Enter);
SelectRange.Click();
}
static ProductNotice GetPrevOrNext(long currentID, bool prev = true)
{
var query = new DmoQuery(typeof(ProductNotice));
query.Where.Conditions.Add(DQCondition.EQ("Domain_ID", DomainContext.Current.ID));
query.Where.Conditions.Add(prev ? DQCondition.LessThan("ID", currentID) : DQCondition.GreaterThan("ID", currentID));
query.OrderBy.Expressions.Add(DQOrderByExpression.Create("ID", prev));
query.Range = SelectRange.Top(1);
return(query.EExecuteScalar <ProductNotice>());
}
private static IEnumerable <WordPair> SelectGoodsBrand(ChoiceBoxArgument argu)
{
var query = new DQueryDom(new JoinAlias(typeof(Goods)));
query.Range = SelectRange.Top(30);
query.Columns.Add(DQSelectColumn.Field("Brand"));
query.GroupBy.Expressions.Add(DQExpression.Field("Brand"));
if (!string.IsNullOrEmpty(argu.InputArgument))
{
query.Where.Conditions.Add(DQCondition.Like("Brand", argu.InputArgument));
}
return(query.EExecuteList <string>().Select((l)
=> new WordPair(l, l)));
}
private Control CreateReport()
{
var result = new TemplateBillReport();
var parameters = new Dictionary <string, object>();
parameters.Add("$CurrentUserName", BLContext.User.Name);
AddParameters(parameters);
var autoAdd = new Dictionary <string, object>();
foreach (KeyValuePair <string, object> pair in parameters)
{
if (pair.Value != null && pair.Value is ICollection)
{
string newKey = pair.Key + "_RecordCount";
if (!parameters.ContainsKey(newKey))
{
autoAdd.Add(newKey, ((ICollection)pair.Value).Count);
}
}
else if (pair.Value != null && pair.Value is LoadArguments)
{
string newKey = pair.Key + "_RecordCount";
if (!parameters.ContainsKey(newKey))
{
var loadArguments = new LoadArguments(((LoadArguments)pair.Value).DQuery.Clone() as DQueryDom);
loadArguments.DQuery.Range = SelectRange.Top(0);
var adapater = new DFDataAdapter(loadArguments);
var table = adapater.PagedFill();
autoAdd.Add(newKey, table.TotalCount);
}
}
}
foreach (KeyValuePair <string, object> pair in autoAdd)
{
parameters.Add(pair.Key, pair.Value);
}
var printTemplateFile = Path.Combine(Wpf.Settings.ConfigFolder, GetTemplateFile());
result.ParseTemplate(FS.OpenRead(printTemplateFile), parameters);
return(result);
}
public static bool TryGetID <TDmo>(ExecelImportColumn col, Row row, string fieldsName, ref long dmoID)
{
string name = default(string);
if (!col.TryGetValue(row, ref name))
{
return(false);
}
var logicName = DFInfo.Get(typeof(TDmo)).LogicName;
if (dmoID > 0)
{
var verifyNameQuery = new DQueryDom(new JoinAlias(typeof(TDmo)));
verifyNameQuery.Columns.Add(DQSelectColumn.Field(fieldsName));
verifyNameQuery.Where.Conditions.Add(DQCondition.EQ("ID", dmoID));
verifyNameQuery.Range = SelectRange.Top(1);
var verifyName = (string)verifyNameQuery.EExecuteScalar <string>();
if (verifyName != name)
{
throw new Exception(string.Format("{0}字段{4}:{1}和已得到ID:{2}上的名称:{3}不一致", logicName, name, dmoID, verifyName, fieldsName));
}
return(false);
}
var query = new DQueryDom(new JoinAlias(typeof(TDmo)));
if (TypeUtil.IsWithinDomain <TDmo>())
{
query.Where.Conditions.Add(DQCondition.EQ("Domain_ID", DomainContext.Current.ID));
}
query.Where.Conditions.Add(DQCondition.EQ(fieldsName, name));
query.Range = SelectRange.Top(2);
query.Columns.Add(DQSelectColumn.Field("ID"));
var result = query.EExecuteList <long>();
if (result.Count == 0)
{
throw new Exception(string.Format("未能发现字段{2}为{0}的{1}", name, logicName, fieldsName));
}
dmoID = result[0];
return(true);
}
// GET: History
public ActionResult Index()
{
if (Session["employee"] == null)
{
return(RedirectToAction("Login", "Login", new { returnurl = HttpContext.Request.Url }));
}
else
{
try
{
SelectRange datasource = new SelectRange();
datasource.ListofSites = new CSiteList();
datasource.ListofSites.Load();
return(View(datasource));
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
return(View());
}
}
}
private static IEnumerable <WordPair> SelectGoodsWithSpec(ChoiceBoxArgument argu, bool OnlyAvailable)
{
var query = new DQueryDom(new JoinAlias(typeof(Goods)));
query.Range = SelectRange.Top(30);
query.Columns.Add(DQSelectColumn.Field("Name"));
query.Columns.Add(DQSelectColumn.Field("Code"));
query.Columns.Add(DQSelectColumn.Field("ID"));
if (OnlyAvailable)
{
query.Where.Conditions.Add(DQCondition.EQ("Stopped", false));
}
if (!string.IsNullOrEmpty(argu.InputArgument))
{
IList <IDQExpression> conditions = new List <IDQExpression>();
conditions.Add(DQCondition.Like("Name", argu.InputArgument));
conditions.Add(DQCondition.Like("Spell", argu.InputArgument));
conditions.Add(DQCondition.Like("Code", argu.InputArgument));
query.Where.Conditions.Add(DQCondition.Or(conditions));
}
return(query.EExecuteList <string, string, long>().Select((l)
=> new WordPair(string.Concat(l.Item1, string.Concat("(", l.Item2, ")")), l.Item3.ToString())));
}
public Task SelectEnrolledCourses(Guid userId, SelectRange range)
{
throw new NotImplementedException();
}
public static List <GoodsInfoDto> GetProductInStoreTemplate(string input)
{
var list = new List <GoodsInfoDto>();
var productInStore = new JoinAlias(typeof(ProductInStoreTemplate));
var productInStoreGoods = new JoinAlias(typeof(ProductInStoreTemplate_GoodsDetail));
var goods = new JoinAlias(typeof(Goods));
var query = new DQueryDom(productInStoreGoods);
query.From.AddJoin(JoinType.Left, new DQDmoSource(productInStore), DQCondition.EQ(productInStore, "ID", productInStoreGoods, "ProductInStoreTemplate_ID"));
query.From.AddJoin(JoinType.Left, new DQDmoSource(goods), DQCondition.EQ(productInStoreGoods, "Goods_ID", goods, "ID"));
query.Range = SelectRange.Top(200);
query.Where.Conditions.Add(DQCondition.EQ(productInStore, "Stopped", false));
if (!string.IsNullOrWhiteSpace(input))
{
query.Where.Conditions.Add(DQCondition.Or(DQCondition.Like(goods, "Name", input), DQCondition.Like(goods, "Code", input), DQCondition.Like(goods, "Spell", input)));
}
query.OrderBy.Expressions.Add(DQOrderByExpression.Create(goods, "Name"));
query.OrderBy.Expressions.Add(DQOrderByExpression.Create(goods, "Code"));
query.Columns.Add(DQSelectColumn.Field("ID", goods));
query.Columns.Add(DQSelectColumn.Field("Name", goods));
query.Columns.Add(DQSelectColumn.Field("MainUnit", goods));
query.Columns.Add(DQSelectColumn.Field("SecondUnit", goods));
query.Columns.Add(DQSelectColumn.Field("UnitConvertDirection", goods));
query.Columns.Add(DQSelectColumn.Field("MainUnitRatio", goods));
query.Columns.Add(DQSelectColumn.Field("SecondUnitRatio", goods));
query.Columns.Add(DQSelectColumn.Field("Code", goods));
query.Columns.Add(DQSelectColumn.Field("GoodsProperty_ID", goods));
query.Columns.Add(DQSelectColumn.Field("GoodsProperty_Name", goods));
query.Columns.Add(DQSelectColumn.Field("GoodsPropertyCatalog_Name", goods));
query.Columns.Add(DQSelectColumn.Field("SecondUnitII", goods));
query.Columns.Add(DQSelectColumn.Field("SecondUnitII_MainUnitRatio", goods));
query.Columns.Add(DQSelectColumn.Field("SecondUnitII_SecondUnitRatio", goods));
query.Columns.Add(DQSelectColumn.Field("Spec", goods));
query.Distinct = true;
using (var session = Dmo.NewSession())
{
using (var reader = session.ExecuteReader(query))
{
while (reader.Read())
{
var dto = new GoodsInfoDto();
dto.Goods_ID = (long)reader[0];
dto.Goods_Name = (string)reader[1];
dto.Goods_MainUnit = (string)reader[2];
dto.Goods_SecondUnit = (string)reader[3];
dto.Goods_UnitConvertDirection = (NamedValue <主辅转换方向>?)reader[4];
dto.Goods_MainUnitRatio = (Money <decimal>?)reader[5];
dto.Goods_SecondUnitRatio = (Money <decimal>?)reader[6];
dto.Goods_Code = (string)reader[7];
if (dto.Goods_MainUnitRatio == null)
{
dto.Goods_MainUnitRatio = 1;
}
if (dto.Goods_SecondUnitRatio == null)
{
dto.Goods_SecondUnitRatio = 1;
}
dto.GoodsProperty_ID = (long?)reader[8];
dto.GoodsProperty_Name = (string)reader[9];
dto.GoodsPropertyCatalog_Name = (string)reader[10];
dto.SecondUnitII = (string)reader[11];
dto.SecondUnitII_MainUnitRatio = Convert.ToDecimal(reader[12]);
dto.SecondUnitII_SecondUnitRatio = Convert.ToDecimal(reader[13]);
dto.Goods_Spec = (string)(reader[14]);
list.Add(dto);
}
}
}
return(list);
}
internal static void Register()
{
ChoiceBoxSettings.Register(B3ButcheryDataSource.生产班组, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <BO.ProductShift>(argu)
{
OnlyAvailable = true
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.生产线, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <BO.ProductLine>(argu)
{
OnlyAvailable = true
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.车间品类, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <WorkshopCategory>(argu)
{
OnlyAvailable = true
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.类别分类, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <CategoryClassification>(argu)
{
OnlyAvailable = true
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.存货类别, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <GoodsCategory>(argu)
{
OnlyAvailable = true
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.计数名称, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <CalculateGoods>(argu)
{
OnlyAvailable = true
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.计数分类, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <CalculateCatalog>(argu)
{
OnlyAvailable = true
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.速冻库, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <FrozenStore>(argu)
{
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.生产线全部, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <BO.ProductLine>(argu)
{
OnlyAvailable = false
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.计划号, argu =>
{
var main = new JoinAlias(typeof(ProductPlan));
var query = new DQueryDom(main);
query.Range = SelectRange.Top(60);
query.Columns.Add(DQSelectColumn.Field("PlanNumber"));
query.Columns.Add(DQSelectColumn.Field("ID"));
query.Where.Conditions.Add(DQCondition.And(DQCondition.EQ("BillState", 单据状态.已审核),
DQCondition.EQ(main, "Domain_ID", DomainContext.Current.ID),
DQCondition.EQ("PlanNumbers", false)));
if (!string.IsNullOrEmpty(argu.InputArgument))
{
query.Where.Conditions.Add(DQCondition.Like("PlanNumber", argu.InputArgument));
}
if (!string.IsNullOrEmpty(argu.CodeArgument))
{
query.Where.Conditions.Add(DQCondition.EQ("Date", DateTime.Parse(argu.CodeArgument)));
}
query.OrderBy.Expressions.Add(DQOrderByExpression.Create("ID", true));
return(query.EExecuteList <string, long>().Select(x => new WordPair(x.Item1, x.Item2.ToString())));
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.货位, (argu) =>
{
if (string.IsNullOrEmpty(argu.CodeArgument))
{
return(EnumerableUtil.Null <WordPair>());
}
var query = new DQueryDom(new JoinAlias(typeof(CargoSpace)));
if (!string.IsNullOrEmpty(argu.CodeArgument))
{
var ss = argu.CodeArgument.Split(new[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
query.Where.Conditions.EFieldInList("Store_ID", ss);
}
query.Columns.Add(DQSelectColumn.Field("Name"));
query.Columns.Add(DQSelectColumn.Field("ID"));
query.OrderBy.Expressions.Add(
DQOrderByExpression.Create("ID"));
if (!string.IsNullOrEmpty(argu.InputArgument))
{
query.Where.Conditions.Add(DQCondition.Like("Name", argu.InputArgument));
}
return(ChoiceBoxQueryHelper.GetData(query));
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.生产环节, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <ProductLinks>(argu)
{
OnlyAvailable = true
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.生产环节全部, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <ProductLinks>(argu)
{
OnlyAvailable = false
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.屠宰分割入库类型, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <InStoreType>(argu)
{
OnlyAvailable = true
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.屠宰分割入库类型全部, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <InStoreType>(argu)
{
OnlyAvailable = false
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.存货带编号, (argu) =>
{
return(SelectGoodsWithSpec(argu, true));
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.存货带编号全部, (argu) =>
{
return(SelectGoodsWithSpec(argu, false));
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.存货品牌, (argu) =>
{
return(SelectGoodsBrand(argu));
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.成品入库模板, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <ProductInStoreTemplate>(argu)
{
OnlyAvailable = true
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.生产环节模板, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <ProductLinkTemplate>(argu)
{
OnlyAvailable = true
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.生产环节模板会计单位部门条件, SelectProductLinkTemplate);
ChoiceBoxSettings.Register(B3ButcheryDataSource.生产通知单ID, (argu) =>
{
var queryHelper = new DomainChoiceBoxQueryHelper <ProductNotice>(argu)
{
OnlyAvailable = false
};
queryHelper.AddSelectedField("ID");
queryHelper.SearchFields.Add("ID");
return(queryHelper.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.销售地区, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <ISaleZone>(argu)
{
OnlyAvailable = true
}.GetData());
});
ChoiceBoxSettings.Register(B3ButcheryDataSource.销售地区全部, (argu) =>
{
return(new DomainChoiceBoxQueryHelper <ISaleZone>(argu)
{
OnlyAvailable = false
}.GetData());
});
}
public setPanle(SelectRange range, double[] xaxis)
{
_range = range;
_xaxis = xaxis;
this.init(range.Begin, range.End);
}
