public static BG_DataRecord AddBG_DataRecord(BG_DataRecord bG_DataRecord)
{
string sql =
"INSERT BG_DataRecord (DRType, DRTime, DRName, IsBackUp)" +
"VALUES (@DRType, @DRTime, @DRName, @IsBackUp)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@DRType", bG_DataRecord.DRType),
new SqlParameter("@DRTime", bG_DataRecord.DRTime),
new SqlParameter("@DRName", bG_DataRecord.DRName),
new SqlParameter("@IsBackUp", bG_DataRecord.IsBackUp)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return GetBG_DataRecordByDRID(newId);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_DataRecord GetBG_DataRecordByDRID(int dRID)
{
string sql = "SELECT * FROM BG_DataRecord WHERE DRID = @DRID";
try
{
SqlParameter para = new SqlParameter("@DRID", dRID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if(dt.Rows.Count > 0)
{
BG_DataRecord bG_DataRecord = new BG_DataRecord();
bG_DataRecord.DRID = dt.Rows[0]["DRID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DRID"];
bG_DataRecord.DRType = dt.Rows[0]["DRType"] == DBNull.Value ? "" : (string)dt.Rows[0]["DRType"];
bG_DataRecord.DRTime = dt.Rows[0]["DRTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["DRTime"];
bG_DataRecord.DRName = dt.Rows[0]["DRName"] == DBNull.Value ? "" : (string)dt.Rows[0]["DRName"];
bG_DataRecord.IsBackUp = dt.Rows[0]["IsBackUp"] == DBNull.Value ? "" : (string)dt.Rows[0]["IsBackUp"];
return bG_DataRecord;
}
else
{
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool DeleteBG_DataRecord(BG_DataRecord bG_DataRecord)
{
return DeleteBG_DataRecordByDRID( bG_DataRecord.DRID );
}
public static bool ModifyBG_DataRecord(BG_DataRecord bG_DataRecord)
{
string sql =
"UPDATE BG_DataRecord " +
"SET " +
"DRType = @DRType, " +
"DRTime = @DRTime, " +
"DRName = @DRName, " +
"IsBackUp = @IsBackUp " +
"WHERE DRID = @DRID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@DRID", bG_DataRecord.DRID),
new SqlParameter("@DRType", bG_DataRecord.DRType),
new SqlParameter("@DRTime", bG_DataRecord.DRTime),
new SqlParameter("@DRName", bG_DataRecord.DRName),
new SqlParameter("@IsBackUp", bG_DataRecord.IsBackUp)
};
int t = DBUnity.ExecuteNonQuery(CommandType.Text, sql, para);
if(t>0)
{
return true;
}
else
{
return false;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool ModifyBG_DataRecord(BG_DataRecord bG_DataRecord)
{
return BG_DataRecordService.ModifyBG_DataRecord(bG_DataRecord);
}
public static bool DeleteBG_DataRecord(BG_DataRecord bG_DataRecord)
{
return BG_DataRecordService.DeleteBG_DataRecord(bG_DataRecord);
}
public static BG_DataRecord AddBG_DataRecord(BG_DataRecord bG_DataRecord)
{
return BG_DataRecordService.AddBG_DataRecord(bG_DataRecord);
}
