public static bool InserttoTemp(INVOICEDETAIL ivd)
{
object i = SqlHelper.ExecuteScalar("spInserttoTempIVD"
, ivd.PIT_AUTOID
, ivd.PIT_ITEMNAME
, ivd.PIT_ITEMNO
, ivd.IV_DOCUMENTID
, ivd.COT_DOCUMENTID
, ivd.TUR_AUTOID
, ivd.WH_AUTOID
, ivd.ITT_AUTOID
, ivd.IVD_REQQUANTITY
, ivd.IVD_QUANTITYREAL
, ivd.IVD_TOTALAMOUNT
, ivd.IVD_VATTAXPER
, ivd.IVD_IMEXPORTTAXPER
, ivd.IVD_REDUCEPER
//, ivd.IVD_REDUCEMONEY
//, ivd.IVD_UOM
, ivd.IVD_UNITPRICE
, ivd.IVD_DESCRIPTION
// , ivd.IVD_AFAMOUNT
, ivd.CP_AUTOID
, ivd.PK_AUTOID);
if (Convert.ToInt16(i) < 1)
{
return(false);
}
return(true);
}
/// <summary>
///Select data full for table INVOICEDETAIL
/// return oneINVOICEDETAIL
/// you must set attribute at application tier
/// </summary>
/// <param name="IVD_AUTOID"> type of IVD_AUTOID</param>
public static INVOICEDETAIL SelectByID(Int64 IVD_AUTOID, bool isTmp)
{
string _strProc = "";
if (isTmp)
{
_strProc = "spINVOICEDETAILtmpGetByID";
}
else
{
_strProc = "spINVOICEDETAILGetByID";
}
DataSet ds = new DataSet();
INVOICEDETAIL result = new INVOICEDETAIL();
SqlHelper.ExecuteDataset(ds, _strProc, IVD_AUTOID);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
result = new INVOICEDETAIL(ds.Tables[0].Rows[0]);
}
}
ds.Dispose();
return(result);
}
/// <summary>
/// Thêm mới cập nhật tự động vào bảng chính
/// </summary>
/// <param name="obj">Chi tiết hóa đơn</param>
/// <returns>Trả về id sinh ra</returns>
public static Int64 InsertUpdate(INVOICEDETAIL obj)
{
string StoreName = "sp_InsertUpdate_InvoiceDetail";
SqlParameter[] Parramter = vnyi.DLL.DataObject.MapParramter(obj, StoreName);
object resul = SqlHelper.ExecuteScalar("", Parramter);
return(vnyi.DLL.DataObject.ConvertInt64(resul));
}
/// <summary>
/// Update data full for table INVOICEDETAIL
/// you must set attribute at application tier
/// </summary>
/// <param name="obj"> type of INVOICEDETAIL</param>
public static bool Update(INVOICEDETAIL Obj, bool isTmp)
{
string _strProc = "";
if (isTmp)
{
_strProc = "spINVOICEDETAILtmpUpdate";
}
else
{
_strProc = "spINVOICEDETAILUpdate";
}
int i = SqlHelper.ExecuteNonQuery(_strProc,
Obj.IVD_AUTOID,
Obj.PIT_AUTOID,
Obj.IV_DOCUMENTID,
Obj.COT_DOCUMENTID,
Obj.TUR_AUTOID,
Obj.WH_AUTOID,
Obj.PIT_ITEMNAME,
Obj.PIT_ITEMNO,
Obj.ITT_AUTOID,
Obj.IVD_REQQUANTITY,
Obj.IVD_QUANTITYREAL,
Obj.IVD_TOTALAMOUNT,
Obj.IVD_VATTAXPER,
Obj.IVD_IMEXPORTTAXPER,
Obj.IVD_REDUCEPER,
//Obj.IVD_REDUCEMONEY,
//Obj.IVD_UOM,
Obj.IVD_UNITPRICE,
Obj.IVD_DESCRIPTION,
// Obj.IVD_AFAMOUNT,
Obj.CP_AUTOID,
Obj.PK_AUTOID);
if (i > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// Insert data full for table INVOICEDETAIL
/// you must set attribute at application tier
/// </summary>
/// <param name="obj"> type of INVOICEDETAIL</param>
public static Int64 Insert(INVOICEDETAIL obj, bool isTmp)
{
string _strProc = "";
if (isTmp)
{
_strProc = "spINVOICEDETAILtmpInsert";
}
else
{
_strProc = "spINVOICEDETAILInsert";
}
object i = SqlHelper.ExecuteScalar(_strProc,
obj.PIT_AUTOID,
obj.IV_DOCUMENTID,
obj.COT_DOCUMENTID,
obj.TUR_AUTOID,
obj.WH_AUTOID,
obj.PIT_ITEMNAME,
obj.PIT_ITEMNO,
obj.ITT_AUTOID,
obj.IVD_REQQUANTITY,
obj.IVD_QUANTITYREAL,
obj.IVD_TOTALAMOUNT,
obj.IVD_VATTAXPER,
obj.IVD_IMEXPORTTAXPER,
obj.IVD_REDUCEPER,
//obj.IVD_UOM,
obj.IVD_UNITPRICE,
//obj.IVD_ISACTIVE,
obj.IVD_DESCRIPTION,
//obj.IVD_AFAMOUNT,
obj.CP_AUTOID,
//obj.IVD_SOPO,
obj.PK_AUTOID);
return(Convert.ToInt64(i));
}
/// <summary>
/// cap nhat vao invoicedetailtmp khi user tu nhap cac invoicedetail (bao gom tu nhap va finder item)
/// </summary>
/// <param name="ivd"></param>
/// <returns></returns>
public static DataSet insertupdateToTemp(INVOICEDETAIL ivd)
{
//insertIVDTmp
DataSet ds = new DataSet();
SqlHelper.ExecuteDataset(ds, "spInsertandUpdateIVDTmp"
, ivd.IVD_AUTOID
, ivd.IV_DOCUMENTID
, ivd.ITG_AUTOID
, ivd.PIT_AUTOID
, ivd.PIT_ITEMNAME
, ivd.PIT_ITEMNO
, ivd.UOM_AUTOID
, ivd.IVD_QUANTITYREAL
, ivd.IVD_UNITPRICE
, ivd.IVD_UNITBASEPRICE
, ivd.IVD_ITEMAMOUNT
, ivd.IVD_ITEMBASEAMOUNT
, ivd.IVD_REDUCEPER
, ivd.IVD_REDUCEAMOUNT
, ivd.IVD_REDUCEBASEAMOUNT
, ivd.IVD_VATTAXPER
, ivd.IVD_VATTAXAMOUNT
, ivd.IVD_VATTAXBASEAMOUNT
, ivd.IVD_EXCISETAXPER
, ivd.IVD_EXCISETAXAMOUNT
, ivd.IVD_EXCISETAXBASEAMOUNT
, ivd.IVD_IMEXPORTTAXPER
, ivd.IVD_IMEXPORTTAXAMOUNT
, ivd.IVD_IMEXPORTTAXBASEAMOUNT
, ivd.IVD_TOTALAMOUNT
, ivd.IVD_TOTALBASEAMOUNT
, ivd.IVD_DESCRIPTION
);
return(ds);
}
public static SqlMessage INSERTUPDATETmp(INVOICEDETAIL IVD, Int64?DOCUMENTID_TMP, SqlTransaction tran, string TYPE, string SESSION_ID)
{
SqlMessage sqlMessa = new SqlMessage();
DataSet ds = (DataSet)SqlHelper.ExecuteDataset(null, tran, "SP_META_INSERTUPDATE_INVOICEDEATAILTmp",
IVD.IVD_AUTOID,
IVD.IV_DOCUMENTID,
IVD.ITG_AUTOID,
IVD.CP_AUTOID,
IVD.PK_AUTOID,
IVD.PIT_AUTOID,
IVD.PIT_ITEMNAME,
IVD.PIT_ITEMNO,
IVD.COT_DOCUMENTID,
IVD.TUR_AUTOID,
IVD.WH_AUTOID,
IVD.ITT_AUTOID,
IVD.UOM_AUTOID,
IVD.IVD_REQQUANTITY,
IVD.IVD_QUANTITYREAL,
IVD.IVD_UNITPRICE,
IVD.IVD_UNITBASEPRICE,
IVD.IVD_ITEMAMOUNT,
IVD.IVD_ITEMBASEAMOUNT,
IVD.IVD_REDUCEPER,
IVD.IVD_REDUCEAMOUNT,
IVD.IVD_REDUCEBASEAMOUNT,
IVD.IVD_VATTAXPER,
IVD.IVD_VATTAXAMOUNT,
IVD.IVD_VATTAXBASEAMOUNT,
IVD.IVD_EXCISETAXPER,
IVD.IVD_EXCISETAXAMOUNT,
IVD.IVD_EXCISETAXBASEAMOUNT,
IVD.IVD_IMEXPORTTAXPER,
IVD.IVD_IMEXPORTTAXAMOUNT,
IVD.IVD_IMEXPORTTAXBASEAMOUNT,
IVD.IVD_TOTALAMOUNT,
IVD.IVD_TOTALBASEAMOUNT,
IVD.IVD_DESCRIPTION,
DOCUMENTID_TMP,
TYPE,
SESSION_ID
);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
string error = ds.Tables[0].Rows[0]["ERROR"].ToString();
switch (error)
{
case "1": // insert thành công
{
sqlMessa.Message = "1";
sqlMessa.Status = sqlMessagerType.Success;
sqlMessa.ResulObj = ds.Tables[1];
}
break;
case "2": // update thanh công
{
sqlMessa.Message = "2";
sqlMessa.Status = sqlMessagerType.Success;
sqlMessa.ResulObj = ds.Tables[1];
}
break;
case "-2": // dữ liệu đã bị xóa
{
sqlMessa.Message = "-2";
sqlMessa.Status = sqlMessagerType.Success;
}
break;
case "0": // lưu bị lỗi
{
sqlMessa.Status = sqlMessagerType.Error;
sqlMessa.Message = "0";
}
break;
}
}
}
return(sqlMessa);
}
