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