public static SqlMessage INSERTUPDATE(INVOICEDETAIL IVD, Int64?DOCUMENTID_TMP, SqlTransaction tran, string TYPE)
{
SqlMessage sqlMessa = new SqlMessage();
DataSet ds = (DataSet)SqlHelper.ExecuteDataset(null, tran, "SP_META_INSERTUPDATE_INVOICEDEATAIL",
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
);
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);
}
