/// <summary> /// 新增工程實時生產數據 /// </summary> /// <param name="model">model</param> /// <param name="tran">SqlTransaction</param> /// <returns></returns> public bool AddProjectRealTimeProductionData(ProjectRealTimeProductionData model, SqlTransaction tran) { try { MappingHelper.HandleNullProperty(model); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ProjectRealTimeProductionData_prtd("); strSql.Append("prtd_ShiftProjectID,prtd_dRealTimeDataTime,prtd_iProductionQty)"); strSql.Append(" values ("); strSql.Append("@prtd_ShiftProjectID,@prtd_dRealTimeDataTime,@prtd_iProductionQty)"); SqlParameter[] parameters = { DbHelperSQL.MakeInParam("@prtd_ShiftProjectID", SqlDbType.UniqueIdentifier,16,model.ShiftProjectID), DbHelperSQL.MakeInParam("@prtd_dRealTimeDataTime", SqlDbType.SmallDateTime,0,model.RealTimeDataTime), DbHelperSQL.MakeInParam("@prtd_iProductionQty", SqlDbType.Int,4,model.ProductionQty)}; DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, strSql.ToString(), parameters); return true; } catch (Exception ex) { throw ex; } }
/// <summary> /// 对象实体绑定数据(ProjectRealTimeProductionData) /// </summary> private ProjectRealTimeProductionData ReaderBind_PRTD(IDataReader dataReader) { ProjectRealTimeProductionData model = new ProjectRealTimeProductionData(); object ojb; ojb = dataReader["prtd_ShiftProjectID"]; if (ojb != null && ojb != DBNull.Value) { model.ShiftProjectID = new Guid(ojb.ToString()); } ojb = dataReader["prtd_dRealTimeDataTime"]; if (ojb != null && ojb != DBNull.Value) { model.RealTimeDataTime = (DateTime)ojb; } ojb = dataReader["prtd_iProductionQty"]; if (ojb != null && ojb != DBNull.Value) { model.ProductionQty = (int)ojb; } return model; }
/// <summary> /// 新增一條工程實時生產數據對象 /// </summary> public override void AddProjectRealTimeProductionData(ProjectRealTimeProductionData RealTimeData) { if (RealTimeData == null) { return; } if (this.m_queueRealTimeProduction == null) { this.m_queueRealTimeProduction = new Queue<ProjectRealTimeProductionData>(); } try { this.m_queueRealTimeProduction.Enqueue(RealTimeData); } catch (Exception ex) { base.OnException(mc_strControllerName, "AddProjectRealTimeProductionData", ex.Message); } }
/// <summary> /// 工程的生產原始數據反序列化後的數據對象上傳到服務器數據庫中 /// </summary> /// <param name="projectRealTimeProductionData">生產原始數據</param> /// <returns></returns> public bool SynFirstProjectRealTimeProductionDataToDB(ProjectRealTimeProductionData projectRealTimeProductionData) { try { bool l_lIsSuess = false; using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { SqlTransaction transaction = null; conn.Open(); //開啟連接 transaction = conn.BeginTransaction(); //開啟事務 try { //★ this.m_objProductionDataSynDAL.AddProjectRealTimeProductionData(projectRealTimeProductionData, transaction); l_lIsSuess = true; } catch (Exception exTran) { l_lIsSuess = false; throw exTran; } finally { if (l_lIsSuess) transaction.Commit(); else transaction.Rollback(); } return true; } } catch (Exception ex) { throw ex; } }
/// <summary> /// 新增一條工程實時生產數據對象 /// </summary> /// <param name="RealTimeData"></param> public abstract void AddProjectRealTimeProductionData(ProjectRealTimeProductionData RealTimeData);