/// <summary>
/// 绑定用餐时间类型
/// </summary>
void BindMealTypeCombo()
{
List<IModelObject> listValues = new List<IModelObject>();
foreach (Common.DefineConstantValue.MealType item in Enum.GetValues(typeof(Common.DefineConstantValue.MealType)))
{
if (item != Common.DefineConstantValue.MealType.UnKnown)
{
ComboboxDataInfo value = new ComboboxDataInfo();
value.ValueMember = item.ToString();
value.DisplayMember = Common.DefineConstantValue.GetMealTypeDesc(item);
listValues.Add(value);
}
}
cbbMealType.SetDataSource(listValues);
cbbMealType.SelectedIndex = -1;
}
/// <summary>
/// 从字码主档中获得Combobox数据列表
/// </summary>
/// <param name="codeMasterKey1">主键一</param>
/// <returns></returns>
public List<ComboboxDataInfo> GetComboboxDataInfoListFromCodeMaster(string codeMasterKey1)
{
List<ComboboxDataInfo> comboboxDataInfoList = null;
List<CodeMasterInfo> codeMasterInfoList = null;
CodeMasterFindInfo codeMasterFindInfo = new CodeMasterFindInfo();
ICodeMasterDA iCodeMasterDA = null;
codeMasterFindInfo.CmtCKey1 = codeMasterKey1;
iCodeMasterDA = CodeMasterDAFactory.Instance.GetCodeMasterDA();
try
{
codeMasterInfoList = iCodeMasterDA.FindRecord(codeMasterFindInfo);
}
catch (Exception Ex)
{
throw Ex;
}
if (codeMasterInfoList != null)
{
if (codeMasterInfoList.Count > 0)
{
ComboboxDataInfo comboboxDataInfo = null;
comboboxDataInfoList = new List<ComboboxDataInfo>();
for (int i = 0; i < codeMasterInfoList.Count; i++)
{
comboboxDataInfo = new ComboboxDataInfo();
comboboxDataInfo.DisplayMember = codeMasterInfoList[i].CmtCValue;
comboboxDataInfo.ValueMember = codeMasterInfoList[i].CmtCKey2;
comboboxDataInfoList.Add(comboboxDataInfo);
}
}
}
return comboboxDataInfoList;
}
/// <summary>
/// 取得區域信息 by SIMON
/// </summary>
/// <returns></returns>
private List<ComboboxDataInfo> GetAreaMaster()
{
List<Model.General.ComboboxDataInfo> infoList = new List<Model.General.ComboboxDataInfo>();
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
IQueryable<AreaMaster_amr> areaInfo = from t in db.AreaMaster_amr
orderby t.amr_cAreaName
select t;
if (areaInfo != null && areaInfo.Count() > 0)
{
foreach (AreaMaster_amr item in areaInfo)
{
Model.General.ComboboxDataInfo info = new Model.General.ComboboxDataInfo();
info.DisplayMember = item.amr_cAreaName;
info.ValueMember = item.amr_cRecordID.ToString();
infoList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
/// <summary>
/// 獲取維修要求--維修級別
/// </summary>
/// <returns></returns>
private List<ComboboxDataInfo> GetMaintenanceLevel()
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
try
{
ICodeMasterDA da = SQLiteDAFacotry.GetDAL<ICodeMasterDA>(SQLiteDAFacotry.CodeMasterDA);
CodeMaster_cmt_Info cmtInfo = new CodeMaster_cmt_Info();
cmtInfo.cmt_cKey1 = Common.DefineConstantValue.CodeMasterDefine.KEY1_PPCFORMITEM;
cmtInfo.cmt_cKey2 = Common.DefineConstantValue.CodeMasterDefine.KEY2_PPCFORMITEM_MAINTENANCELEVEL;
Dictionary<string, object> param = new Dictionary<string, object>();
param.Add("cmt_cKey1", cmtInfo.cmt_cKey1);
param.Add("cmt_cKey2", cmtInfo.cmt_cKey2);
List<CodeMaster_cmt_Info> listCmt = da.GetEntities<CodeMaster_cmt_Info>(param).ToList();
if (listCmt != null && listCmt.Count > 0)
{
foreach (CodeMaster_cmt_Info cmtItem in listCmt)
{
ComboboxDataInfo info = new ComboboxDataInfo();
info.DisplayMember = cmtItem.cmt_cRemark;
info.ValueMember = cmtItem.cmt_cValue.ToString();
infoList.Add(info);
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
void BindComboBox_ShiftTypeCode()
{
CodeMaster_cmt_Info searchInfo = new CodeMaster_cmt_Info();
searchInfo.cmt_cKey1 = Common.DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE;
searchInfo.cmt_cKey2 = Common.DefineConstantValue.CodeMasterDefine.KEY2_SHIFTTYPE;
List<IModelObject> listShiftTypeCode = this.m_codeMasterBLL.SearchRecords(searchInfo);
if (listShiftTypeCode != null && listShiftTypeCode.Count > 0)
{
List<IModelObject> listInfo = new List<IModelObject>();
foreach (CodeMaster_cmt_Info shiftTypeInfo in listShiftTypeCode)
{
if (shiftTypeInfo != null)
{
ComboboxDataInfo cbbInfo = new ComboboxDataInfo();
cbbInfo.DisplayMember = shiftTypeInfo.cmt_cRemark;
cbbInfo.ValueMember = shiftTypeInfo.cmt_cValue;
listInfo.Add(cbbInfo);
}
}
this.cboShiftTypeName.SetDataSource(listInfo);
this.cboShiftTypeName.SelectedIndex = -1;
}
}
private List<Model.General.ComboboxDataInfo> GetWinFormSkin()
{
List<Model.General.ComboboxDataInfo> infoList = new List<Model.General.ComboboxDataInfo>();
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
IQueryable<CodeMaster_cmt> taQuery =
from t in db.CodeMaster_cmt
where t.cmt_cKey1 == DefineConstantValue.CodeMasterDefine.KEY1_WINFORM_SKIN
orderby t.cmt_iRecordID ascending
select t;
if (taQuery.Count() > 0)
{
foreach (CodeMaster_cmt t in taQuery)
{
Model.General.ComboboxDataInfo info = new Model.General.ComboboxDataInfo();
info.DisplayMember = t.cmt_cKey2;
info.ValueMember = t.cmt_cValue.ToString();
infoList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
private void initMachineStatus()
{
List<IModelObject> list = new List<IModelObject>();
foreach (Common.DefineConstantValue.ConsumeMachineStatus usingType in Enum.GetValues(typeof(Common.DefineConstantValue.ConsumeMachineStatus)))
{
ComboboxDataInfo info = new ComboboxDataInfo();
info.DisplayMember = DefineConstantValue.GetMacUsingDesc(usingType);
info.ValueMember = usingType.ToString();
list.Add(info);
}
this.cmbMachineStatus.SetDataSource(list);
this.cmbMachineStatus.SelectedIndex = 0;
}
/// <summary>
/// 獲得機臺類型 by SIMON
/// </summary>
/// <returns></returns>
private List<ComboboxDataInfo> GetMachineType()
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
IEnumerable<CodeMaster_cmt> objKey = from t in db.CodeMaster_cmt
where t.cmt_cKey1 == Common.DefineConstantValue.CodeMasterDefine.KEY1_MACHINETYPE && t.cmt_cKey2 == Common.DefineConstantValue.CodeMasterDefine.KEY2_MACHINEMODEL
select t;
if (objKey != null && objKey.Count() > 0)
{
foreach (CodeMaster_cmt item in objKey)
{
ComboboxDataInfo info = new ComboboxDataInfo();
info.DisplayMember = item.cmt_cRemark;
info.ValueMember = item.cmt_cValue;
infoList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
/// <summary>
/// 獲取品檢問題解決問題內容
/// </summary>
/// <returns></returns>
private List<ComboboxDataInfo> GetQCMasterSettlement()
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
try
{
IQualityProblemMasterDA da = SQLiteDAFacotry.GetDAL<IQualityProblemMasterDA>(SQLiteDAFacotry.QualityProblemMaster);
QualityProblemMaster_qpm_Info qpmInfo = new QualityProblemMaster_qpm_Info() { qpm_lIsAtive = true }; ;
Dictionary<string, object> dicParam = new Dictionary<string, object>();
dicParam.Add("qpm_lIsAtive", qpmInfo.qpm_lIsAtive);
List<QualityProblemMaster_qpm_Info> listQCMaster = da.GetEntities<QualityProblemMaster_qpm_Info>(dicParam).ToList();
if (listQCMaster != null && listQCMaster.Count > 0)
{
foreach (QualityProblemMaster_qpm_Info qcmItem in listQCMaster)
{
ComboboxDataInfo info = new ComboboxDataInfo();
info.DisplayMember = qcmItem.qpm_cSuggestedTechnique;
info.ValueMember = qcmItem.qpm_iRecordID.ToString();
infoList.Add(info);
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
private List<ComboboxDataInfo> GetVacationWorkReason()
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
try
{
using (DBContext uow =new DBContext())
{
IList<CodeMaster_cmt_Info> objAll = uow.CurrentSession.QueryOver<CodeMaster_cmt_Info>().And(d => d.cmt_cKey1 == Common.DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE && d.cmt_cKey2 == Common.DefineConstantValue.CodeMasterDefine.KEY2_VACATIONWORKREASON).List();
if (objAll != null && objAll.Count > 0)
{
foreach (CodeMaster_cmt_Info item in objAll)
{
ComboboxDataInfo temp = new ComboboxDataInfo();
temp.DisplayMember = item.cmt_cRemark;
temp.ValueMember = item.cmt_cValue;
infoList.Add(temp);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
/// <summary>
/// 獲得工作組類型信息
/// </summary>
/// <returns></returns>
private List<ComboboxDataInfo> GetWorkGroupTypeInfos()
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
try
{
IWorkGroupTypeMasterDA da = SQLiteDAFacotry.GetDAL<IWorkGroupTypeMasterDA>(SQLiteDAFacotry.WorkGroupTypeMaster);
//WorkGroupTypeMaster_wgt_Info workTypeInfo = new WorkGroupTypeMaster_wgt_Info();
Dictionary<string, object> dicParam = new Dictionary<string, object>();
dicParam.Add("wgt_lIsAtive", true);
List<WorkGroupTypeMaster_wgt_Info> listSource = da.GetEntities<WorkGroupTypeMaster_wgt_Info>(dicParam).ToList();
if (listSource != null && listSource.Count > 0)
{
foreach (WorkGroupTypeMaster_wgt_Info item in listSource)
{
ComboboxDataInfo info = new ComboboxDataInfo();
info.DisplayMember = item.wgt_cWGTName;
info.ValueMember = item.wgt_iRecordID.ToString();
infoList.Add(info);
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
/// <summary>
/// 獲得符合日期的班次內工程信息
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private List<ComboboxDataInfo> GetShirtProjList(ProjectStopRecord_psrd_Info rrecordInfo)
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
try
{
using (DBContext uow = new DBContext())
{
string strSQL = string.Empty;
strSQL += "select spl_RecordID as ValueMember,swl_cItemName as DisplayMember" + Environment.NewLine;
strSQL += "from ShiftProjList_spl" + Environment.NewLine;
strSQL += "left join PrintProject_ppj" + Environment.NewLine;
strSQL += "on spl_PPJID=ppj_RecordID" + Environment.NewLine;
strSQL += "left join ScheduleProjList_swl" + Environment.NewLine;
strSQL += "on ppj_SWLID=swl_RecordID" + Environment.NewLine;
strSQL += "where" + Environment.NewLine;
strSQL += "((spl_dBeginTime<='" + rrecordInfo.psrd_dBeginTime.Value.ToString("yyyy-MM-dd HH:mm") + "' and spl_dEndTime >='" + rrecordInfo.psrd_dBeginTime.Value.ToString("yyyy-MM-dd HH:mm") + "' )" + Environment.NewLine;
strSQL += "or" + Environment.NewLine;
strSQL += "(spl_dBeginTime<='" + rrecordInfo.psrd_dEndTime.Value.ToString("yyyy-MM-dd HH:mm") + "' and spl_dEndTime >='" + rrecordInfo.psrd_dEndTime.Value.ToString("yyyy-MM-dd HH:mm") + "' ))" + Environment.NewLine;
ISQLQuery query = uow.CurrentSession.CreateSQLQuery(strSQL.ToString());
var s = query.List();
if (s != null)
{
foreach (object[] objItem in s)
{
ComboboxDataInfo info = new ComboboxDataInfo();
info.DisplayMember = objItem[1].ToString();
info.ValueMember = objItem[0].ToString();
infoList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
/// <summary>
/// 獲取非機長員工信息
/// </summary>
/// <returns></returns>
private List<ComboboxDataInfo> GetStaffMasterInfo(string strMacType)
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
try
{
IStaffInfoMasterDA da = SQLiteDAFacotry.GetDAL<IStaffInfoMasterDA>(SQLiteDAFacotry.StaffInfoMaster);
StaffInfoMaster_sim_Info stsaffInfo = new StaffInfoMaster_sim_Info();
Dictionary<string, object> dicParam = new Dictionary<string, object>();
dicParam.Add("sim_lIsCaptain", false);
dicParam.Add("sim_cMachineID", strMacType);
List<StaffInfoMaster_sim_Info> listCaptainMaster = da.GetEntities<StaffInfoMaster_sim_Info>(dicParam).ToList();
if (listCaptainMaster != null && listCaptainMaster.Count > 0)
{
foreach (StaffInfoMaster_sim_Info captainItem in listCaptainMaster)
{
ComboboxDataInfo info = new ComboboxDataInfo();
info.DisplayMember = captainItem.sim_cStaffNo.Trim() + "-" + captainItem.sim_cStaffName.Trim();
info.ValueMember = captainItem.sim_iRecordID.ToString();
infoList.Add(info);
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
/// <summary>
/// 取得特定班次內工程信息
/// </summary>
/// <param name="shiftRecordID">班次ID</param>
/// <returns></returns>
private List<ComboboxDataInfo> GetShiftProjList(string shiftRecordID)
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
string strSQL = string.Empty;
strSQL += "select spl_RecordID as ValueMember,swl_cItemName as DisplayMember" + Environment.NewLine;
strSQL += "from ShiftProjList_spl" + Environment.NewLine;
strSQL += "left join PrintProject_ppj" + Environment.NewLine;
strSQL += "on spl_PPJID=ppj_RecordID" + Environment.NewLine;
strSQL += "left join ScheduleProjList_swl" + Environment.NewLine;
strSQL += "on swl_RecordID=ppj_SWLID" + Environment.NewLine;
strSQL += "where spl_SIFOID='" + shiftRecordID.ToString() + "'" + Environment.NewLine;
try
{
using (DBContext uow =new DBContext())
{
ISQLQuery query = uow.CurrentSession.CreateSQLQuery(strSQL);
var s = query.List();
if (s != null)
{
foreach (object[] objItem in s)
{
ComboboxDataInfo info = new ComboboxDataInfo();
if (objItem[1] != null)
info.DisplayMember = objItem[1].ToString();
else
info.DisplayMember = "";
info.ValueMember = objItem[0].ToString();
infoList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
private List<ComboboxDataInfo> GetShiftMaster()
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
IList<ShiftTypeMaster_stm_Info> infos = null;
try
{
using (DBContext db = new DBContext())
{
infos = db.CurrentSession.QueryOver<ShiftTypeMaster_stm_Info>().And(d => d.stm_lIsAtive == true).List();
if (infos != null)
{
foreach (ShiftTypeMaster_stm_Info item in infos)
{
ComboboxDataInfo cbo = new ComboboxDataInfo(item.stm_cShiftName, item.stm_iRecordID.ToString());
infoList.Add(cbo);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
/// <summary>
/// 獲取品檢問題解決辦法
/// </summary>
/// <returns></returns>
private List<ComboboxDataInfo> GetQCSettlement()
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
try
{
ICodeMasterDA da = SQLiteDAFacotry.GetDAL<ICodeMasterDA>(SQLiteDAFacotry.CodeMasterDA);
CodeMaster_cmt_Info cmtInfo = new CodeMaster_cmt_Info();
cmtInfo.cmt_cKey1 = Common.DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE;
cmtInfo.cmt_cKey2 = Common.DefineConstantValue.CodeMasterDefine.KEY2_TYPEVALUE_QCSETTLEMENT;
Dictionary<string, object> dicParam = new Dictionary<string, object>();
dicParam.Add("cmt_cKey1", cmtInfo.cmt_cKey1);
dicParam.Add("cmt_cKey2", cmtInfo.cmt_cKey2);
List<CodeMaster_cmt_Info> listCmt = da.GetEntities<CodeMaster_cmt_Info>(dicParam).ToList();
if (listCmt != null && listCmt.Count > 0)
{
foreach (CodeMaster_cmt_Info cmtItem in listCmt)
{
ComboboxDataInfo info = new ComboboxDataInfo();
info.DisplayMember = cmtItem.cmt_cRemark;
info.ValueMember = cmtItem.cmt_iRecordID.ToString();
infoList.Add(info);
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
private List<Model.General.ComboboxDataInfo> GetCodeMaster(string key)
{
List<Model.General.ComboboxDataInfo> infoList = new List<Model.General.ComboboxDataInfo>();
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
IQueryable<CodeMaster_cmt> taQuery =
from t in db.CodeMaster_cmt
where t.cmt_cKey1 == key.ToString()
orderby t.cmt_cKey2 ascending
select t;
if (taQuery.Count() > 0)
{
foreach (CodeMaster_cmt t in taQuery)
{
Model.General.ComboboxDataInfo info = new Model.General.ComboboxDataInfo();
info.DisplayMember = t.cmt_cValue;
info.ValueMember = t.cmt_cKey2;
infoList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
private List<ComboboxDataInfo> GetShiftTypeMaster()
{
List<Model.General.ComboboxDataInfo> infoList = new List<Model.General.ComboboxDataInfo>();
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
IQueryable<ShiftTypeMaster_stm> allType = from t in db.ShiftTypeMaster_stm
orderby t.stm_dAddDate ascending
select t;
if (allType != null && allType.Count() > 0)
{
foreach (ShiftTypeMaster_stm item in allType)
{
Model.General.ComboboxDataInfo info = new Model.General.ComboboxDataInfo();
info.DisplayMember = item.stm_cShiftName;
info.ValueMember = item.stm_iRecordID.ToString();
infoList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
private List<Model.General.ComboboxDataInfo> GetCodeMaster_Key2(string CodeMaster_Key1)
{
List<Model.General.ComboboxDataInfo> infoList = new List<Model.General.ComboboxDataInfo>();
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
var taQuery =
(from t in db.CodeMaster_cmt
where t.cmt_cKey1 == CodeMaster_Key1
select new { name = t.cmt_cKey2 }).Distinct();
if (taQuery.Count() > 0)
{
foreach (var t in taQuery)
{
Model.General.ComboboxDataInfo info = new Model.General.ComboboxDataInfo();
info.DisplayMember = t.name;
info.ValueMember = t.name;
infoList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
/// <summary>
/// SQLite 获取沒有停機原因的班次信息 by SIMON
/// </summary>
/// <returns></returns>
private List<ComboboxDataInfo> GetShiftTypeMaster_NoStopReason()
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
string strSQL = string.Empty;
strSQL += "SELECT " + Environment.NewLine;
strSQL += " sifo_RecordID AS ValueMember , " + Environment.NewLine;
strSQL += " date( sifo_dProdDate ) + ' ' + stm_cShiftName AS DisplayMember " + Environment.NewLine;
strSQL += "FROM" + Environment.NewLine;
strSQL += " ShiftInfo_sifo LEFT JOIN " + Environment.NewLine;
strSQL += "ShiftTypeMaster_stm ON stm_iRecordID = sifo_iSTMID " + Environment.NewLine;
strSQL += "WHERE" + Environment.NewLine;
strSQL += "sifo_RecordID IN " + Environment.NewLine;
strSQL += "( " + Environment.NewLine;
strSQL += "SELECT " + Environment.NewLine;
strSQL += " spl_SIFOID " + Environment.NewLine;
strSQL += "FROM" + Environment.NewLine;
strSQL += "ShiftProjList_spl " + Environment.NewLine;
strSQL += "WHERE" + Environment.NewLine;
strSQL += "spl_RecordID IN " + Environment.NewLine;
strSQL += "(" + Environment.NewLine;
strSQL += "SELECT" + Environment.NewLine;
strSQL += "psrd_SPLID " + Environment.NewLine;
strSQL += "FROM" + Environment.NewLine;
strSQL += "ProjectStopRecord_psrd LEFT JOIN " + Environment.NewLine;
strSQL += "ProjectStopReason_pjsr ON pjsr_PSRDID = psrd_RecordID" + Environment.NewLine;
strSQL += "WHERE" + Environment.NewLine;
strSQL += "(psrd_dBeginTime+7 )>=date() " + Environment.NewLine;
strSQL += " ) " + Environment.NewLine;
strSQL += " ) " + Environment.NewLine;
try
{
using (DBContext uow =new DBContext())
{
ISQLQuery query = uow.CurrentSession.CreateSQLQuery(strSQL);
ArrayList objs = (ArrayList)query.List();
foreach (Object[] obj in objs)
{
ComboboxDataInfo comb = new ComboboxDataInfo();
comb.ValueMember = obj[0].ToString();
comb.DisplayMember = obj[1].ToString();
infoList.Add(comb);
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
/// <summary>
/// 获取打印机类型信息 by SIMON
/// </summary>
/// <returns></returns>
private List<ComboboxDataInfo> GetPinterMachineType()
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
IQueryable<CodeMaster_cmt> PinterMachineTypeList = from t in db.CodeMaster_cmt
where t.cmt_cKey1 == DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE && t.cmt_cKey2 == DefineConstantValue.CodeMasterDefine.KEY2_TYPEVALUE_PRINTER
select t;
if (PinterMachineTypeList.Count() > 0)
{
foreach (CodeMaster_cmt item in PinterMachineTypeList)
{
ComboboxDataInfo info = new ComboboxDataInfo();
info.DisplayMember = item.cmt_cRemark;
info.ValueMember = item.cmt_cValue;
infoList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
/// <summary>
/// 獲取維修要求--子結構
/// </summary>
/// <param name="strParentID"></param>
/// <returns></returns>
private List<ComboboxDataInfo> GetMaintenanceSubStructKey(string strParentID)
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
try
{
using (DBContext uow =new DBContext())
{
StringBuilder strSql = new StringBuilder();
strSql.AppendLine("select stt_cKey2,stt_cDesc from StructureMaster_stt ");
strSql.AppendLine("where stt_cKey2 <> '00000000-0000-0000-0000-000000000000' ");
strSql.AppendLine("and stt_cKey3 = '00000000-0000-0000-0000-000000000000' ");
strSql.AppendLine("and stt_cKey1 = '" + strParentID + "'");
ISQLQuery query = uow.CurrentSession.CreateSQLQuery(strSql.ToString());
IList listData = query.List();
if (listData != null)
{
foreach (object[] item in listData)
{
ComboboxDataInfo info = new ComboboxDataInfo();
info.DisplayMember = item[1].ToString();
info.ValueMember = item[0].ToString();
infoList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
/// <summary>
/// 获取班次信息 (最大行數) by SIMON
/// </summary>
/// <returns></returns>
private List<ComboboxDataInfo> GetShiftTypeMaster(int maxLimit)
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
var ShiftInfo = (from t in db.ShiftInfo_sifo
join b in db.ShiftTypeMaster_stm on t.sifo_iSTMID
equals b.stm_iRecordID
orderby t.sifo_dProdDate descending, b.stm_cBeginTime ascending
select new { DisplayMember = (t.sifo_dProdDate != null ? t.sifo_dProdDate.Value.ToString("yyyy-MM-dd") : "") + b.stm_cShiftName, ValueMember = t.sifo_RecordID.ToString() }).Take(maxLimit);
if (ShiftInfo != null)
{
foreach (var item in ShiftInfo)
{
ComboboxDataInfo info = new ComboboxDataInfo();
info.DisplayMember = item.DisplayMember;
info.ValueMember = item.ValueMember;
infoList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
private void initCardUseState()
{
List<IModelObject> list = new List<IModelObject>();
ComboboxDataInfo cmbInfo1 = new ComboboxDataInfo();
cmbInfo1.DisplayMember = "使用中";
cmbInfo1.ValueMember = DefineConstantValue.CardUseState.InUse.ToString();
list.Add(cmbInfo1);
ComboboxDataInfo cmbInfo2 = new ComboboxDataInfo();
cmbInfo2.DisplayMember = "未使用";
cmbInfo2.ValueMember = DefineConstantValue.CardUseState.NotUsed.ToString();
list.Add(cmbInfo2);
ComboboxDataInfo cmbInfo = new ComboboxDataInfo();
cmbInfo.DisplayMember = "全部";
cmbInfo.ValueMember = "";
list.Add(cmbInfo);
this.cmbCardState.SetDataSource(list);
this.cmbCardState.SelectedIndex = list.Count - 1;
}
/// <summary>
/// 停机原因类型
/// </summary>
/// <returns></returns>
private List<ComboboxDataInfo> GetStopReasonType()
{
List<Model.General.ComboboxDataInfo> infoList = new List<Model.General.ComboboxDataInfo>();
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
IEnumerable<CodeMaster_cmt> allInfo = from t in db.CodeMaster_cmt
where t.cmt_cKey1 == DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE && t.cmt_cKey2 == DefineConstantValue.CodeMasterDefine.KEY2_STOPREASONTYPE
select t;
if (allInfo != null && allInfo.Count() > 0)
{
foreach (CodeMaster_cmt item in allInfo)
{
Model.General.ComboboxDataInfo info = new Model.General.ComboboxDataInfo();
info.DisplayMember = item.cmt_cRemark;
info.ValueMember = item.cmt_cValue;
infoList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
/// <summary>
/// 初始部門下拉框
/// </summary>
private void initUserDepartment()
{
List<IModelObject> list = _igBM.GetMasterDataInformations(Common.DefineConstantValue.MasterType.UserDepartment);
if (list == null)
{
list = new List<IModelObject>();
}
ComboboxDataInfo cmbInfo = new ComboboxDataInfo();
cmbInfo.DisplayMember = "全部";
cmbInfo.ValueMember = "";
list.Add(cmbInfo);
this.cmbUserDepartment.SetDataSource(list);
this.cmbUserDepartment.SelectedIndex = list.Count() - 1;
}
private void initConsumeMachineType()
{
List<IModelObject> listValues = new List<IModelObject>();
foreach (Common.DefineConstantValue.ConsumeMachineType item in Enum.GetValues(typeof(Common.DefineConstantValue.ConsumeMachineType)))
{
if (item != Common.DefineConstantValue.ConsumeMachineType.Unknown)
{
ComboboxDataInfo value = new ComboboxDataInfo();
value.ValueMember = item.ToString();
value.DisplayMember = Common.DefineConstantValue.GetMacTypeDesc(item);
listValues.Add(value);
}
}
cmbType.SetDataSource(listValues);
cmbType.SelectedIndex = -1;
}
private void initMachineType()
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
foreach (Common.DefineConstantValue.ConsumeMachineType macType in Enum.GetValues(typeof(Common.DefineConstantValue.ConsumeMachineType)))
{
ComboboxDataInfo info = new ComboboxDataInfo();
info.DisplayMember = DefineConstantValue.GetMacTypeDesc(macType);
info.ValueMember = macType.ToString();
infoList.Add(info);
}
ComboboxDataInfo infoTotal = new ComboboxDataInfo();
infoTotal.DisplayMember = "全部";
infoTotal.ValueMember = string.Empty;
infoList.Add(infoTotal);
this.cmbMachineType.DataSource = infoList;
this.cmbMachineType.DisplayMember = "DisplayMember";
this.cmbMachineType.ValueMember = "ValueMember";
this.cmbMachineType.SelectedIndex = infoList.Count - 1;
}
/// <summary>
/// 绑定消费机模式值
/// </summary>
void BindComboDeviceMode()
{
List<IModelObject> listValues = new List<IModelObject>();
foreach (EnumDeviceMode item in Enum.GetValues(typeof(EnumDeviceMode)))
{
if (item != EnumDeviceMode.Unknown)
{
ComboboxDataInfo value = new ComboboxDataInfo();
value.ValueMember = ((int)item).ToString();
value.DisplayMember = EumExchangeTool.GetEumModeName(item);
listValues.Add(value);
}
}
cbxDeviceMode.SetDataSource(listValues);
cbxDeviceMode.SelectedIndex = -1;
}
/// <summary>
/// 獲取需要的班次信息（现为7天内）
/// </summary>
/// <param name="strMacNum">機台編號</param>
/// <returns></returns>
private List<ComboboxDataInfo> GetCurrentShiftInfo(string strMacNum)
{
List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>();
try
{
IShiftInfoDA shiftInfoDA = SQLiteDAFacotry.GetDAL<IShiftInfoDA>(SQLiteDAFacotry.ShiftInfo);
IShiftTypeMasterDA shiftMasterDA = SQLiteDAFacotry.GetDAL<IShiftTypeMasterDA>(SQLiteDAFacotry.ShiftTypeMaster);
Dictionary<string, object> dicParam = new Dictionary<string, object>();
List<ShiftInfo_sifo_Info> listShiftInfo = shiftInfoDA.GetEntities<ShiftInfo_sifo_Info>(dicParam).ToList();
IList<ShiftTypeMaster_stm_Info> listShiftMaster = shiftMasterDA.GetEntities<ShiftTypeMaster_stm_Info>(dicParam);
if (listShiftInfo != null)
{
listShiftInfo = listShiftInfo.Where(x => x.sifo_dProdDate.Date <= DateTime.Now.Date && x.sifo_dProdDate >= DateTime.Now.Date.AddDays(-6) && x.sifo_cMachineNO == strMacNum).ToList();
}
if (listShiftInfo != null && listShiftInfo.Count > 0 && listShiftMaster != null && listShiftMaster.Count > 0)
{
foreach (ShiftTypeMaster_stm_Info masterItem in listShiftMaster)
{
ShiftInfo_sifo_Info shiftInfo = listShiftInfo.Where(x => x.sifo_iSTMID == masterItem.stm_iRecordID).FirstOrDefault();
if (shiftInfo != null)
{
ComboboxDataInfo info = new ComboboxDataInfo();
info.DisplayMember = masterItem.stm_cShiftName + "【" + shiftInfo.sifo_dBeginTime.Value.ToString("yyyy/MM/dd HH:mm") + "-" + shiftInfo.sifo_dEndTime.Value.ToString("HH:mm") + "】";
info.ValueMember = shiftInfo.sifo_RecordID.ToString().ToUpper();
infoList.Add(info);
}
else
{
ComboboxDataInfo info = new ComboboxDataInfo();
info.DisplayMember = masterItem.stm_cShiftName + "【" + DateTime.Now.ToString("yyyy/MM/dd") + " " + masterItem.stm_cBeginTime + "-" + masterItem.stm_cEndTime + "】";
info.ValueMember = Guid.Empty.ToString();
infoList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return infoList;
}
