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