public static BG_Caliber AddBG_Caliber(BG_Caliber bG_Caliber)
{
string sql =
"INSERT BG_Caliber (CaliberName, ParentID,CbLever)" +
"VALUES (@CaliberName, @ParentID)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@CaliberName", bG_Caliber.CaliberName),
new SqlParameter("@ParentID", bG_Caliber.ParentID),
new SqlParameter("@CbLever", bG_Caliber.CbLever)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return(GetBG_CaliberByCaliberID(newId));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_Caliber GetBG_CaliberByCaliberID(int caliberID)
{
string sql = "SELECT * FROM BG_Caliber WHERE CaliberID = @CaliberID";
try
{
SqlParameter para = new SqlParameter("@CaliberID", caliberID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_Caliber bG_Caliber = new BG_Caliber();
bG_Caliber.CaliberID = dt.Rows[0]["CaliberID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CaliberID"];
bG_Caliber.CaliberName = dt.Rows[0]["CaliberName"] == DBNull.Value ? "" : (string)dt.Rows[0]["CaliberName"];
bG_Caliber.ParentID = dt.Rows[0]["ParentID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["ParentID"];
bG_Caliber.CbLever = dt.Rows[0]["CbLever"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CbLever"];
return(bG_Caliber);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool ModifyBG_Caliber(BG_Caliber bG_Caliber)
{
string sql =
"UPDATE BG_Caliber " +
"SET " +
"CaliberName = @CaliberName, " +
"ParentID = @ParentID ," + "CbLever = @CbLever " +
"WHERE CaliberID = @CaliberID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@CaliberID", bG_Caliber.CaliberID),
new SqlParameter("@CaliberName", bG_Caliber.CaliberName),
new SqlParameter("@ParentID", bG_Caliber.ParentID),
new SqlParameter("@CbLever", bG_Caliber.CbLever)
};
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 DeleteBG_Caliber(BG_Caliber bG_Caliber)
{
return(DeleteBG_CaliberByCaliberID(bG_Caliber.CaliberID));
}
public static bool ModifyBG_Caliber(BG_Caliber bG_Caliber)
{
return(BG_CaliberService.ModifyBG_Caliber(bG_Caliber));
}
public static bool DeleteBG_Caliber(BG_Caliber bG_Caliber)
{
return(BG_CaliberService.DeleteBG_Caliber(bG_Caliber));
}
public static BG_Caliber AddBG_Caliber(BG_Caliber bG_Caliber)
{
return(BG_CaliberService.AddBG_Caliber(bG_Caliber));
}