/// <summary> /// Insert data full for table PUBPLAN /// you must set attribute at application tier /// </summary> /// <param name="obj"> type of PUBPLAN</param> public static bool Insert(PUBPLAN obj) { int i = SqlHelper.ExecuteNonQuery("spPUBPLANInsert" , obj.PLA_DOCUMENTID , obj.DOTY_AUTOID , obj.ST_AUTOID , obj.PLA_AMOUNTREAL , obj.PLA_BEGINDATE , obj.PLA_ENDDATE , obj.PLA_AMOUNT , obj.OBJ_AUTOID , obj.PLA_RESION , obj.PLA_BASEAMOUNT , obj.CUR_AUTOID , obj.PLA_EXCHANGERATE ); if (i > 0) { return(true); } else { return(false); } }
/// <summary> ///Select data full for table PUBPLAN /// return onePUBPLAN /// you must set attribute at application tier /// </summary> /// <param name="PLA_DOCUMENTID"> type of PLA_DOCUMENTID</param> public static PUBPLAN SelectByID(Int64 PLA_DOCUMENTID) { DataSet ds = new DataSet(); PUBPLAN result = new PUBPLAN(); SqlHelper.ExecuteDataset(ds, "spPUBPLANGetByID", PLA_DOCUMENTID); if (ds != null) { if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { result = new PUBPLAN(ds.Tables[0].Rows[0]); } } } return(result); }
/// <summary> /// Update data full for table PUBPLAN /// you must set attribute at application tier /// </summary> /// <param name="obj"> type of PUBPLAN</param> public static bool Update(PUBPLAN Obj) { int i = SqlHelper.ExecuteNonQuery("spPUBPLANUpdate" , Obj.PLA_DOCUMENTID , Obj.DOTY_AUTOID , Obj.ST_AUTOID , Obj.PLA_AMOUNTREAL , Obj.PLA_BEGINDATE , Obj.PLA_ENDDATE , Obj.PLA_AMOUNT , Obj.OBJ_AUTOID , Obj.PLA_RESION , Obj.PLA_BASEAMOUNT , Obj.CUR_AUTOID , Obj.PLA_EXCHANGERATE ); if (i > 0) { return(true); } return(false); }