Ejemplo n.º 1
0
 internal string SetCommon(Saving saving)
 {
     string sql = string.Format("update saving_account set common_use=1 where id ='{0}'",saving.Account_Id);
     string error = null;
     MySqlConnection conn = null;
     try
     {
         conn = new MySqlConnection(connStr_local);
         conn.Open();
         MySqlDataAdapter adapter = new MySqlDataAdapter(sql, conn);
         // 创建DataSet,用于存储数据.
         DataSet testDataSet = new DataSet();
         // 执行查询,并将数据导入DataSet.
         adapter.Fill(testDataSet, "result_data");
         return "Success";
     }
     catch (Exception t)
     {
         return "error";
     }
     finally
     {
         conn.Close();
     }
 }
Ejemplo n.º 2
0
        internal List<Saving> GetAllSavingAccount(string user_id)
        {
            List<Saving> saving_list = new List<Saving>();
            string sql = string.Format("select * from saving_account as s,currency as c,account_status as ast,branch as b where  s.user_id ='{0}' and s.currency_id = c.id  and s.branch_id=b.id and s.status= ast.id", user_id);
            DataSet testDataSet = null;
            MySqlConnection conn = new MySqlConnection(connStr_local);
            try
            {
                conn.Open();
                // 创建一个适配器
                MySqlDataAdapter adapter = new MySqlDataAdapter(sql, conn);
                // 创建DataSet,用于存储数据.
                testDataSet = new DataSet();
                // 执行查询,并将数据导入DataSet.
                adapter.Fill(testDataSet, "result_data");
            }
            // 关闭数据库连接.
            catch (Exception e)
            {
                //log4net.ILog log = log4net.LogManager.GetLogger("MyLogger");
                //log.Debug(e.Message);
                Console.WriteLine(e.Message);
                //Console.ReadLine();

            }
            finally
            {
                conn.Close();
            }
            if (testDataSet != null && testDataSet.Tables["result_data"] != null && testDataSet.Tables["result_data"].Rows != null && testDataSet.Tables["result_data"].Rows.Count > 0)
            {
                foreach (DataRow testRow in testDataSet.Tables["result_data"].Rows)
                {
                    Saving saving = new Saving();
                    string Account_Id = testRow["id"].ToString();
                    string card_num = testRow["card_num"].ToString();
                    string balance = testRow["balance"].ToString();
                    string branch_id = testRow["branch_name"].ToString();
                    string expired_date = testRow["expired_date"].ToString();
                    string open_date = testRow["open_date"].ToString();
                    string currency_id = testRow["currency_name"].ToString();
                    string status = testRow["status_name"].ToString();
                    string common_use = testRow["common_use"].ToString();
                    saving.Account_Id = Account_Id;
                    saving.No = card_num;
                    saving.Balance = balance;
                    saving.Branch = branch_id;
                    saving.Open_Date = open_date;
                    saving.Exp_Date = expired_date;
                    saving.Currency_Id = currency_id;
                    saving.Status = status;
                    saving.Common_use = common_use;
                   saving_list.Add(saving);
                }
            }
            else
            {
                return null;
            }
            return saving_list;
        }
Ejemplo n.º 3
0
 public string SetCommon(Saving saving)
 {
     MysqlHelper mysqlhelper = new MysqlHelper();
     var status = mysqlhelper.SetCommon(saving);
     return status;
 }