Beispiel #1
0
        public void getlBsp()
        {
            //lDept = new List<Position>();

            lDgs.Clear();
            DataTable dt = new DataTable();

            dt = selectAll();
            foreach (DataRow row in dt.Rows)
            {
                StockReturnDetail itm1 = new StockReturnDetail();
                itm1.return_detail_id = row[dsc.return_detail_id].ToString();
                itm1.return_id        = row[dsc.return_id].ToString();
                itm1.goods_id         = row[dsc.goods_id].ToString();
                itm1.qty          = row[dsc.qty].ToString();
                itm1.status_stock = row[dsc.status_stock].ToString();

                itm1.active      = row[dsc.active].ToString();
                itm1.remark      = row[dsc.remark].ToString();
                itm1.date_create = row[dsc.date_create].ToString();
                itm1.date_modi   = row[dsc.date_modi].ToString();
                itm1.date_cancel = row[dsc.date_cancel].ToString();
                itm1.user_create = row[dsc.user_create].ToString();
                itm1.user_modi   = row[dsc.user_modi].ToString();
                itm1.user_cancel = row[dsc.user_cancel].ToString();

                lDgs.Add(itm1);
            }
        }
Beispiel #2
0
        public StockReturnDetail setDocScan(DataTable dt)
        {
            StockReturnDetail dgs1 = new StockReturnDetail();

            if (dt.Rows.Count > 0)
            {
                dgs1.return_detail_id = dt.Rows[0][dsc.return_detail_id].ToString();
                dgs1.return_id        = dt.Rows[0][dsc.return_id].ToString();
                dgs1.goods_id         = dt.Rows[0][dsc.goods_id].ToString();
                dgs1.qty          = dt.Rows[0][dsc.qty].ToString();
                dgs1.status_stock = dt.Rows[0][dsc.status_stock].ToString();

                dgs1.active      = dt.Rows[0][dsc.active].ToString();
                dgs1.remark      = dt.Rows[0][dsc.remark].ToString();
                dgs1.date_create = dt.Rows[0][dsc.date_create].ToString();
                dgs1.date_modi   = dt.Rows[0][dsc.date_modi].ToString();
                dgs1.date_cancel = dt.Rows[0][dsc.date_cancel].ToString();
                dgs1.user_create = dt.Rows[0][dsc.user_create].ToString();
                dgs1.user_modi   = dt.Rows[0][dsc.user_modi].ToString();
                dgs1.user_cancel = dt.Rows[0][dsc.user_cancel].ToString();
            }
            else
            {
                setDocGroupScan(dgs1);
            }
            return(dgs1);
        }
Beispiel #3
0
        public String update(StockReturnDetail p, String userId)
        {
            String re  = "";
            String sql = "";
            int    chk = 0;

            chkNull(p);
            sql = "Update " + dsc.table + " Set " +
                  " " + dsc.return_id + " = '" + p.return_id + "'" +
                  "," + dsc.goods_id + " = '" + p.goods_id + "'" +
                  "," + dsc.qty + " = '" + p.qty + "'" +
                  "," + dsc.status_stock + " = '" + p.status_stock + "'" +

                  "," + dsc.remark + " = '" + p.remark + "'" +
                  "," + dsc.date_modi + " = now()" +
                  "," + dsc.user_modi + " = '" + userId + "'" +

                  "Where " + dsc.pkField + "='" + p.return_detail_id + "'"
            ;

            try
            {
                re = conn.ExecuteNonQuery(conn.conn, sql);
            }
            catch (Exception ex)
            {
                sql = ex.Message + " " + ex.InnerException;
            }

            return(re);
        }
Beispiel #4
0
        public StockReturnDetail selectByPk(String id)
        {
            StockReturnDetail cop1 = new StockReturnDetail();
            DataTable         dt   = new DataTable();
            String            sql  = "select * " +
                                     "From " + dsc.table + " dsc " +
                                     //"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " +
                                     "Where dsc." + dsc.pkField + " ='" + id + "' " +
                                     "Order By return_id ";

            dt   = conn.selectData(conn.conn, sql);
            cop1 = setDocScan(dt);
            return(cop1);
        }
