Esempio n. 1
0
        private List <QReceiptitems> Collectitems(string vId)
        {
            List <QReceiptitems> list = new List <QReceiptitems>();

            for (int r = 0; r < editgrid.RowCount; r++)
            {
                QReceiptitems obj = new QReceiptitems();

                if (
                    (editgrid[QRECEIPTITEMS.QRECEIPT_AMOUNT, r].Value + "") == ""
                    )
                {
                    //==LEAVE IT(the empty row).
                }
                else
                {
                    obj.Qreceiptitems_id = "";
                    obj.Qreceipt_id      = vId;
                    obj.Qreceipt_by      = (editgrid[QRECEIPTITEMS.QRECEIPT_BY, r].Value + "");
                    obj.Quotation_no     = (editgrid[QRECEIPTITEMS.QUOTATION_NO, r].Value + "");
                    obj.Quotation_amount = ConvertTO.Decimal(editgrid[QRECEIPTITEMS.QUOTATION_AMOUNT, r].Value + "");
                    obj.Qreceipt_amount  = ConvertTO.Decimal(editgrid[QRECEIPTITEMS.QRECEIPT_AMOUNT, r].Value + "");

                    list.Add(obj);
                }
            }

            if (list.Count != 0)
            {
                return(list);
            }

            return(null);
        }
Esempio n. 2
0
 private static string AttachParams(string q, QReceiptitems v)
 {
     q = q.Replace("@" + QRECEIPTITEMS.QRECEIPT_ID + "@", "" + ConvertTO.SqlString(v.Qreceipt_id) + "");
     q = q.Replace("@" + QRECEIPTITEMS.QRECEIPT_BY + "@", "" + ConvertTO.SqlString(v.Qreceipt_by) + "");
     q = q.Replace("@" + QRECEIPTITEMS.QUOTATION_NO + "@", "" + ConvertTO.SqlString(v.Quotation_no) + "");
     q = q.Replace("@" + QRECEIPTITEMS.QUOTATION_AMOUNT + "@", "" + ConvertTO.SqlString(v.Quotation_amount + ""));
     q = q.Replace("@" + QRECEIPTITEMS.QRECEIPT_AMOUNT + "@", "" + ConvertTO.SqlString(v.Qreceipt_amount + ""));
     return(q);
 }
Esempio n. 3
0
 public static void Insert(List <QReceiptitems> list, DAL dalsession)
 {
     for (int i = 0; i < list.Count; i++)
     {
         QReceiptitems obj = new QReceiptitems()
         {
             Qreceipt_id      = list[i].Qreceipt_id,
             Qreceipt_by      = list[i].Qreceipt_by,
             Quotation_no     = list[i].Quotation_no,
             Quotation_amount = list[i].Quotation_amount,
             Qreceipt_amount  = list[i].Qreceipt_amount
         };
         InsertSub(obj, dalsession);
     }
 }
Esempio n. 4
0
        public static void InsertSub(QReceiptitems v, DAL dalsession)
        {
            string q = " INSERT INTO " + QRECEIPTITEMS.QRECEIPTITEMS_TBL + " ( ";

            q += " " + QRECEIPTITEMS.QRECEIPT_ID + " \r\n ";
            q += "," + QRECEIPTITEMS.QRECEIPT_BY + " \r\n ";
            q += "," + QRECEIPTITEMS.QUOTATION_NO + " \r\n ";
            q += "," + QRECEIPTITEMS.QUOTATION_AMOUNT + " \r\n ";
            q += "," + QRECEIPTITEMS.QRECEIPT_AMOUNT + " \r\n ";
            q += " ) VALUES ( ";
            q += "  @" + QRECEIPTITEMS.QRECEIPT_ID + "@ \r\n ";
            q += ", @" + QRECEIPTITEMS.QRECEIPT_BY + "@ \r\n ";
            q += ", @" + QRECEIPTITEMS.QUOTATION_NO + "@ \r\n ";
            q += ", @" + QRECEIPTITEMS.QUOTATION_AMOUNT + "@ \r\n ";
            q += ", @" + QRECEIPTITEMS.QRECEIPT_AMOUNT + "@ \r\n ";
            q += " ) \r\n ";
            q  = AttachParams(q, v);
            dalsession.Execute(q);
        }
Esempio n. 5
0
        private static List <QReceiptitems> EntityList(string q)
        {
            List <QReceiptitems> list = new List <QReceiptitems>();

            using (IDataReader redr = new DAL().Listreader(q))
            {
                while (redr.Read() == true)
                {
                    QReceiptitems obj = new  QReceiptitems()
                    {
                        Qreceiptitems_id = redr[QRECEIPTITEMS.QRECEIPTITEMS_ID].ToString(),
                        Qreceipt_id      = redr[QRECEIPTITEMS.QRECEIPT_ID].ToString(),
                        Qreceipt_by      = redr[QRECEIPTITEMS.QRECEIPT_BY].ToString(),
                        Quotation_no     = redr[QRECEIPTITEMS.QUOTATION_NO].ToString(),
                        Quotation_amount = ConvertTO.Decimal(redr[QRECEIPTITEMS.QUOTATION_AMOUNT].ToString()),
                        Qreceipt_amount  = ConvertTO.Decimal(redr[QRECEIPTITEMS.QRECEIPT_AMOUNT].ToString()),
                    };

                    list.Add(obj);
                }
            }
            return(list);
        }