/// <summary> /// 对象实体绑定数据(ProjectMachineProductionData) /// </summary> private ProjectMachineProductionData ReaderBind_PPJ(IDataReader dataReader) { ProjectMachineProductionData model = new ProjectMachineProductionData(); object ojb; ojb = dataReader["ppj_RecordID"]; if (ojb != null && ojb != DBNull.Value) { model.RecordID = new Guid(ojb.ToString()); } ojb = dataReader["ppj_SWLID"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_SWLID = new Guid(ojb.ToString()); } ojb = dataReader["ppj_iQCInterval"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iQCInterval = (int)ojb; } ojb = dataReader["ppj_iSpeed"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iSpeed = (int)ojb; } ojb = dataReader["ppj_iPertimeProdNum"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iPertimeProdNum = (int)ojb; } ojb = dataReader["ppj_dProjBeginTime"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_dProjBeginTime = (DateTime)ojb; } ojb = dataReader["ppj_dProdBeginTime"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_dProdBeginTime = (DateTime)ojb; } ojb = dataReader["ppj_dProdEndTime"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_dProdEndTime = (DateTime)ojb; } ojb = dataReader["ppj_iPredictPrepairTime"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iPredictPrepairTime = (int)ojb; } ojb = dataReader["ppj_iActualPrepairTime"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iActualPrepairTime = (int)ojb; } ojb = dataReader["ppj_iStopTime"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iStopTime = (int)ojb; } ojb = dataReader["ppj_iStopTimes"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iStopTimes = (int)ojb; } ojb = dataReader["ppj_iCountProdNum"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iCountProdNum = (int)ojb; } ojb = dataReader["ppj_iActualProdNum"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iActualProdNum = (int)ojb; } ojb = dataReader["ppj_fProdSpeed"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_fProdSpeed = (decimal)ojb; } ojb = dataReader["ppj_fMachineSpeed"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_fMachineSpeed = (decimal)ojb; } ojb = dataReader["ppj_iProjRunTime"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iProjRunTime = (int)ojb; } ojb = dataReader["ppj_iProdSumTime"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iProdSumTime = (int)ojb; } ojb = dataReader["ppj_iQCSumTime"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iQCSumTime = (int)ojb; } ojb = dataReader["ppj_iCountWastNum"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iCountWastNum = (int)ojb; } ojb = dataReader["ppj_iCountDefectiveQty"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iCountDefectiveQty = (int)ojb; } ojb = dataReader["ppj_iQualifiedQty"]; if (ojb != null && ojb != DBNull.Value) { model.ppj_iQualifiedQty = (int)ojb; } model.ppj_cItemStatus = dataReader["ppj_cItemStatus"].ToString(); model.ppj_cRemark = dataReader["ppj_cRemark"].ToString(); ojb = dataReader["ppj_lSync"]; ojb = dataReader["ppj_dAddDate"]; if (ojb != null && ojb != DBNull.Value) { model.AddDate = (DateTime)ojb; } ojb = dataReader["ppj_dLastDate"]; if (ojb != null && ojb != DBNull.Value) { model.LastDate = (DateTime)ojb; } return model; }
/// <summary> /// 新增生產工程的機台工程生產資料 /// </summary> /// <param name="model">model</param> /// <param name="tran">SqlTransaction</param> /// <returns></returns> public bool AddProjectMachineProductionData(ProjectMachineProductionData model, SqlTransaction tran) { try { MappingHelper.HandleNullProperty(model); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PrintProject_ppj("); strSql.Append("ppj_RecordID,ppj_SWLID,ppj_iQCInterval,ppj_iSpeed,ppj_iPertimeProdNum,ppj_dProjBeginTime,ppj_dProdBeginTime,ppj_dProdEndTime,ppj_iPredictPrepairTime,ppj_iActualPrepairTime,ppj_iStopTime,ppj_iStopTimes,ppj_iCountProdNum,ppj_iActualProdNum,ppj_fProdSpeed,ppj_fMachineSpeed,ppj_iProjRunTime,ppj_iProdSumTime,ppj_iQCSumTime,ppj_iCountWastNum,ppj_iCountDefectiveQty,ppj_iQualifiedQty,ppj_iPalletQty,ppj_cItemStatus,ppj_cDayRptRemark,ppj_cRemark,ppj_lSync,ppj_dAddDate,ppj_dLastDate,ppj_lActiveRecord,ppj_cMachineNO)"); strSql.Append(" values ("); strSql.Append("@ppj_RecordID,@ppj_SWLID,@ppj_iQCInterval,@ppj_iSpeed,@ppj_iPertimeProdNum,@ppj_dProjBeginTime,@ppj_dProdBeginTime,@ppj_dProdEndTime,@ppj_iPredictPrepairTime,@ppj_iActualPrepairTime,@ppj_iStopTime,@ppj_iStopTimes,@ppj_iCountProdNum,@ppj_iActualProdNum,@ppj_fProdSpeed,@ppj_fMachineSpeed,@ppj_iProjRunTime,@ppj_iProdSumTime,@ppj_iQCSumTime,@ppj_iCountWastNum,@ppj_iCountDefectiveQty,@ppj_iQualifiedQty,@ppj_iPalletQty,@ppj_cItemStatus,@ppj_cDayRptRemark,@ppj_cRemark,@ppj_lSync,@ppj_dAddDate,@ppj_dLastDate,@ppj_lActiveRecord,@ppj_cMachineNO)"); SqlParameter[] parameters = { DbHelperSQL.MakeInParam("@ppj_RecordID", SqlDbType.UniqueIdentifier,16, model.RecordID), DbHelperSQL.MakeInParam("@ppj_SWLID", SqlDbType.UniqueIdentifier,16, model.ppj_SWLID), DbHelperSQL.MakeInParam("@ppj_iQCInterval", SqlDbType.Int,4, model.ppj_iQCInterval), DbHelperSQL.MakeInParam("@ppj_iSpeed", SqlDbType.Int,4, model.ppj_iSpeed), DbHelperSQL.MakeInParam("@ppj_iPertimeProdNum", SqlDbType.Int,4, model.ppj_iPertimeProdNum), DbHelperSQL.MakeInParam("@ppj_dProjBeginTime", SqlDbType.DateTime, 0, model.ppj_dProjBeginTime), DbHelperSQL.MakeInParam("@ppj_dProdBeginTime", SqlDbType.DateTime,0, model.ppj_dProdBeginTime), DbHelperSQL.MakeInParam("@ppj_dProdEndTime", SqlDbType.DateTime,0, model.ppj_dProdEndTime), DbHelperSQL.MakeInParam("@ppj_iPredictPrepairTime", SqlDbType.Int,4, model.ppj_iPredictPrepairTime), DbHelperSQL.MakeInParam("@ppj_iActualPrepairTime", SqlDbType.Int,4, model.ppj_iActualPrepairTime), DbHelperSQL.MakeInParam("@ppj_iStopTime", SqlDbType.Int,4, model.ppj_iStopTime), DbHelperSQL.MakeInParam("@ppj_iStopTimes", SqlDbType.Int,4, model.ppj_iStopTimes), DbHelperSQL.MakeInParam("@ppj_iCountProdNum", SqlDbType.Int,4, model.ppj_iCountProdNum), DbHelperSQL.MakeInParam("@ppj_iActualProdNum", SqlDbType.Int,4, model.ppj_iActualProdNum), DbHelperSQL.MakeInParam("@ppj_fProdSpeed", SqlDbType.Decimal,9, model.ppj_fProdSpeed), DbHelperSQL.MakeInParam("@ppj_fMachineSpeed", SqlDbType.Decimal,9, model.ppj_fMachineSpeed), DbHelperSQL.MakeInParam("@ppj_iProjRunTime", SqlDbType.Int,4, model.ppj_iProjRunTime), DbHelperSQL.MakeInParam("@ppj_iProdSumTime", SqlDbType.Int,4, model.ppj_iProdSumTime), DbHelperSQL.MakeInParam("@ppj_iQCSumTime", SqlDbType.Int,4, model.ppj_iQCSumTime), DbHelperSQL.MakeInParam("@ppj_iCountWastNum", SqlDbType.Int,4, model.ppj_iCountWastNum), DbHelperSQL.MakeInParam("@ppj_iCountDefectiveQty", SqlDbType.Int,4, model.ppj_iCountDefectiveQty), DbHelperSQL.MakeInParam("@ppj_iQualifiedQty", SqlDbType.Int,4, model.ppj_iQualifiedQty), DbHelperSQL.MakeInParam("@ppj_iPalletQty", SqlDbType.Int,4, 0),//model.ppj_iPalletQty DbHelperSQL.MakeInParam("@ppj_cItemStatus", SqlDbType.NVarChar,10, model.ppj_cItemStatus), DbHelperSQL.MakeInParam("@ppj_cDayRptRemark", SqlDbType.NVarChar,260, ""), //model.ppj_cDayRptRemark DbHelperSQL.MakeInParam("@ppj_cRemark", SqlDbType.NVarChar,260, model.ppj_cRemark), DbHelperSQL.MakeInParam("@ppj_lSync", SqlDbType.Bit,1, 0), //model.ppj_lSync DbHelperSQL.MakeInParam("@ppj_dAddDate", SqlDbType.DateTime, 0, DateTime.Now), DbHelperSQL.MakeInParam("@ppj_dLastDate", SqlDbType.DateTime, 0, DateTime.Now), DbHelperSQL.MakeInParam("@ppj_lActiveRecord", SqlDbType.Bit,1, 1), //model.ppj_lActiveRecord; DbHelperSQL.MakeInParam("@ppj_cMachineNO", SqlDbType.VarChar,100, model.ppj_cMachineNo)}; DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, strSql.ToString(), parameters); return true; } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新生產工程的機台工程生產資料(只更新部份*務必請進入看清楚只更新哪些欄位*) /// </summary> /// <param name="model">model</param> /// <param name="tran">SqlTransaction</param> /// <returns></returns> public bool UpdateProjectMachineProductionData(ProjectMachineProductionData model, SqlTransaction tran) { try { ProjectMachineProductionData data_DB = this.GetProjectMachineProductionData("ppj_RecordID='" + model.RecordID + "'").FirstOrDefault(); StringBuilder strSql = new StringBuilder(); strSql.Append("update PrintProject_ppj set "); if (data_DB != null && data_DB.ppj_dProdBeginTime == null) //判斷“工程開始生產時間”是否為空(指DB裡的記錄) strSql.Append("ppj_dProdBeginTime=" + Common.General.HandleSqlFormatDateTime(model.ppj_dProdBeginTime) + ","); strSql.Append("ppj_iQCInterval=" + model.ppj_iQCInterval + ","); strSql.Append("ppj_iSpeed=" + model.ppj_iSpeed + ","); if (model.ppj_dProdEndTime.HasValue) strSql.Append("ppj_dProdEndTime=" + Common.General.HandleSqlFormatDateTime(model.ppj_dProdEndTime) + ","); strSql.Append("ppj_iPredictPrepairTime=" + model.ppj_iPredictPrepairTime + ","); strSql.Append("ppj_iActualPrepairTime=" + model.ppj_iActualPrepairTime + ","); strSql.Append("ppj_iStopTime=" + model.ppj_iStopTime + ","); strSql.Append("ppj_iStopTimes=" + model.ppj_iStopTimes + ","); strSql.Append("ppj_iCountProdNum=" + model.ppj_iCountProdNum + ","); strSql.Append("ppj_iActualProdNum=" + model.ppj_iActualProdNum + ","); //???已耗時不見了 //???備忘錄 strSql.Append("ppj_fProdSpeed=" + model.ppj_fProdSpeed + ","); strSql.Append("ppj_iProjRunTime=" + model.ppj_iProjRunTime + ","); strSql.Append("ppj_iProdSumTime=" + model.ppj_iProdSumTime + ","); strSql.Append("ppj_iQCSumTime=" + model.ppj_iQCSumTime + ","); //???品檢次數 strSql.Append("ppj_iCountWastNum=" + model.ppj_iCountWastNum + ","); strSql.Append("ppj_iCountDefectiveQty=" + model.ppj_iCountDefectiveQty + ","); strSql.Append("ppj_cItemStatus='" + Common.General.GetPropertyValue(model.ppj_cItemStatus) + "',"); strSql.Append("ppj_dLastDate=" + Common.General.HandleSqlFormatDateTime(DateTime.Now) + ","); strSql.Append("ppj_cMachineNO='" + model.ppj_cMachineNo + "',"); strSql.Append("ppj_iPertimeProdNum=" + model.ppj_iPertimeProdNum); strSql.Append(" where ppj_RecordID='" + model.RecordID + "' "); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, strSql.ToString(), null); return true; } catch (Exception ex) { throw ex; } }