public static bool Update(PUBENTRY entry) { string procedure = "SP_Update_PUBENTRY"; int i = SqlHelper.ExecuteNonQuery(procedure, entry.ET_AUTOID, entry.ET_BUSSINESSID, entry.DOC_PARRENTID, entry.DOC_DETAILID, entry.PRJ_AUTOID, entry.CP_AUTOID, entry.OBJ_AUTOID, entry.BAK_AUTOID, entry.COT_DOCUMENTID, entry.COST_AUTOID, entry.CUR_AUTOID, entry.ET_DEBTORACCOUNT, entry.ET_DEBTOREXPLAIN, entry.ET_CREDITACCOUNT, entry.ET_CREDITEXPLAIN, entry.ET_EXCHANGERATE, entry.ET_TOTALAMOUNT, entry.ET_BASEAMOUNT, entry.ET_NOTE, entry.ET_OFSYSTEM, entry.ET_OFSUBSYSTEM, entry.ET_ISACTIVE, entry.PETT_AUTOID); return(i > 0); }
public static Int64 Insert(PUBENTRY entry) { string procedure = "SP_Insert_PUBENTRY"; object i = SqlHelper.ExecuteScalar(procedure, entry.ET_BUSSINESSID, entry.DOC_PARRENTID, entry.DOC_DETAILID, entry.PRJ_AUTOID, entry.CP_AUTOID, entry.OBJ_AUTOID, entry.BAK_AUTOID, entry.COT_DOCUMENTID, entry.COST_AUTOID, entry.CUR_AUTOID, entry.ET_DEBTORACCOUNT, entry.ET_DEBTOREXPLAIN, entry.ET_CREDITACCOUNT, entry.ET_CREDITEXPLAIN, entry.ET_EXCHANGERATE, entry.ET_TOTALAMOUNT, entry.ET_BASEAMOUNT, entry.ET_NOTE, entry.ET_OFSYSTEM, entry.ET_OFSUBSYSTEM, entry.ET_ISACTIVE, entry.PETT_AUTOID); return(Convert.ToInt64(i)); }
public static Int64 tmpDataProcessValidate(PUBENTRY et, Int64?MASTERID, string TYPE) { //SP_COMMON_TMPDATAPROCESS_PUBENTRY object i; i = SqlHelper.ExecuteScalar("SP_COMMON_VALIDATEInsertandUpdate_PUBENTRY", et.ET_AUTOID , et.ET_BUSSINESSID , et.DOC_PARRENTID , et.DOC_DETAILID , et.PRJ_AUTOID , et.CP_AUTOID , et.OBJ_AUTOID , et.BAK_AUTOID , et.COT_DOCUMENTID , et.COST_AUTOID , et.CUR_AUTOID , et.ET_DEBTORACCOUNT , et.ET_DEBTOREXPLAIN , et.ET_CREDITACCOUNT , et.ET_CREDITEXPLAIN , et.ET_EXCHANGERATE , et.ET_TOTALAMOUNT , et.ET_BASEAMOUNT , et.ET_NOTE , et.ET_OFSYSTEM , et.ET_OFSUBSYSTEM , et.ET_ISACTIVE , et.PETT_AUTOID , et.CI_AUTOID , MASTERID , TYPE); return(Convert.ToInt64(i)); }
/// <summary> ///Select data full for table PUBENTRY /// return onePUBENTRY /// you must set attribute at application tier /// </summary> /// <param name="ET_AUTOID"> type of ET_AUTOID</param> public static PUBENTRY SelectByID(Int64 ET_AUTOID) { DataSet ds = new DataSet(); PUBENTRY result = new PUBENTRY(); SqlHelper.ExecuteDataset(ds, "spPUBENTRYGetByID", ET_AUTOID); if (ds != null) { if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { result = new PUBENTRY(ds.Tables[0].Rows[0]); } } } return(result); }