public static BG_IncomeCK AddBG_IncomeCK(BG_IncomeCK bG_IncomeCK) { string sql = "INSERT BG_IncomeCK (EIID, DepID, IACkMon, IATime)" + "VALUES (@EIID, @DepID, @IACkMon, @IATime)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@EIID", bG_IncomeCK.EIID), new SqlParameter("@DepID", bG_IncomeCK.DepID), new SqlParameter("@IACkMon", bG_IncomeCK.IACkMon), new SqlParameter("@IATime", bG_IncomeCK.IATime) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return(GetBG_IncomeCKByIKID(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_IncomeCK GetBG_IncomeCKByIKID(int iKID) { string sql = "SELECT * FROM BG_IncomeCK WHERE IKID = @IKID"; try { SqlParameter para = new SqlParameter("@IKID", iKID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_IncomeCK bG_IncomeCK = new BG_IncomeCK(); bG_IncomeCK.IKID = dt.Rows[0]["IKID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["IKID"]; bG_IncomeCK.EIID = dt.Rows[0]["EIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["EIID"]; bG_IncomeCK.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"]; bG_IncomeCK.IACkMon = dt.Rows[0]["IACkMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["IACkMon"]; bG_IncomeCK.IATime = dt.Rows[0]["IATime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["IATime"]; return(bG_IncomeCK); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static bool ModifyBG_IncomeCK(BG_IncomeCK bG_IncomeCK) { string sql = "UPDATE BG_IncomeCK " + "SET " + "EIID = @EIID, " + "DepID = @DepID, " + "IACkMon = @IACkMon, " + "IATime = @IATime " + "WHERE IKID = @IKID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@IKID", bG_IncomeCK.IKID), new SqlParameter("@EIID", bG_IncomeCK.EIID), new SqlParameter("@DepID", bG_IncomeCK.DepID), new SqlParameter("@IACkMon", bG_IncomeCK.IACkMon), new SqlParameter("@IATime", bG_IncomeCK.IATime) }; 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_IncomeCK(BG_IncomeCK bG_IncomeCK) { return(DeleteBG_IncomeCKByIKID(bG_IncomeCK.IKID)); }
public static bool ModifyBG_IncomeCK(BG_IncomeCK bG_IncomeCK) { return(BG_IncomeCKService.ModifyBG_IncomeCK(bG_IncomeCK)); }
public static bool DeleteBG_IncomeCK(BG_IncomeCK bG_IncomeCK) { return(BG_IncomeCKService.DeleteBG_IncomeCK(bG_IncomeCK)); }
public static BG_IncomeCK AddBG_IncomeCK(BG_IncomeCK bG_IncomeCK) { return(BG_IncomeCKService.AddBG_IncomeCK(bG_IncomeCK)); }