public RptCovid19ExController(Covid19Context context, IConfiguration pconfiguration)
{
model = new RptCovid19ExBOModel(context);
listModel = new SelectListModel(context);
configuration = pconfiguration;
}
public Covid19HealthCheck2Controller(Covid19Context context, IConfiguration pconfiguration)
{
model = new CovidHealthCheckBOModel(context);
listModel = new SelectListModel(context);
configuration = pconfiguration;
}
public UpdateBatForm(batchInfo model)
{
InitializeComponent();
this.batModel = model;
siloNoCB.DataSource = SelectListModel.SiloNumList().Keys.ToList();
gradeCB.DataSource = SelectListModel.GradeList();
}
/// <summary>
/// 批次Tab切换
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AddBatNoTabControl_SelectedIndexChanged(object sender, EventArgs e)
{
if (this.AddBatNoTabControl.SelectedTab.Text.Equals("新建批次"))
{
string cNo = this.GetCNO(this.AddBatNoTabControl.SelectedTab.Text);
if (!string.IsNullOrEmpty(cNo))
{
txt_batchNo.Text = "J" + productTypeCB.Text + workLineCB.SelectedValue + DateTime.Now.ToString("yyMMdd") + cNo;
}
workLineCB.DataSource = SelectListModel.WorkLineList().Keys.ToList();
txt_siloNo.DataSource = SelectListModel.SiloNumList().Keys.ToList();
nbtWeightCB.DataSource = SelectListModel.NbtWeightList();
gradeCB.DataSource = SelectListModel.GradeList();
}
else
{
string cNo = this.GetCNO(this.AddBatNoTabControl.SelectedTab.Text);
if (!string.IsNullOrEmpty(cNo))
{
txt_bNo.Text = "J" + pdTypeCB.Text + wkLineCB.SelectedValue + DateTime.Now.ToString("yyMMdd") + cNo;
}
wkLineCB.DataSource = SelectListModel.WorkLineList().Keys.ToList();
txt_siloNum.DataSource = SelectListModel.SiloNumList().Keys.ToList();
txt_nbt.DataSource = SelectListModel.NbtWeightList();
txt_grade.DataSource = SelectListModel.GradeList();
}
}
public async Task <IActionResult> Report_PerformanceGrow_Data(SelectListModel model)
{
var ids = JsonConvert.DeserializeObject <List <string> >(model.ItemValue);
var data = await _SY_ReportService.Users_PerformanceGrow(ids);
return(Json(data));
}
public List <SelectList_Item> Get_Quan(int ID_ThanhPho = 1)
{
var dbModel = new SelectListModel();
List <SelectList_Item> list = dbModel.Get_Quan(ID_ThanhPho);
return(list);
}
public List <SelectList_Item> Get_ThanhPho()
{
var dbModel = new SelectListModel();
List <SelectList_Item> list = dbModel.Get_ThanhPho();
return(list);
}
private void UpdateBatForm_Load(object sender, EventArgs e)
{
nbtWeightCB.DataSource = SelectListModel.NbtWeightList();
workLineCB.Text = batModel.workLine;
txt_characteristics.Text = batModel.characteristics;
siloNoCB.Text = batModel.siloNo;
gradeCB.Text = batModel.grade;
dtp_productDate.Value = (DateTime)batModel.productDate;
nbtWeightCB.Text = batModel.ntbWeight.ToString();
}
public MainForm(Configuration cfa)
{
packagebll.AfterPrinted = (success, result) =>
{
string customSN = this.customSn.Text;
this.Invoke(new Action(() =>
{
if (success)
{
sn.Text = result;
if (string.IsNullOrEmpty(customSN))
{
customSn.Text = result;
}
else
{
string cNo = (Convert.ToInt32(customSN.Substring(12)) + 1).ToString();
if (cNo.Length < 3)
{
cNo = cNo.PadLeft(3, '0');
}
customSn.Text = customSN.Remove(12, 3).Insert(12, cNo);
}
}
}));
};
InitializeComponent();
GetAllInitInfo(this.Controls[0]);
sn.Text = packagebll.GetSNInfo(UserBLL.userInfo.WorkLine).Value;
customSn.Text = sn.Text;
dic = SelectListModel.SiloNumList();
//siloNum.DataSource = dic.Keys.ToList();
//txt_grade.DataSource = SelectListModel.GradeList();
//txt_workLine.DataSource = SelectListModel.WorkLineList().Keys.ToList();
packType.DataSource = SelectListModel.PackTypeList();
if (this.TabControl.SelectedTab.Text.Equals("标签打印"))
{
footPanl.Visible = false;
}
#region 打印记录初始化
txt_sPackageDate.Text = "";
txt_ePackageDate.Text = "";
txt_printDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
#endregion
#region 打印汇总
txt_startPackageDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
txt_endPackageDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
#endregion
this.version.Text = "V" + Assembly.GetExecutingAssembly().GetName().Version;
CFA = cfa;
}
public SelectListModel CountHOME(string fromdate, string todate)
{
//Model send back
var model = new SelectListModel();
var card = _tblCardService.GetCount(fromdate, todate).ToList().Count;
var customer = _tblCustomerService.GetAll().ToList().Count;
model.ItemText = card.ToString();
model.ItemValue = customer.ToString();
return(model);
}
private void dtp_bNoCrDate_ValueChanged(object sender, EventArgs e)
{
string workline = string.Empty;
string productType = string.Empty;
if (wkLineCB.SelectedValue != null)
{
workline = SelectListModel.WorkLineList()[wkLineCB.SelectedValue.ToString()];
}
if (!string.IsNullOrEmpty(this.pdTypeCB.Text))
{
productType = pdTypeCB.Text.Substring(pdTypeCB.Text.Length - 1);
}
string cNo = this.GetCNO(this.AddBatNoTabControl.SelectedTab.Text, dtp_bNoCrDate.Value);
DateTime selectTime = dtp_bNoCrDate.Value;
txt_bNo.Text = "J" + productType + workline + selectTime.ToString("yyMMdd") + cNo;
}
public async Task <ResultModel <List <SelectListModel> > > GetCategories()
{
_logger.LogInformation("GetCategories called.");
var categories = await _categoryRepository.ListAllAsync();
var items = new List <SelectListModel>();
foreach (Category category in categories)
{
var ctg = new SelectListModel {
Id = category.Id, Name = category.Name
};
items.Add(ctg);
}
return(items.ToResultModel());
}
public async Task <ResultModel <List <SelectListModel> > > GetSuppliers()
{
_logger.LogInformation("GetSuppliers called.");
var suppliers = await _supplierRepository.ListAllAsync();
var items = new List <SelectListModel>();
foreach (Supplier supplier in suppliers)
{
var splr = new SelectListModel {
Id = supplier.Id, Name = supplier.Name
};
items.Add(splr);
}
return(items.ToResultModel());
}
private void productTypeCB_SelectedValueChanged(object sender, EventArgs e)
{
string workline = string.Empty;
string productType = string.Empty;
if (workLineCB.SelectedValue != null)
{
workline = SelectListModel.WorkLineList()[workLineCB.SelectedValue.ToString()];
}
if (!string.IsNullOrEmpty(this.productTypeCB.Text))
{
productType = productTypeCB.Text.Substring(productTypeCB.Text.Length - 1);
}
string cNo = this.GetCNO(this.AddBatNoTabControl.SelectedTab.Text);
if (!string.IsNullOrEmpty(cNo))
{
txt_batchNo.Text = "J" + productType + workline + DateTime.Now.ToString("yyMMdd") + cNo;
}
}
public PartialViewResult ControllerStatus(string lineid, string controllerid)
{
var url = "";
var t = _tblAccessLineService.GetById(Guid.Parse(lineid));
if (t != null)
{
var k = _SelfHostConfigService.GetByPCID(t.PCID);
if (k != null)
{
url = k.Address;
}
}
var result = FunctionHelper.CheckConnectController(url, controllerid);
var model = new SelectListModel()
{
ItemValue = result
};
return(PartialView(model));
}
public RptCovid19SummaryController(Covid19Context context)
{
model = new RptCovid19ExBOModel(context);
listModel = new SelectListModel(context);
}
public SelectListModel CountEventEveryDay(string fromdate, string todate)
{
//Model send back
var model = new SelectListModel();
//
var fdate = "";
var tdate = "";
int inNumber = 0;
int outNumber = 0;
//Check using Loop
var check = _tblLaneService.GetAllActive().FirstOrDefault(n => n.IsLoop == true);
//Date time
if (!string.IsNullOrWhiteSpace(fromdate) && !string.IsNullOrWhiteSpace(todate))
{
fdate = Convert.ToDateTime(fromdate).ToString("yyyy/MM/dd 00:00:00");
tdate = Convert.ToDateTime(todate).AddDays(1).ToString("yyyy/MM/dd 00:00:00");
}
else
{
fdate = DateTime.Now.ToString("yyyy/MM/dd 00:00:00");
tdate = DateTime.Now.AddDays(1).ToString("yyyy/MM/dd 00:00:00");
}
//IN
var sqlCardEventIN = new StringBuilder();
sqlCardEventIN.AppendLine("SELECT * from tblCardEvent WITH (NOLOCK)");
sqlCardEventIN.AppendLine("WHERE IsDelete = 0");
sqlCardEventIN.AppendLine(string.Format("AND ( DateTimeIn >= '{0}' AND DateTimeIn < '{1}' )", fdate, tdate));
var cardeIN = SqlExQuery <tblCardEvent> .ExcuteQuery(sqlCardEventIN.ToString()).Count;
inNumber += cardeIN;
if (check != null)
{
var sqlLoopEventIN = new StringBuilder();
sqlLoopEventIN.AppendLine("SELECT * from tblLoopEvent WITH (NOLOCK)");
sqlLoopEventIN.AppendLine("WHERE IsDelete = 0 AND EventCode = '2'");
sqlLoopEventIN.AppendLine(string.Format("AND ( DateTimeIn >= '{0}' AND DateTimeIn < '{1}' )", fdate, tdate));
var loopeIN = SqlExQuery <tblLoopEvent> .ExcuteQuery(sqlLoopEventIN.ToString()).Count;
inNumber += loopeIN;
}
//OUT
var sqlCardEventOUT = new StringBuilder();
sqlCardEventOUT.AppendLine("SELECT * from tblCardEvent WITH (NOLOCK)");
sqlCardEventOUT.AppendLine("WHERE IsDelete = 0 AND EventCode = '2'");
sqlCardEventOUT.AppendLine(string.Format("AND ( DateTimeOut >= '{0}' AND DateTimeOut < '{1}' )", fdate, tdate));
var cardeOUT = SqlExQuery <tblCardEvent> .ExcuteQuery(sqlCardEventOUT.ToString()).Count;
outNumber += cardeOUT;
if (check != null)
{
var sqlLoopEventOUT = new StringBuilder();
sqlLoopEventOUT.AppendLine("SELECT * from tblLoopEvent WITH (NOLOCK)");
sqlLoopEventOUT.AppendLine("where IsDelete = 0 AND EventCode = '2'");
sqlLoopEventOUT.AppendLine(string.Format("AND ( DateTimeOut >= '{0}' AND DateTimeOut < '{1}' )", fdate, tdate));
var loopeOUT = SqlExQuery <tblLoopEvent> .ExcuteQuery(sqlLoopEventOUT.ToString()).Count;
outNumber += loopeOUT;
}
model.ItemValue = inNumber.ToString();
model.ItemText = outNumber.ToString();
return(model);
}
