/// <summary>
/// 工程生產數據查詢
/// </summary>
/// <param name="searchCondition">查詢條件</param>
/// <returns></returns>
public override List<ProjectProductionDataInfo_Query> SearchProjectProductionDatas(ProjectProductionDataInfo_Query_Search searchCondition)
{
try
{
List<ProjectProductionDataInfo_Query> lst = null;
ProjectProductionDataQueryBLL bll = new ProjectProductionDataQueryBLL();
lst = bll.SearchProjectProductionDatas(searchCondition);
return lst;
}
catch (Exception ex)
{
this.OnException(mc_strClassName, "SearchProjectProductionDatas", ex.Message);
throw;
}
}
/// <summary>
/// 工程生產數據查詢
/// </summary>
/// <param name="searchCondition">查詢條件</param>
/// <returns></returns>
public List<ProjectProductionDataInfo_Query> SearchProjectProductionDatas(ProjectProductionDataInfo_Query_Search searchCondition)
{
try
{
List<ProjectProductionDataInfo_Query> lst = new List<ProjectProductionDataInfo_Query>();
string l_strSQL = string.Empty;
string l_strWhere = string.Empty;
if (!string.IsNullOrEmpty(searchCondition.SearchMachineID))
{
l_strWhere += " And ppj.ppj_cMachineNO = '" + Common.General.HandleSqlSingle(searchCondition.SearchMachineID) + "' " + Environment.NewLine;
}
if (!string.IsNullOrEmpty(searchCondition.SearchProjectNO))
{
l_strWhere += " And swl.swl_cProjectNO like '" + Common.General.HandleSqlSingle(searchCondition.SearchProjectNO) + "%' " + Environment.NewLine;
}
if (!string.IsNullOrEmpty(searchCondition.SearchSONO))
{
l_strWhere += " And swl.swl_cSONO like '" + Common.General.HandleSqlSingle(searchCondition.SearchSONO) + "%' " + Environment.NewLine;
}
if (!string.IsNullOrEmpty(searchCondition.SearchItemNO))
{
l_strWhere += " And swl.swl_cItemNO like '" + Common.General.HandleSqlSingle(searchCondition.SearchItemNO) + "%' " + Environment.NewLine;
}
if (!string.IsNullOrEmpty(searchCondition.SearchProdName))
{
l_strWhere += " And swl.swl_cProdName like '" + Common.General.HandleSqlSingle(searchCondition.SearchProdName) + "%' " + Environment.NewLine;
}
if (!string.IsNullOrEmpty(searchCondition.SearchItemName))
{
l_strWhere += " And swl.swl_cItemName like '" + Common.General.HandleSqlSingle(searchCondition.SearchItemName) + "%' " + Environment.NewLine;
}
if (!string.IsNullOrEmpty(searchCondition.SearchProjStatus))
{
l_strWhere += " And swl.swl_cProjStatus = '" + Common.General.HandleSqlSingle(searchCondition.SearchProjStatus) + "' " + Environment.NewLine;
}
if (searchCondition.SearchDateBegin != DateTime.MinValue)
{
l_strWhere += " And ppj.ppj_dProjBeginTime >= " + Common.General.HandleSqlFormatDateTime(searchCondition.SearchDateBegin) + " " + Environment.NewLine;
}
if (searchCondition.SearchDateEnd != DateTime.MinValue)
{
l_strWhere += " And ppj.ppj_dProjBeginTime <= " + Common.General.HandleSqlFormatDateTime(searchCondition.SearchDateEnd.AddDays(1)) + " " + Environment.NewLine;
}
l_strSQL = l_strSQL + " Select" + Environment.NewLine;
l_strSQL = l_strSQL + " cProjectNO = swl.swl_cProjectNO," + Environment.NewLine;
l_strSQL = l_strSQL + " cSONO = swl.swl_cSONO," + Environment.NewLine;
l_strSQL = l_strSQL + " cRefSONo = ''," + Environment.NewLine;
l_strSQL = l_strSQL + " cDCSheetNO = swl.swl_cItemNO," + Environment.NewLine;
l_strSQL = l_strSQL + " cProductDesc = swl.swl_cProdName," + Environment.NewLine;
l_strSQL = l_strSQL + " cDCSheetName = swl.swl_cItemName," + Environment.NewLine;
l_strSQL = l_strSQL + " cProductType =swl.swl_cNature," + Environment.NewLine;
l_strSQL = l_strSQL + " cEditionDesc = swl.swl_cEdition," + Environment.NewLine;
l_strSQL = l_strSQL + " iSheetProdQty = swl.swl_iSheetProdQty," + Environment.NewLine;
l_strSQL = l_strSQL + " iPlanProdQty = swl.swl_iPlanProdQty," + Environment.NewLine;
l_strSQL = l_strSQL + " iRealYield = ppj.ppj_iActualProdNum," + Environment.NewLine;
l_strSQL = l_strSQL + " iWADQTY = 0," + Environment.NewLine;
l_strSQL = l_strSQL + " iAccountWastageQty = 0," + Environment.NewLine;
l_strSQL = l_strSQL + " iAccountDefectiveQty = ppj.ppj_iCountDefectiveQty," + Environment.NewLine;
l_strSQL = l_strSQL + " iAccountWasteQty = ppj.ppj_iCountWastNum," + Environment.NewLine;
l_strSQL = l_strSQL + " iFrontProcessDefectiveQty = 0," + Environment.NewLine;
l_strSQL = l_strSQL + " iAccountEligibleQty = ppj.ppj_iActualProdNum - ppj.ppj_iCountDefectiveQty - ppj.ppj_iCountWastNum," + Environment.NewLine;
//Begin Add By DonaldHuang 03/11/2015
//紙袋
l_strSQL = l_strSQL + " cPaperBagName = swl.swl_cPaperBagName," + Environment.NewLine;
l_strSQL = l_strSQL + " cPaperBagModel = swl.swl_cPaperBagModel," + Environment.NewLine;
l_strSQL = l_strSQL + " fPaperBagSizeW = swl.swl_fPaperBagSizeW," + Environment.NewLine;
l_strSQL = l_strSQL + " fPaperBagSizeH = swl.swl_fPaperBagSizeH," + Environment.NewLine;
l_strSQL = l_strSQL + " fPaperBagSizeG = swl.swl_fPaperBagSizeG," + Environment.NewLine;
l_strSQL = l_strSQL + " cPaperBagSizeUnit = swl.swl_cPaperBagSizeUnit," + Environment.NewLine;
l_strSQL = l_strSQL + " cPaperBagQuality = swl.swl_cPaperBagQuality," + Environment.NewLine;
//End Add By DonaldHuang 03/11/2015
l_strSQL = l_strSQL + " dBeginTime = ppj.ppj_dProjBeginTime," + Environment.NewLine;
l_strSQL = l_strSQL + " dProductBeginTime = ppj.ppj_dProdBeginTime," + Environment.NewLine;
l_strSQL = l_strSQL + " dEndTime = ppj.ppj_dProdEndTime," + Environment.NewLine;
l_strSQL = l_strSQL + " cTotalRunTime = ''," + Environment.NewLine;
l_strSQL = l_strSQL + " cTotalStopTime = ''," + Environment.NewLine;
l_strSQL = l_strSQL + " cTotalReadyTime = ''," + Environment.NewLine;
l_strSQL = l_strSQL + " iProjRunTime = ppj.ppj_iProjRunTime," + Environment.NewLine;
l_strSQL = l_strSQL + " iStopTime = ppj.ppj_iStopTime," + Environment.NewLine;
l_strSQL = l_strSQL + " iActualPrepairTime = ppj.ppj_iActualPrepairTime" + Environment.NewLine;
l_strSQL = l_strSQL + " From PrintProject_ppj ppj" + Environment.NewLine;
l_strSQL = l_strSQL + " Inner join ScheduleProjList_swl swl on ppj.ppj_SWLID = swl.swl_RecordID" + Environment.NewLine;
if (l_strWhere != "")
{
l_strSQL = l_strSQL + " Where 1=1 " + l_strWhere + Environment.NewLine;
}
l_strSQL = l_strSQL + " Order By ppj.ppj_dProjBeginTime" + Environment.NewLine;
using (IDataReader dataReader = DbHelperSQL.ExecuteReader(l_strSQL))
{
while (dataReader.Read())
{
ProjectProductionDataInfo_Query model = new ProjectProductionDataInfo_Query();
object ojb;
model.cProjectNO = dataReader["cProjectNO"].ToString();
model.cSONO = dataReader["cSONO"].ToString();
model.cRefSONo = "";
model.cDCSheetNO = dataReader["cDCSheetNO"].ToString();
model.cProductDesc = dataReader["cProductDesc"].ToString();
model.cDCSheetName = dataReader["cDCSheetName"].ToString();
model.cProductType = dataReader["cProductType"].ToString();
model.cEditionDesc = dataReader["cEditionDesc"].ToString();
//Begin Add By DonaldHuang 03/11/2015
model.cPaperBagName = dataReader["cPaperBagName"].ToString();
model.cPaperBagModel = dataReader["cPaperBagModel"].ToString();
model.fPaperBagSizeW = float.Parse(dataReader["fPaperBagSizeW"].ToString());
model.fPaperBagSizeH = float.Parse(dataReader["fPaperBagSizeH"].ToString());
model.fPaperBagSizeG = float.Parse(dataReader["fPaperBagSizeG"].ToString());
model.cPaperBagSizeUnit = dataReader["cPaperBagSizeUnit"].ToString();
model.cPaperBagQuality = dataReader["cPaperBagQuality"].ToString();
//End Add By DonaldHuang 03/11/2015
ojb = dataReader["iSheetProdQty"];
if (ojb != null && ojb != DBNull.Value)
{
model.iSheetProdQty = (int)ojb;
}
ojb = dataReader["iPlanProdQty"];
if (ojb != null && ojb != DBNull.Value)
{
model.iPlanProdQty = (int)ojb;
}
ojb = dataReader["iRealYield"];
if (ojb != null && ojb != DBNull.Value)
{
model.iRealYield = (int)ojb;
}
model.iWADQTY = 0;
model.iAccountWastageQty = 0;
ojb = dataReader["iAccountDefectiveQty"];
if (ojb != null && ojb != DBNull.Value)
{
model.iAccountDefectiveQty = (int)ojb;
}
ojb = dataReader["iAccountWasteQty"];
if (ojb != null && ojb != DBNull.Value)
{
model.iAccountWasteQty = (int)ojb;
}
model.iFrontProcessDefectiveQty = 0;
ojb = dataReader["iAccountEligibleQty"];
if (ojb != null && ojb != DBNull.Value)
{
model.iAccountEligibleQty = (int)ojb;
}
ojb = dataReader["dBeginTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.dBeginTime = (DateTime)ojb;
}
ojb = dataReader["dProductBeginTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.dProductBeginTime = (DateTime)ojb;
}
ojb = dataReader["dEndTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.dEndTime = (DateTime)ojb;
}
ojb = dataReader["iProjRunTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.iProjRunTime = (int)ojb;
model.cTotalRunTime = Common.Util.DateUtil.Convert(model.iProjRunTime.Value);
}
else
{
model.cTotalRunTime = "";
}
ojb = dataReader["iStopTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.iStopTime = (int)ojb;
model.cTotalStopTime = Common.Util.DateUtil.Convert(model.iStopTime.Value);
}
else
{
model.cTotalStopTime = "";
}
ojb = dataReader["iActualPrepairTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.iActualPrepairTime = (int)ojb;
model.cTotalReadyTime = Common.Util.DateUtil.Convert(model.iActualPrepairTime.Value);
}
else
{
model.cTotalReadyTime = "";
}
lst.Add(model);
}
dataReader.Close();
}
int indexvalue = 1;
foreach (ProjectProductionDataInfo_Query oEarchRecord in lst)
{
oEarchRecord.iIndex = indexvalue;
indexvalue++;
}
return lst;
}
catch (Exception ex)
{
throw ex;
}
}
private ProjectProductionDataInfo_Query_Search GetSearchInfo()
{
ProjectProductionDataInfo_Query_Search oReturn = new ProjectProductionDataInfo_Query_Search();
if (this.m_frmProjectCommonQueryBase.ComboBoxMachines.Text != "")
{
oReturn.SearchMachineID = this.m_frmProjectCommonQueryBase.ComboBoxMachines.SelectedValue.ToString();
}
if (this.m_frmProjectCommonQueryBase.TextBoxProjectNo.Text.Trim() != "")
{
oReturn.SearchProjectNO = this.m_frmProjectCommonQueryBase.TextBoxProjectNo.Text.Trim();
}
if (this.m_frmProjectCommonQueryBase.TextBoxSONo.Text.Trim() != "")
{
oReturn.SearchSONO = this.m_frmProjectCommonQueryBase.TextBoxSONo.Text.Trim();
}
if (this.m_frmProjectCommonQueryBase.TextBoxItemNo.Text.Trim() != "")
{
oReturn.SearchItemNO = this.m_frmProjectCommonQueryBase.TextBoxItemNo.Text.Trim();
}
if (this.m_frmProjectCommonQueryBase.TextBoxProdName.Text.Trim() != "")
{
oReturn.SearchProdName = this.m_frmProjectCommonQueryBase.TextBoxProdName.Text.Trim();
}
if (this.m_frmProjectCommonQueryBase.TextBoxItemName.Text.Trim() != "")
{
oReturn.SearchItemName = this.m_frmProjectCommonQueryBase.TextBoxItemName.Text.Trim();
}
if (this.m_frmProjectCommonQueryBase.ComboBoxProdStatus.Text.Trim() != "")
{
oReturn.SearchProjStatus = this.m_frmProjectCommonQueryBase.ComboBoxProdStatus.SelectedValue.ToString();
}
if (this.m_frmProjectCommonQueryBase.DateTimePickerProdBeginMin.Checked == true)
{
oReturn.SearchDateBegin = this.m_frmProjectCommonQueryBase.DateTimePickerProdBeginMin.Value.Date;
}
if (this.m_frmProjectCommonQueryBase.DateTimePickerProdBeginMax.Checked == true)
{
oReturn.SearchDateEnd = this.m_frmProjectCommonQueryBase.DateTimePickerProdBeginMax.Value.Date;
}
return oReturn;
}
/// <summary> /// 工程生產數據查詢 /// </summary> /// <param name="searchCondition">查詢條件</param> /// <returns></returns> public abstract List<ProjectProductionDataInfo_Query> SearchProjectProductionDatas(ProjectProductionDataInfo_Query_Search searchCondition);
/// <summary>
/// 工程生產數據查詢
/// </summary>
/// <param name="searchCondition">查詢條件</param>
/// <returns></returns>
public List<ProjectProductionDataInfo_Query> SearchProjectProductionDatas(ProjectProductionDataInfo_Query_Search searchCondition)
{
ProjectProductionDataQueryDAL dal = new ProjectProductionDataQueryDAL();
return dal.SearchProjectProductionDatas(searchCondition);
}
