public CStock get_Stock(string cmd_str) { CStock stock = null; SqlConnection sqlCn = null; try { sqlCn = new SqlConnection(_con_str); sqlCn.Open(); //cmd_str = "Select * from [Stock] where (" + cmd_str + ")"; SqlCommand cmdSelect = new SqlCommand(cmd_str, sqlCn); using (SqlDataReader dr = cmdSelect.ExecuteReader()) { while (dr.Read()) { stock = new CStock(); stock.id = (int)dr["id"]; break; } } } catch (System.Exception e) { IOUtil.insert_file("time=" + DateTime.Now.ToString() + ",cmd_str=" + cmd_str); IOUtil.insert_file("\n"); BathClass.printErrorMsg(e.Message); } finally { close_connection(sqlCn); } return stock; }
//对话框载入 private void OrderForm_Load(object sender, EventArgs e) { dao = new DAO(m_con_str); if (!dao.execute_command("update [Seat] set ordering='True' where text='" + m_Seat.text + "'")) { BathClass.printErrorMsg("手牌状态更新失败!"); return; } m_options = dao.get_options(); if (typeList.Count == 0) typeList = dao.get_catgories(null); //typeList = db.Catgory.Select(x => x.name).ToList(); dgvExpense.Columns[11].Visible = MConvert<bool>.ToTypeOrDefault(m_options.启用客房面板, false); inputBillId = MConvert<bool>.ToTypeOrDefault(m_options.录单输入单据编号, false); inputTechType = MConvert<bool>.ToTypeOrDefault(m_options.录单区分点钟轮钟, false); string local_ip = BathClass.get_local_ip(); stock = dao.get_Stock("select * from [Stock] where ips='"+local_ip+"'"); this.Invoke(new no_par_delegate(initial_ui), null); //MessageBox.Show((DateTime.Now - st).TotalMilliseconds.ToString()); }