public static BG_OutlayCK AddBG_OutlayCK(BG_OutlayCK bG_OutlayCK) { string sql = "INSERT BG_OutlayCK (PIID, PPID, DepID, OACkMon, OATime, OACkType)" + "VALUES (@PIID, @PPID, @DepID, @OACkMon, @OATime, @OACkType)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PIID", bG_OutlayCK.PIID), new SqlParameter("@PPID", bG_OutlayCK.PPID), new SqlParameter("@DepID", bG_OutlayCK.DepID), new SqlParameter("@OACkMon", bG_OutlayCK.OACkMon), new SqlParameter("@OATime", bG_OutlayCK.OATime), new SqlParameter("@OACkType", bG_OutlayCK.OACkType) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return GetBG_OutlayCKByOAID(newId); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static bool ModifyBG_OutlayCK(BG_OutlayCK bG_OutlayCK) { return BG_OutlayCKService.ModifyBG_OutlayCK(bG_OutlayCK); }
public static bool DeleteBG_OutlayCK(BG_OutlayCK bG_OutlayCK) { return BG_OutlayCKService.DeleteBG_OutlayCK(bG_OutlayCK); }
public static BG_OutlayCK AddBG_OutlayCK(BG_OutlayCK bG_OutlayCK) { return BG_OutlayCKService.AddBG_OutlayCK(bG_OutlayCK); }
public static BG_OutlayCK GetBG_OutlayCKByOAID(int oAID) { string sql = "SELECT * FROM BG_OutlayCK WHERE OAID = @OAID"; try { SqlParameter para = new SqlParameter("@OAID", oAID); DataTable dt = DBUnity.AdapterToTab(sql, para); if(dt.Rows.Count > 0) { BG_OutlayCK bG_OutlayCK = new BG_OutlayCK(); bG_OutlayCK.OAID = dt.Rows[0]["OAID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["OAID"]; bG_OutlayCK.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"]; bG_OutlayCK.PPID = dt.Rows[0]["PPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PPID"]; bG_OutlayCK.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"]; bG_OutlayCK.OACkMon = dt.Rows[0]["OACkMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["OACkMon"]; bG_OutlayCK.OATime = dt.Rows[0]["OATime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["OATime"]; bG_OutlayCK.OACkType = dt.Rows[0]["OACkType"] == DBNull.Value ? "" : (string)dt.Rows[0]["OACkType"]; return bG_OutlayCK; } else { return null; } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static bool DeleteBG_OutlayCK(BG_OutlayCK bG_OutlayCK) { return DeleteBG_OutlayCKByOAID( bG_OutlayCK.OAID ); }
public static bool ModifyBG_OutlayCK(BG_OutlayCK bG_OutlayCK) { string sql = "UPDATE BG_OutlayCK " + "SET " + "PIID = @PIID, " + "PPID = @PPID, " + "DepID = @DepID, " + "OACkMon = @OACkMon, " + "OATime = @OATime, " + "OACkType = @OACkType " + "WHERE OAID = @OAID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@OAID", bG_OutlayCK.OAID), new SqlParameter("@PIID", bG_OutlayCK.PIID), new SqlParameter("@PPID", bG_OutlayCK.PPID), new SqlParameter("@DepID", bG_OutlayCK.DepID), new SqlParameter("@OACkMon", bG_OutlayCK.OACkMon), new SqlParameter("@OATime", bG_OutlayCK.OATime), new SqlParameter("@OACkType", bG_OutlayCK.OACkType) }; 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; } }