C# (CSharp) LP_Purchase_Invoice_DAL示例

示例#1

        public string GeneratePINo(LP_GenerateTransNumber_Property objtransno)
        {
            string TransactionNumber = "";

            objDAL = new LP_Purchase_Invoice_DAL();
            DataTable dt = objDAL.GeneratePINo(objtransno);

            if (dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    TransactionNumber = dr["TransNumber"].ToString();
                    TransactionNumber = "PI-00" + TransactionNumber + "-" + objtransno.userid;
                }
                return(TransactionNumber);
            }
            else
            {
                TransactionNumber = "PI-001-" + objtransno.userid;

                return(TransactionNumber);
            }
            //return _objMRNDAL.GenerateMRNNo(objtransno);
        }

示例#2

 public DataSet SelectByID()
 {
     objDAL = new LP_Purchase_Invoice_DAL(_objpinvoice);
     return(objDAL.SelectByID());
 }

示例#3

 public DataTable SelectPIByDate(LP_Voucher_ViewModel objvoucherinvoice)
 {
     objDAL = new LP_Purchase_Invoice_DAL();
     return(objDAL.SelectPIBYDate(objvoucherinvoice));
 }

示例#4

 public DataTable SelectOne()
 {
     objDAL = new LP_Purchase_Invoice_DAL(_objpinvoice);
     return(objDAL.SelectOne());
 }

示例#5

 public DataTable SelectAll()
 {
     objDAL = new LP_Purchase_Invoice_DAL();
     return(objDAL.SelectAll());
 }

示例#6

 public bool Insert()
 {
     objDAL = new LP_Purchase_Invoice_DAL(_objpinvoice);
     return(objDAL.Insert());
 }

示例#7

 public DataSet SelectPIWithDetailData(int id)
 {
     objDAL = new LP_Purchase_Invoice_DAL();
     return(objDAL.SelectAllPIDetailsDataById(id));
 }

示例#8

 public DataTable SelectPIByVendorId(int id)
 {
     objDAL = new LP_Purchase_Invoice_DAL();
     return(objDAL.SelectAllByVendorID(id));
 }