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());
}
