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);
}