Beispiel #5
0
        public String insertDocScan(StockReturnDetail p, String userId)
        {
            String re = "";

            if (p.return_detail_id.Equals(""))
            {
                re = insert(p, "");
            }
            else
            {
                re = update(p, "");
            }

            return(re);
        }
Beispiel #6
0
        private void chkNull(StockReturnDetail p)
        {
            long chk = 0;

            p.date_modi   = p.date_modi == null ? "" : p.date_modi;
            p.date_cancel = p.date_cancel == null ? "" : p.date_cancel;
            p.user_create = p.user_create == null ? "" : p.user_create;
            p.user_modi   = p.user_modi == null ? "" : p.user_modi;
            p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;

            p.qty          = p.qty == null ? "" : p.qty;
            p.status_stock = p.status_stock == null ? "" : p.status_stock;

            p.remark = p.remark == null ? "" : p.remark;

            p.return_id = long.TryParse(p.return_id, out chk) ? chk.ToString() : "0";
            p.goods_id  = long.TryParse(p.goods_id, out chk) ? chk.ToString() : "0";
        }
Beispiel #7
0
        public StockReturnDetail setDocGroupScan(StockReturnDetail dgs1)
        {
            dgs1.return_detail_id = "";
            dgs1.return_id        = "";
            dgs1.goods_id         = "";
            dgs1.qty          = "";
            dgs1.status_stock = "";

            dgs1.active      = "";
            dgs1.remark      = "";
            dgs1.date_create = "";
            dgs1.date_modi   = "";
            dgs1.date_cancel = "";
            dgs1.user_create = "";
            dgs1.user_modi   = "";
            dgs1.user_cancel = "";

            return(dgs1);
        }
Beispiel #8
0
        public String insert(StockReturnDetail p, String userId)
        {
            String re  = "";
            String sql = "";

            //DataTable dt = new DataTable();
            p.active = "1";
            //p.ssdata_id = "";
            int chk = 0;

            chkNull(p);
            sql = "Insert Into " + dsc.table + " set " +
                  "" + dsc.return_id + "= '" + p.return_id + "'" +
                  "," + dsc.active + "= '" + p.active + "'" +
                  "," + dsc.goods_id + "= '" + p.goods_id + "'" +
                  "," + dsc.qty + "= '" + p.qty + "'" +
                  "," + dsc.status_stock + "= '" + p.status_stock + "'" +

                  "," + dsc.remark + "= '" + p.remark + "'" +
                  "," + dsc.date_create + "= now()" +
                  "," + dsc.date_modi + "= ''" +
                  "," + dsc.date_cancel + "= ''" +
                  "," + dsc.user_create + "= '" + userId + "'" +
                  "," + dsc.user_modi + "= ''" +
                  "," + dsc.user_cancel + "= ''" +

                  "";
            try
            {
                re = conn.ExecuteNonQuery(conn.conn, sql);
            }
            catch (Exception ex)
            {
                sql = ex.Message + " " + ex.InnerException;
            }
            finally
            {
                conn.conn.Close();
                //conn.comStore.Dispose();
            }
            return(re);
        }
Beispiel #9
0
        private void initConfig()
        {
            dsc  = new StockReturnDetail();
            lDgs = new List <StockReturnDetail>();

            dsc.return_detail_id = "return_detail_id";
            dsc.return_id        = "return_id";
            dsc.goods_id         = "goods_id";
            dsc.qty          = "qty";
            dsc.status_stock = "status_stock";

            dsc.active      = "active";
            dsc.remark      = "remark";
            dsc.date_create = "date_create";
            dsc.date_modi   = "date_modi";
            dsc.date_cancel = "date_cancel";
            dsc.user_create = "user_create";
            dsc.user_modi   = "user_modi";
            dsc.user_cancel = "user_cancel";


            dsc.table   = "t_doc_scan";
            dsc.pkField = "return_detail_id";
        }