public int LoadProductionSetDayDetailByMadeTotalAreal(ProductionSetDayDetail obj) { string sql = @"Select top 1 [ID] ,[SetID] ,[Datetime] ,[TotalAreal] ,[MadeTotalAreal] ,[WeekNo] From [BE_ProductionSetDayDetail] With(NoLock) where ([TotalAreal]-[MadeTotalAreal])>=@MadeTotalAreal order by [Datetime]"; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pMadeTotalAreal = new SqlParameter("MadeTotalAreal", Convert2DBnull(obj.MadeTotalAreal)); pMadeTotalAreal.SqlDbType = SqlDbType.Decimal; cmd.Parameters.Add(pMadeTotalAreal); int ret = 0; SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { ProductionSetDayDetail iret = new ProductionSetDayDetail(); if (!Convert.IsDBNull(dr["ID"])) { obj.ID = (Guid)dr["ID"]; } if (!Convert.IsDBNull(dr["SetID"])) { obj.SetID = (Guid)dr["SetID"]; } if (!Convert.IsDBNull(dr["Datetime"])) { obj.Datetime = (DateTime)dr["Datetime"]; } if (!Convert.IsDBNull(dr["TotalAreal"])) { obj.TotalAreal = (decimal)dr["TotalAreal"]; } if (!Convert.IsDBNull(dr["MadeTotalAreal"])) { obj.MadeTotalAreal = (decimal)dr["MadeTotalAreal"]; } if (!Convert.IsDBNull(dr["WeekNo"])) { obj.WeekNo = (int)dr["WeekNo"]; } ret++; } } finally { dr.Close(); } return(ret); }
public List <ProductionSetDayDetail> LoadProductionSetDayDetailByID(ProductionSetDayDetail obj) { string sql = @"Select [ID] ,[SetID] ,[Datetime] ,[TotalAreal] ,[MadeTotalAreal] ,[WeekNo] From [BE_ProductionSetDayDetail] With(NoLock) Where ID=@ID"; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pID = new SqlParameter("ID", Convert2DBnull(obj.ID)); pID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pID); List <ProductionSetDayDetail> ret = new List <ProductionSetDayDetail>(); SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { ProductionSetDayDetail iret = new ProductionSetDayDetail(); if (!Convert.IsDBNull(dr["ID"])) { iret.ID = (Guid)dr["ID"]; } if (!Convert.IsDBNull(dr["SetID"])) { iret.SetID = (Guid)dr["SetID"]; } if (!Convert.IsDBNull(dr["Datetime"])) { iret.Datetime = (DateTime)dr["Datetime"]; } if (!Convert.IsDBNull(dr["TotalAreal"])) { iret.TotalAreal = (decimal)dr["TotalAreal"]; } if (!Convert.IsDBNull(dr["MadeTotalAreal"])) { iret.MadeTotalAreal = (decimal)dr["MadeTotalAreal"]; } if (!Convert.IsDBNull(dr["WeekNo"])) { iret.WeekNo = (int)dr["WeekNo"]; } ret.Add(iret); } } finally { dr.Close(); } return(ret); }
public List <ProductionSetDayDetail> LoadProductionSetDayDetails() { string sql = @"Select [ID] ,[SetID] ,[Datetime] ,[TotalAreal] ,[MadeTotalAreal] ,[WeekNo] From [BE_ProductionSetDayDetail] With(NoLock)"; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); List <ProductionSetDayDetail> ret = new List <ProductionSetDayDetail>(); SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { ProductionSetDayDetail iret = new ProductionSetDayDetail(); if (!Convert.IsDBNull(dr["ID"])) { iret.ID = (Guid)dr["ID"]; } if (!Convert.IsDBNull(dr["SetID"])) { iret.SetID = (Guid)dr["SetID"]; } if (!Convert.IsDBNull(dr["Datetime"])) { iret.Datetime = (DateTime)dr["Datetime"]; } if (!Convert.IsDBNull(dr["TotalAreal"])) { iret.TotalAreal = (decimal)dr["TotalAreal"]; } if (!Convert.IsDBNull(dr["MadeTotalAreal"])) { iret.MadeTotalAreal = (decimal)dr["MadeTotalAreal"]; } if (!Convert.IsDBNull(dr["WeekNo"])) { iret.WeekNo = (int)dr["WeekNo"]; } ret.Add(iret); } } finally { dr.Close(); } return(ret); }
public int InsertProductionSetDayDetail(ProductionSetDayDetail obj) { string sql = @"Insert Into [BE_ProductionSetDayDetail]( [ID] ,[SetID] ,[Datetime] ,[TotalAreal] ,[MadeTotalAreal] ,[WeekNo] )Values ( @ID ,@SetID ,@Datetime ,@TotalAreal ,@MadeTotalAreal ,@WeekNo )"; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pID = new SqlParameter("ID", Convert2DBnull(obj.ID)); pID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pID); SqlParameter pSetID = new SqlParameter("SetID", Convert2DBnull(obj.SetID)); pSetID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pSetID); SqlParameter pDatetime = new SqlParameter("Datetime", Convert2DBnull(obj.Datetime)); pDatetime.SqlDbType = SqlDbType.SmallDateTime; cmd.Parameters.Add(pDatetime); SqlParameter pTotalAreal = new SqlParameter("TotalAreal", Convert2DBnull(obj.TotalAreal)); pTotalAreal.SqlDbType = SqlDbType.Decimal; cmd.Parameters.Add(pTotalAreal); SqlParameter pMadeTotalAreal = new SqlParameter("MadeTotalAreal", Convert2DBnull(obj.MadeTotalAreal)); pMadeTotalAreal.SqlDbType = SqlDbType.Decimal; cmd.Parameters.Add(pMadeTotalAreal); SqlParameter pWeekNo = new SqlParameter("WeekNo", Convert2DBnull(obj.WeekNo)); pWeekNo.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(pWeekNo); return(cmd.ExecuteNonQuery()); }
public int UpdateProductionSetDayDetailByID(ProductionSetDayDetail obj) { string sql = @"Update [BE_ProductionSetDayDetail] Set [SetID]=@SetID ,[Datetime]=@Datetime ,[TotalAreal]=@TotalAreal ,[MadeTotalAreal]=@MadeTotalAreal ,[WeekNo]=@WeekNo Where ID=@ID"; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pID = new SqlParameter("ID", Convert2DBnull(obj.ID)); pID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pID); SqlParameter pSetID = new SqlParameter("SetID", Convert2DBnull(obj.SetID)); pSetID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pSetID); SqlParameter pDatetime = new SqlParameter("Datetime", Convert2DBnull(obj.Datetime)); pDatetime.SqlDbType = SqlDbType.SmallDateTime; cmd.Parameters.Add(pDatetime); SqlParameter pTotalAreal = new SqlParameter("TotalAreal", Convert2DBnull(obj.TotalAreal)); pTotalAreal.SqlDbType = SqlDbType.Decimal; cmd.Parameters.Add(pTotalAreal); SqlParameter pMadeTotalAreal = new SqlParameter("MadeTotalAreal", Convert2DBnull(obj.MadeTotalAreal)); pMadeTotalAreal.SqlDbType = SqlDbType.Decimal; cmd.Parameters.Add(pMadeTotalAreal); SqlParameter pWeekNo = new SqlParameter("WeekNo", Convert2DBnull(obj.WeekNo)); pWeekNo.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(pWeekNo); return(cmd.ExecuteNonQuery()); }