get => EnsureListManager(dataSource, dataMember);
public GanttChart GetDailyProduction(string cdate, int lineid) //date format : dd/MM/yyyy { DateTime startdate = Convert.ToDateTime(cdate); DateTime enddate = Convert.ToDateTime(cdate).AddDays(1); IList <OrderDetail> orderdetail = db.OrderDetails //.Include(o => o.Line) .Include(o => o.Product) //.Include(o => o.Shift) .Where(o => o.CreatedDate.Year == startdate.Year && o.CreatedDate.Month == startdate.Month && o.CreatedDate.Day == startdate.Day && o.LineId == lineid && o.FinalStatus == 1) .OrderBy(x => x.OrderId).ToList(); var count = orderdetail.Count; GanttChart objganttchart = new GanttChart(); objganttchart.type = "gantt"; objganttchart.width = "100%"; objganttchart.height = "120"; objganttchart.dataFormat = "json"; dataSource objdatasource = new dataSource(); //chart chart objchart = new chart(); objchart.theme = "fusion"; objchart.dateformat = "dd/mm/yyyy hh:mn"; objchart.showTaskLabels = 1; //task gtask[] arrtask = new gtask[count]; for (int i = 0; i < count; i++) { var objtask = new gtask(); objtask.label = orderdetail[i].Product.ProductDesc; objtask.processid = "A"; objtask.start = orderdetail[i].OrderStartTime.ToString("dd/MM/yyyy HH:mm"); DateTime endtime = orderdetail[i].OrderEndTime ?? DateTime.Now; objtask.end = endtime.ToString("dd/MM/yyyy HH:mm"); objtask.color = "#" + orderdetail[i].Product.ProductColor; objtask.alpha = "85"; arrtask[i] = objtask; } gtasks objtasks = new gtasks(); objtasks.task = arrtask; //processes processes objprocesses = new processes(); process[] arrprocess = new process[1]; process objprocess = new process(); objprocess.label = orderdetail[0].OrderStartTime.ToString("dd/MM/yyyy"); objprocess.id = "A"; arrprocess[0] = objprocess; objprocesses.isbold = "1"; objprocesses.process = arrprocess; //categories categories[] arrcategories = new categories[1]; categories objcategories = new categories(); objcategories.bgalpha = "0"; //category1 category[] arrcategory1 = new category[1]; category objcategory1 = new category(); objcategory1.start = startdate.ToString("dd/MM/yyyy 06:00"); objcategory1.end = enddate.ToString("dd/MM/yyyy 06:00"); objcategory1.label = ""; arrcategory1[0] = objcategory1; objcategories.category1 = arrcategory1; //category category[] arrcategory = new category[24]; int arrcategorycount = arrcategory.Length; for (int i = 0; i < arrcategorycount; i++) { int k = i + 1; int stime = 6 + i; int etime = 6 + k; int starttime = stime >= 24 ? stime - 24 : stime; int endtime = etime >= 24 ? etime - 24 : etime; string startimeformat = starttime.ToString().Length == 1 ? "0" + starttime.ToString() + ":00" : starttime.ToString() + ":00"; string endtimeformat = endtime.ToString().Length == 1 ? "0" + endtime.ToString() + ":00" : endtime.ToString() + ":00"; category objcategory = new category(); objcategory.start = stime >= 24 ? enddate.ToString("dd/MM/yyyy " + startimeformat + "") : startdate.ToString("dd/MM/yyyy " + startimeformat + ""); objcategory.end = stime >= 23 ? enddate.ToString("dd/MM/yyyy " + endtimeformat + "") : startdate.ToString("dd/MM/yyyy " + endtimeformat + ""); objcategory.label = startimeformat; arrcategory[i] = objcategory; } objcategories.category = arrcategory; arrcategories[0] = objcategories; objdatasource.chart = objchart; objdatasource.tasks = objtasks; objdatasource.processes = objprocesses; objdatasource.categories = arrcategories; objganttchart.dataSource = objdatasource; return(objganttchart); }
new DataSourceConfiguration ( dataSource: settings.DataSource,
/// <summary> /// Setting dsa_dataSource argument /// </summary> /// <param name="dataSource">Value for dsa_dataSource</param> /// <returns>Instruction</returns> public docScriptInstruction arg(dataSource dataSource) { this.add(docScriptArguments.dsa_dataSource, dataSource); return(this); }
public dal_imp() { ds = new dataSource(); }
get => Get(ref dataSource, nameof(DataSource));
=> BinaryFindKey(dataSource, Encoding1252.GetBytes(key), offset);
SetCnnStr( dataSource , dbName , user , password );
) => SetCnnStr(dataSource, dbName);
HasRightsFunc = BuildLookup(dataSource, subscriberID);