Пример #1
0
 public XObjs.Fee_details getFee_detailsByID(string xid, string cat, string xmemberID)
 {
     XObjs.Fee_details x = new XObjs.Fee_details();
     SqlConnection connection = new SqlConnection(this.ConnectXpay());
     SqlCommand command = new SqlCommand("select fee_details.*,fee_list.* from fee_list  INNER JOIN fee_details ON fee_details.fee_listID=fee_list.xid  INNER JOIN twallet ON  twallet.xid=fee_details.twalletID where fee_list.xcategory='" + cat + "' AND twallet.xmemberID='" + xmemberID + "' AND twallet.xpay_status='1' AND xid='" + xid + "' ", connection);
     connection.Open();
     SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
     while (reader.Read())
     {
         x.xid = reader["xid"].ToString();
         x.fee_listID = reader["fee_listID"].ToString();
         x.twalletID = reader["twalletID"].ToString();
         x.xqty = reader["xqty"].ToString();
         x.xused = reader["xused"].ToString();
         x.tot_amt = reader["tot_amt"].ToString();
         x.init_amt = reader["init_amt"].ToString();
         x.tech_amt = reader["tech_amt"].ToString();
         x.xreg_date = reader["xlogstaff"].ToString();
         x.xreg_date = reader["xreg_date"].ToString();
         x.xsync = reader["xsync"].ToString();
         x.xvisible = reader["xvisible"].ToString();
     }
     reader.Close();
     return x;
 }
Пример #2
0
 public List<XObjs.Fee_details> getFee_detailsByTwalletID(string twalletID)
 {
     List<XObjs.Fee_details> xlist = new List<XObjs.Fee_details>();
     SqlConnection connection = new SqlConnection(this.ConnectXpay());
     SqlCommand command = new SqlCommand("SELECT * from fee_details where twalletID='" + twalletID + "' ", connection);
     connection.Open();
     SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
     while (reader.Read())
     {
         XObjs.Fee_details x = new XObjs.Fee_details();
         x.xid = reader["xid"].ToString();
         x.fee_listID = reader["fee_listID"].ToString();
         x.twalletID = reader["twalletID"].ToString();
         x.xqty = reader["xqty"].ToString();
         x.xused = reader["xused"].ToString();
         x.tot_amt = reader["tot_amt"].ToString();
         x.init_amt = reader["init_amt"].ToString();
         x.tech_amt = reader["tech_amt"].ToString();
         x.xreg_date = reader["xlogstaff"].ToString();
         x.xreg_date = reader["xreg_date"].ToString();
         x.xsync = reader["xsync"].ToString();
         x.xvisible = reader["xvisible"].ToString();
         xlist.Add(x);
     }
     reader.Close();
     return xlist;
 }
Пример #3
0
 public XObjs.Fee_details getFee_detailsByID(string xid)
 {
     XObjs.Fee_details x = new XObjs.Fee_details();
     SqlConnection connection = new SqlConnection(this.ConnectXpay());
     SqlCommand command = new SqlCommand("select * from  fee_details where xid='" + xid + "' ", connection);
     connection.Open();
     SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
     while (reader.Read())
     {
         x.xid = reader["xid"].ToString();
         x.fee_listID = reader["fee_listID"].ToString();
         x.twalletID = reader["twalletID"].ToString();
         x.xqty = reader["xqty"].ToString();
         x.xused = reader["xused"].ToString();
         x.tot_amt = reader["tot_amt"].ToString();
         x.init_amt = reader["init_amt"].ToString();
         x.tech_amt = reader["tech_amt"].ToString();
         x.xreg_date = reader["xlogstaff"].ToString();
         x.xreg_date = reader["xreg_date"].ToString();
         x.xsync = reader["xsync"].ToString();
         x.xvisible = reader["xvisible"].ToString();
     }
     reader.Close();
     return x;
 }