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 DeleteBG_Caliber(BG_Caliber bG_Caliber)
{
return DeleteBG_CaliberByCaliberID( bG_Caliber.CaliberID );
}
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;
}
}