private void readExcel(string fileSource) { try { string con = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileSource + ";Extended Properties='Excel 8.0;HDR=Yes;ImportMixedTypes=Text'"; int count = 0; int countProblem = 0; using (OleDbConnection connection = new OleDbConnection(con)) { connection.Open(); OleDbCommand command = new OleDbCommand("select * from [Sheet1$]", connection); using (OleDbDataReader dr = command.ExecuteReader()) { while (dr.Read()) { var qS = dr.IsDBNull(0) ? "Câu hỏi trống" : dr[0].ToString(); var q = new Question(null, this.CurrentExam.ID, qS); int trueA = dr.IsDBNull(6) ? 1 : Convert.ToInt32(dr[6]); int countA = 0; for (int j = 1; j < 6; j++) { if (dr.IsDBNull(j)) { continue; } countA++; var aS = dr[j].ToString(); var a = new Answer(null, null, aS, false); if (j == trueA) { a.IsTrue = true; } q.Answers.Add(a); } if (countA < 2) { countProblem++; continue; } this.CurrentExam.Questions.Add(q); count++; } } } if (countProblem > 0) { MessageBox.Show("Có " + countProblem + " câu hỏi có vấn đề, không thể thêm. Bạn nên kiểm tra lại!", "Báo cáo lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning); } MessageBox.Show("Thêm thành công " + count + " câu hỏi!", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information); GenerateExamValue(); } catch (Exception e) { Console.WriteLine(e.StackTrace); MessageBox.Show("Xảy ra lỗi trong quá trình thêm. Có vẻ như file excel của bạn không đúng. Hãy sửa lại file theo mẫu (Tải đề mẫu)", "Xảy ra lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public SinoSZToolFlowDesign.DOL.Flow_BaseDefine GetFlowPropertiesByName(string _flowName) { Flow_BaseDefine _ret = null; string _sql = "select [ID],[FLOWNAME],[DESCRIPTION],[ROOTDWID] FROM [FLOW_ENTITYTYPE] "; _sql += " where [FLOWNAME] = @FLOWNAME "; using (OleDbConnection cn = OpenConnection(connectString)) { try { OleDbCommand _cmd = new OleDbCommand(_sql, cn); _cmd.Parameters.Add(new OleDbParameter("@FLOWNAME", _flowName)); OleDbDataReader dr = _cmd.ExecuteReader(); while (dr.Read()) { _ret = new Flow_BaseDefine(dr.IsDBNull(0) ? "" : dr.GetString(0), dr.IsDBNull(1) ? "" : dr.GetString(1), dr.IsDBNull(2) ? "" : dr.GetString(2), dr.IsDBNull(3) ? "0" : dr.GetDecimal(3).ToString() ); } dr.Close(); cn.Close(); return(_ret); } catch (Exception e) { throw e; //写系统错误日志 return(null); } } }
public List <SinoSZToolFlowDesign.DOL.Flow_BaseDefine> GetFlows() { List <Flow_BaseDefine> _ret = new List <Flow_BaseDefine>(); string _sql = "select [ID],[FLOWNAME],[DESCRIPTION],[ROOTDWID] FROM [FLOW_ENTITYTYPE]"; using (OleDbConnection cn = OpenConnection(connectString)) { try { OleDbCommand _cmd = new OleDbCommand(_sql, cn); OleDbDataReader dr = _cmd.ExecuteReader(); while (dr.Read()) { Flow_BaseDefine _fd = new Flow_BaseDefine(dr.IsDBNull(0) ? "" : dr.GetString(0), dr.IsDBNull(1) ? "" : dr.GetString(1), dr.IsDBNull(2) ? "" : dr.GetString(2), dr.IsDBNull(3) ? "0" : dr.GetDecimal(3).ToString() ); _ret.Add(_fd); } dr.Close(); cn.Close(); return(_ret); } catch (Exception e) { //写系统错误日志 throw e; return(null); } } }
public static void FillListView(System.Windows.Forms.ListView lvList, OleDbDataReader myData) { System.Windows.Forms.ListViewItem itmListItem; String strValue; lvList.Items.Clear(); while (myData.Read()) { itmListItem = new System.Windows.Forms.ListViewItem(); if (myData.IsDBNull(0)) { strValue = myData.GetValue(0).ToString(); } else { strValue = ""; } itmListItem.Text = strValue; for (int shtCntr = 1; shtCntr <= myData.FieldCount - 1; shtCntr++) { if (myData.IsDBNull(shtCntr)) { itmListItem.SubItems.Add(""); } else { itmListItem.SubItems.Add(myData.GetValue(shtCntr).ToString()); } } lvList.Items.Add(itmListItem); } }
public static OrderData GetData(int orderId) { OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Northwind.mdb;"); OleDbCommand myComm = new OleDbCommand("SELECT ShipAddress, ShipRegion, ShipCountry, OrderDate, RequiredDate, ShippedDate, ShipVia, Sent FROM Orders WHERE OrderID = @OrderID", myConn); myComm.Parameters.Add("@OrderID", OleDbType.Integer).Value = orderId; myConn.Open(); OleDbDataReader myReader = myComm.ExecuteReader(); myReader.Read(); OrderData order = new OrderData(); order.OrderID = orderId; order.ShipAddress = myReader.GetString(0); order.ShipRegion = !myReader.IsDBNull(1) ? myReader.GetString(1) : ""; order.ShipCountry = !myReader.IsDBNull(2) ? myReader.GetString(2) : ""; order.OrderDate = myReader.GetDateTime(3).ToString("MM/dd/yyyy"); order.RequiredDate = myReader.GetDateTime(4).ToString("MM/dd/yyyy"); order.ShippedDate = myReader.GetDateTime(5).ToString("MM/dd/yyyy"); order.ShipVia = myReader.GetInt32(6); order.Sent = myReader.GetBoolean(7); myReader.Close(); myConn.Close(); return(order); }
public static List <ThermalPlant> GetObjects() { List <ThermalPlant> plants = new List <ThermalPlant>(); string vble = null; string vble1 = null; string query = string.Format("SELECT nombre, Combustible, FactorDisponibilidad, FactorConsumoPromedio, Minimo, Maximo, CostoVariable, FactorConsumoVariable, Obligatorio, empresa, EtapaEntrada, Escenario, Id, Subarea " + "FROM {0}", table); OleDbDataReader reader = DataBaseManager.ReadData(query); while (reader.Read()) { try { vble = null; vble1 = null; if (!reader.IsDBNull(13)) { vble = reader.GetString(13); } else { vble = string.Empty; } if (!reader.IsDBNull(1)) { vble1 = reader.GetString(1); } else { vble1 = string.Empty; } } catch (Exception ex) { MessageBox.Show(ex.Message, "ex."); throw; } plants.Add(new ThermalPlant() { Name = reader.GetString(0), Fuel = vble1, //reader.GetString(1), AvailabilityFactor = Convert.ToDouble(reader.GetValue(2)), ProductionFactor = Convert.ToDouble(reader.GetValue(3)), Min = Convert.ToDouble(reader.GetValue(4)), Max = Convert.ToDouble(reader.GetValue(5)), VariableCost = Convert.ToDouble(reader.GetValue(6)), HasVariableProductionFactor = Convert.ToDouble(reader.GetValue(7)), IsMandatory = Convert.ToInt32(reader.GetValue(8)), Company = reader.GetString(9), StartPeriod = Convert.ToInt32(reader.GetValue(10)), Case = Convert.ToInt32(reader.GetValue(11)), Id = Convert.ToInt32(reader.GetValue(12)), Subarea = vble }); } DataBaseManager.DbConnection.Close(); return(plants); }
private ArrayList GetElementList() { GeoHandlerClass cl = new GeoHandlerClass(); ArrayList l = new ArrayList(); OleDbConnection c = new OleDbConnection(cl.ConnectionString); c.Open(); OleDbCommand cmd = new OleDbCommand("select * from TB_PROVINCIE where ID_TB_REGIONI = " + _idRegione.ToString(), c); OleDbDataReader r = cmd.ExecuteReader(); while (r.Read()) { int id = r.IsDBNull(0) ? -1 : (int)r.GetValue(0); Key k = new Key(id); string descrizione = r.IsDBNull(1) ? null : (string)r.GetValue(1); string sigla = r.IsDBNull(2) ? null : (string)r.GetValue(2); int idRegione = r.IsDBNull(3) ? -1 : (int)r.GetValue(3); Provincia p = new Provincia(k, descrizione, idRegione, sigla); p.ListaComuni = new LazyComune(p.Id, SearchCityType.Province); l.Add(p); } r.Close(); c.Close(); return(l); }
public ActionResult List() { String sql = @"SELECT * FROM Article"; List <ArticleModel> list = new List <ArticleModel>(); AccessSqlHelper accHpler = new AccessSqlHelper(); OleDbDataReader reader = accHpler.ExecuteReader(sql, null); if (reader.HasRows) { while (reader.Read()) { ArticleModel artModel = new ArticleModel(); artModel.arID = reader.GetInt32(0); object titel = reader.IsDBNull(1) ? null: reader.GetString(1); artModel.title = titel == null ? string.Empty : Convert.ToString(titel); object content = reader.IsDBNull(2) ? null : reader.GetString(2); artModel.contnet = content == null ? string.Empty : Convert.ToString(content); list.Add(artModel); } } ViewBag.list = list; return(View()); }
private void GetSelectNodes(FlowChart obj) { string sCmd = "SELECT F_ACT_ID,F_SELECT_ID " + "FROM WF_SELECT_ROUNTING where F_PROCESS_ID=" + obj.ID; OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = sCmd; OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { string currID = dr.IsDBNull(0) ? "" : dr.GetValue(0).ToString(); //F_ACT_ID string sID = dr.IsDBNull(1) ? "" : dr.GetValue(1).ToString(); //F_SELECT_ID //检索列表 wfActivity currAct = obj.GetActivityByID(currID); wfActivity sAct = obj.GetActivityByID(sID); if ((currAct != null) && (sAct != null)) { currAct.SelectNodes.Add(sID); } } dr.Close(); dr.Dispose(); cmd.Dispose(); }
/// <summary> /// 从数据库读流程节点分派关系 /// </summary> /// <param name="obj"></param> private void GetActRoutingRule(FlowChart obj) { string sCmd = "SELECT F_PRE_ACT_ID,F_CURR_ACT_ID,F_COMPLETION_FLAG,F_NEXT_ACT_ID_LIST,F_PRE_DEPNT_SET,F_PROC_ID " + "FROM WF_ROUTING_RULE where F_PROC_ID=" + obj.ID; OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = sCmd; OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { string currID = dr.IsDBNull(0) ? "" : dr.GetValue(0).ToString(); //F_PRE_ACT_ID string pID = dr.IsDBNull(1) ? "" : dr.GetValue(1).ToString(); //F_CURR_ACT_ID string pStatus = dr.IsDBNull(2) ? "" : dr.GetString(2); //F_COMPLETION_FLAG //检索列表 wfActivity currAct = obj.GetActivityByID(currID); wfActivity pAct = obj.GetActivityByID(pID); if ((currAct != null) && (pAct != null)) { currAct.AddChild(pAct, pStatus); } } dr.Close(); dr.Dispose(); cmd.Dispose(); }
public ActionResult List() { String sql = @"SELECT * FROM Nav"; List <NavModel> list = new List <NavModel>(); AccessSqlHelper accHpler = new AccessSqlHelper(); OleDbDataReader reader = accHpler.ExecuteReader(sql, null); if (reader.HasRows) { while (reader.Read()) { NavModel navModel = new NavModel(); navModel.nID = reader.GetInt32(0); object titel = reader.IsDBNull(1) ? null : reader.GetString(1); navModel.title = titel == null ? string.Empty : Convert.ToString(titel); object url = reader.IsDBNull(2) ? null : reader.GetString(2); navModel.url = url == null ? string.Empty : Convert.ToString(url); navModel.order = reader.GetInt32(3); list.Add(navModel); } } ViewBag.list = list; return(View()); }
public static List <Toplam> SelectAllToplam(OleDbCommand komut) { List <Toplam> ListToplam = new List <Toplam>(); OleDbConnection baglanti = AcikBaglantiGetir(); try { komut.Connection = baglanti; OleDbDataReader oku = komut.ExecuteReader(); while (oku.Read()) { Toplam yeniToplam = new Toplam(); if (!oku.IsDBNull(0)) { yeniToplam.Id = oku.GetInt32(0); } if (!oku.IsDBNull(1)) { yeniToplam.Total = oku.GetInt32(1); } ListToplam.Add(yeniToplam); } } catch { throw; } finally { BaglantiyiKapat(baglanti); } return(ListToplam); }
public override List <Domain> GetDomains() { var _tmp = new List <Domain>(); using (OleDbConnection _conn = new OleDbConnection(connectionString)) { _conn.Open(); using (OleDbCommand _cmd = new OleDbCommand(@"SELECT domains.id, domains.name, hosting.fp_adm, accounts.[password], clients.login, clients.passwd, dom_level_usrs.passwd AS DomainPass, domains.status AS Status, NULL AS expiration FROM (((((domains LEFT OUTER JOIN hosting ON hosting.dom_id = domains.id) LEFT OUTER JOIN sys_users ON hosting.sys_user_id = sys_users.id) LEFT OUTER JOIN accounts ON accounts.id = sys_users.account_id) LEFT OUTER JOIN clients ON clients.id = domains.cl_id) LEFT OUTER JOIN dom_level_usrs ON dom_level_usrs.dom_id = domains.id) WHERE (domains.htype = 'vrt_hst') ORDER BY domains.id", _conn)) { using (OleDbDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new Domain(); _d.Id = (int)_read["Id"]; _d.Name = _read["name"].ToString(); _d.Username = _read["fp_adm"].ToString(); _d.Password = _read["password"].ToString(); _d.ClientName = _read["login"].ToString(); _d.Status = Convert.ToInt32(_read["Status"]); if (!_read.IsDBNull(6)) { _d.DomainPassword = _read["DomainPass"].ToString(); } if (!_read.IsDBNull(8)) { _d.Expiration = _d.FromUnixTime(_read["expiration"].ToString()); } _tmp.Add(_d); } } } _conn.Close(); } return(_tmp); }
/// <summary> /// 从数据库读流程节点前依赖关系 /// </summary> /// <param name="obj">流程信息</param> private void GetActPreRule(FlowChart obj) { string sCmd = "SELECT F_DEPNT_ID,F_DEPNT_ACT_ID,F_DEPNT_ACT_STATUS,F_PROC_ID " + "FROM WF_PRE_RULE where F_PROC_ID=" + obj.ID; OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = sCmd; OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { string currID = dr.IsDBNull(0) ? "" : dr.GetValue(0).ToString(); //F_DEPNT_ID string pID = dr.IsDBNull(1) ? "" : dr.GetValue(1).ToString(); //F_DEPNT_ACT_ID string pStatus = dr.IsDBNull(2) ? "" : dr.GetString(2); //F_DEPNT_ACT_STATUS //检索列表 wfActivity currAct = obj.GetActivityByID(currID); wfActivity pAct = obj.GetActivityByID(pID); if ((currAct != null) && (pAct != null)) { currAct.AddParent(pAct, pStatus); } } dr.Close(); dr.Dispose(); cmd.Dispose(); }
/// <summary> /// Gets the list of ISBNs /// </summary> /// <returns></returns> public List <Book> GetImgISBNList() { List <Book> l_ISBNs = new List <Book>(); OleDbCommand command = new OleDbCommand("SELECT ISBN , ISBN13 FROM BOOKS_WEB", conn); Book isbn = null; OleDbDataReader reader = null; try { conn.Open(); reader = command.ExecuteReader(); int ind_ISBN10 = 0; int ind_ISBN13 = 0; bool updateISBNFlag = false; if (reader.HasRows) { while (reader.Read()) { updateISBNFlag = false; isbn = new Book(); ind_ISBN10 = reader.GetOrdinal("ISBN"); ind_ISBN13 = reader.GetOrdinal("ISBN13"); if (!reader.IsDBNull(ind_ISBN10)) { isbn.ISBN10 = reader.GetString(ind_ISBN10); } else { updateISBNFlag = true; } if (!reader.IsDBNull(ind_ISBN13)) { isbn.ISBN13 = reader.GetString(ind_ISBN13); } if (updateISBNFlag) { isbn.ISBN10 = ISBNManager.UpdateISBN10(isbn.ISBN13, conn); } l_ISBNs.Add(isbn); } } } catch (OleDbException ex) { throw ex; } finally { reader.Close(); conn.Close(); } return(l_ISBNs); }
public static List <DTOClient> getListClient() { OleDbConnection connect = null; List <DTOClient> listClient = new List <DTOClient>(); try { connect = OpenConnect(); string stringCommand = "SELECT IDClient, Username, Password, IPAdr, NumPort, FlagSta FROM Client"; OleDbCommand command = new OleDbCommand(stringCommand, connect); OleDbDataReader readData = command.ExecuteReader(); while (readData.Read()) { DTOClient client = new DTOClient(); client.IDClient = readData.GetInt32(0); if (!readData.IsDBNull(1)) { client.UserName = readData.GetString(1); } if (!readData.IsDBNull(2)) { client.PassWord = readData.GetString(2); } if (!readData.IsDBNull(3)) { client.IPAdr = readData.GetString(3); } if (!readData.IsDBNull(4)) { client.NumPort = readData.GetInt32(4); } if (!readData.IsDBNull(5)) { client.FlagSta = readData.GetBoolean(5); } listClient.Add(client); } readData.Close(); } catch (Exception) { listClient = new List <DTOClient>(); } finally { try { if (connect == null && connect.State == System.Data.ConnectionState.Open) { connect.Close(); } } catch (NullReferenceException) { } } return(listClient); }
public List <RW_INSPECTION_HISTORY> getListInsp(String path) { List <RW_INSPECTION_HISTORY> list = new List <RW_INSPECTION_HISTORY>(); OleDbConnection conn = getConnect(path); try { conn.Open(); String sql = "SELECT * FROM [Inspections$] "; OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if (reader.HasRows) { if (!(reader.IsDBNull(2) || reader.IsDBNull(3) || reader.IsDBNull(4) || reader.IsDBNull(6))) { obj = new RW_INSPECTION_HISTORY(); //obj.ID = 1; obj.InspectionPlanName = reader[0].ToString(); obj.InspectionCoverageName = reader[1].ToString(); obj.EquipmentNumber = reader[2].ToString(); obj.ComponentNumber = reader[3].ToString(); obj.DM = reader[4].ToString(); obj.InspectionType = reader[5].ToString(); try { obj.InspectionDate = Convert.ToDateTime(reader[6].ToString()); } catch { obj.InspectionDate = DateTime.Now; } try { obj.InspectionEffective = reader[7].ToString(); } catch { obj.InspectionEffective = "E"; } list.Add(obj); } } } } catch (Exception e) { MessageBox.Show("ERROR!" + e.ToString()); } finally { conn.Close(); conn.Dispose(); } return(list); }
/// <summary> /// 圈选获取监所详细信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public JSDetail GetJSDetailByPoly(string id) { OleDbConnectionStringBuilder zzjgDBConnectBuilder = new OleDbConnectionStringBuilder(); zzjgDBConnectBuilder.Add("Provider", "MSDAORA"); zzjgDBConnectBuilder.Add("Data Source", ConfigHelper.GetValueByKey("webservice.config", "zzjgDB")); zzjgDBConnectBuilder.Add("Persist Security Info", true); zzjgDBConnectBuilder.Add("User ID", ConfigHelper.GetValueByKey("webservice.config", "zzjgDBUser")); zzjgDBConnectBuilder.Add("Password", ConfigHelper.GetValueByKey("webservice.config", "zzjgDBPasswd")); JSDetail info = new JSDetail(); try { using (OleDbConnection conn = new OleDbConnection(zzjgDBConnectBuilder.ConnectionString)) { //缺少照片数据 String sql = String.Format("select JSMC,LD,DH,DZ,BZRS from B_ZTK_SP_JSJBXX where JSBH='{0}'", id); conn.Open(); OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if (!reader.IsDBNull(0)) { info.JS_MC = reader[0].ToString(); } if (!reader.IsDBNull(1)) { info.DWLD_XM = reader[1].ToString(); } if (!reader.IsDBNull(2)) { info.DWLD_LXDH = reader[2].ToString(); } if (!reader.IsDBNull(3)) { info.GAJGXZ = reader[3].ToString(); } if (!reader.IsDBNull(4)) { info.RS = reader[4].ToString(); } } } } catch (Exception ex) { throw ex; } return(info); //string json = ServiceUtil.GetRemoteXmlStream(ConfigHelper.GetValueByKey("webservice.config", "圈选监所详细信息") + id, null); //return JsonConvert.DeserializeObject<List<JSDetail>>(json)[0]; }
public static List <FoodStuff> ListAllFoodstuffs() { //displays all foodstuffs that are not atomic items (that is, base ingredients) //this is determined by the RecipeMaterials entries: items where the Makes and MadeOf fields are identical //are atomic items. These are the ones we DO NOT want this function to return. List <FoodStuff> lstFoods = new List <FoodStuff>(); try { string query = "Select * from Foodstuff where FoodstuffID in (select Makes from RecipeMaterials where Makes <> MadeOf)"; //Not equals for Access is <> not != OleDbCommand cmd = new OleDbCommand(query, conn); DataConnection.OpenConnection(); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { List <Recipe> lstMats = DataConnection.ListOfIngredients(reader.GetString(0)); FoodStuff fs = new FoodStuff(reader.GetString(0), reader.GetString(1), reader.IsDBNull(2) ? "" : reader.GetString(2), reader.IsDBNull(3) ? -1 : reader.GetInt32(3), reader.IsDBNull(4) ? -1 : reader.GetInt32(4), reader.IsDBNull(5) ? -1.0 : reader.GetDouble(5), reader.IsDBNull(6) ? -1 : reader.GetInt32(6), null, lstMats); //tokenize the tags from their long string stored in the database. if (!(reader[7] is System.DBNull)) { string[] strTagList = reader.GetString(7).Split(','); if (strTagList.Length > 0) { foreach (string t in strTagList) { fs.AddTag(t); } } } lstFoods.Add(fs); } reader.Close(); } catch (Exception ex) { //don't do anything, apparently can't post messageboxes out of this thing ex.ToString(); } finally { DataConnection.CloseConnection(); } return(lstFoods); }
public override Record PopulateRecord(OleDbDataReader reader) { return(new Record { PID = reader.GetDouble(0), SaveDate = reader.GetDateTime(1), Clinic = reader.IsDBNull(2) == true ? null : reader.GetString(2), Operator = reader.GetInt32(3), TableName = reader.IsDBNull(4) == true ? null : reader.GetString(4) }); }
public static List <PhongDTO> LayDSPhong() { OleDbConnection link = null; List <PhongDTO> dsPhong = new List <PhongDTO>(); try { link = KetNoi(); string chuoiLenh = "Select MaPhong,TenPhong,Phong.MaLoaiPhong,TenLoaiPhong,SLKhachToiDa,DonGia,GhiChu,TinhTrang,SLKhach from Phong , LoaiPhong Where Phong.MaLoaiPhong=LoaiPhong.MaLoaiPhong order by MaPhong"; OleDbCommand lenh = new OleDbCommand(chuoiLenh, link); OleDbDataReader Doc = lenh.ExecuteReader(); while (Doc.Read()) { PhongDTO phg = new PhongDTO(); phg.MaPhong = Doc.GetString(0); phg.TenPhong = Doc.GetString(1); LoaiPhongDTO Loai = new LoaiPhongDTO(); Loai.MaLoaiPhong = Doc.GetInt32(2); Loai.TenLoaiPhong = Doc.GetString(3); Loai.SLKhachToiDa = Doc.GetInt32(4); Loai.DonGia = Doc.GetInt32(5); phg.LoaiPhong = Loai; if (!Doc.IsDBNull(7)) { phg.TinhTrang = Doc.GetString(7); } if (!Doc.IsDBNull(6)) { phg.GhiChu = Doc.GetString(6); } if (!Doc.IsDBNull(8)) { phg.SLKhach = Doc.GetInt32(8); } dsPhong.Add(phg); } } catch (Exception ex) { dsPhong = new List <PhongDTO>(); } finally { if (link != null && link.State == System.Data.ConnectionState.Open) { link.Close(); } } return(dsPhong); }
private void txtMaKH_TextChanged(object sender, EventArgs e) { KhoiTao(); if (txtMaKH.Text.Length == 0) { return; } OleDbCommand cmd = new OleDbCommand(); cmd.Connection = Form1.cnn; cmd.CommandText = "select TenKH, cmnd, sotien from khachhang where makh = " + txtMaKH.Text; try { OleDbDataReader rd = cmd.ExecuteReader(); if (rd.Read()) { if (!rd.IsDBNull(0)) { lblTenKH.Text = rd.GetString(0); } if (!rd.IsDBNull(1)) { lblCMND.Text = rd.GetInt32(1).ToString(); } if (!rd.IsDBNull(2)) { lblSoTien.Text = rd.GetDecimal(2).ToString(); } if (butDongY.Enabled == false) { butDongY.Enabled = true; } } else if (butDongY.Enabled == true) { butDongY.Enabled = false; } } catch (Exception e1) { if (butDongY.Enabled == true) { butDongY.Enabled = false; } } }
public Provincia GetProvinciaById(int id) { if (_provincie.Count == 0) { Provincia p = null; OleDbConnection c = new OleDbConnection(_connString); c.Open(); OleDbCommand cmd = new OleDbCommand("select * from TB_PROVINCIE where ID = " + id.ToString(), c); OleDbDataReader r = cmd.ExecuteReader(); while (r.Read()) { int id1 = r.IsDBNull(0) ? -1 : (int)r.GetValue(0); Key k = new Key(id1); string descrizione = r.IsDBNull(1) ? null : (string)r.GetValue(1); string sigla = r.IsDBNull(2) ? null : (string)r.GetValue(2); int idRegione = r.IsDBNull(3) ? -1 : (int)r.GetValue(3); p = new Provincia(k, descrizione, idRegione, sigla); } r.Close(); c.Close(); if (p == null) { return(new ProvinciaNulla()); } return(p); } else { foreach (Provincia item in _provincie) { if (item.Id.Equals(id)) { return(item); } } return(new ProvinciaNulla()); } //Provincia p = _ps.GetObject("Provincia", id) as Provincia ; //if (p == null) // return new ProvinciaNulla(); //return p; //return null; }
/// <summary> /// 从数据库读流程节点信息 /// </summary> /// <param name="obj"></param> private void GetFlowchartActs(FlowChart obj) { string sCmd = "SELECT F_ID,F_PROCESS_ID,F_NAME,F_TIME_ALLOWED,F_RULE_APPLIED," + "F_EX_PRE_RULE_FUNC,F_EX_POST_RULE_FUNC,F_ACT_TYPE,F_OR_MERGE_FLAG,F_NUM_VOTE_NEEDED," + "F_AUTO_EXEC,F_ACT_DESC FROM WF_ACTIVITY where F_PROCESS_ID=" + obj.ID; OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = sCmd; OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { //数据实例化 wfActivity newact = new wfActivity(); newact.ID = dr.GetValue(0).ToString(); //F_ID newact.Name = dr.IsDBNull(2) ? "" : dr.GetString(2); //F_NAME newact.TimeAllowed = dr.IsDBNull(3) ? 0: dr.GetInt32(3); //F_TIME_ALLOWED newact.ActType = dr.IsDBNull(7) ? "" : dr.GetString(7); //F_ACT_TYPE newact.OrMergeFlag = dr.IsDBNull(8) ? 0 : (int)dr.GetInt16(8); //F_OR_MERGE_FLAG newact.NumVotesNeeded = dr.IsDBNull(9) ? 0 : (int)dr.GetInt16(9); //F_NUM_VOTE_NEEDED newact.AutoExecutive = dr.IsDBNull(10) ? false : dr.GetInt16(10) == 1; //F_AUTO_EXEC newact.Desc = dr.IsDBNull(11) ? "" : dr.GetString(11); //F_ACT_DESC newact.PreRule = dr.IsDBNull(5) ? "" : dr.GetString(5); //添加到fchart 活动列表 obj.AddActivity(newact); //读授权信息 GetActAssgn(newact); } dr.Close(); dr.Dispose(); cmd.Dispose(); }
public override Operator PopulateRecord(OleDbDataReader reader) { return(new Operator { OID = reader.GetInt32(0), SaveDate = reader.GetDateTime(1), FName = (reader.IsDBNull(2) == true?null:reader.GetString(2)), SName = (reader.IsDBNull(3) == true ? null : reader.GetString(3)), Username = (reader.IsDBNull(4) == true ? null : reader.GetString(4)), Pswd = (reader.IsDBNull(5) == true ? null : reader.GetString(5)), EnrollFingers = reader.GetInt16(6), LastLogin = reader.GetDateTime(7) }); }
private void LoadCompanyDetails(int cID) { OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/company.mdb")); myConn.Open(); string query = "SELECT name, description, address, phone, fax, email, homepage, contact FROM Company where ID = " + cID.ToString(); OleDbCommand myComm = new OleDbCommand(query, myConn); OleDbDataReader myReader = myComm.ExecuteReader(); while (myReader.Read()) { lName.Text = myReader.IsDBNull(0) ? "" : myReader.GetString(0); lDescription.Text = myReader.IsDBNull(1) ? "" : myReader.GetString(1); lAddress.Text = myReader.IsDBNull(2) ? "" : myReader.GetString(2); lPhone.Text = myReader.IsDBNull(3) ? "" : myReader.GetString(3); lFax.Text = myReader.IsDBNull(4) ? "" : myReader.GetString(4); lEmail.Text = myReader.IsDBNull(5) ? "" : myReader.GetString(5); lHomepage.Text = myReader.IsDBNull(6) ? "" : myReader.GetString(6); lContact.Text = myReader.IsDBNull(7) ? "" : myReader.GetString(7); } myReader.Close(); myConn.Close(); }
public Form1() { InitializeComponent(); PC.list = new List <PC>(); PC.total = new List <PC>(); data.Columns.Add("Id", "Id"); data.Columns.Add("PC", "PC"); data.Columns.Add("Inicio", "Inicio"); data.Columns.Add("Tiempo", "Tiempo"); data.Columns.Add("Total", "Total"); data.Columns[3].Width = 130; data.Columns[3].Width = 130; r = MSAConnection.read("select * from item"); while (r.Read()) { String d = ""; PC p = new PC(); p.id = r.GetInt32(0); p.precio = r.GetInt32(2); if (!r.IsDBNull(3)) { //d = r.GetDateTime(3).ToString(); DateTime x = r.GetDateTime(3); d = x.Hour + ":" + x.Minute + ":" + x.Second; p.inicio = r.GetDateTime(3); PC.list.Add(p); } PC.total.Add(p); data.Rows.Add(r.GetInt32(0), r.GetString(1), d); } // MessageBox.Show(PC.total.Count + ""); thetimer.Start(); }
private decimal Cash_in() { decimal cashin = 0; dbConn.Open(); OleDbCommand dbCommand = new OleDbCommand(); dbCommand.Connection = dbConn; string sSQL = "SELECT sum(amount) from cash WHERE Format(actiondate, 'Short Date')=DATE() AND relate_to <> 'pur'"; //string sSQL = "SELECT sum(amount) from cash WHERE relate_to <> 'pur'"; dbCommand.CommandText = sSQL; OleDbDataReader reader = dbCommand.ExecuteReader(); if (reader.Read()) { if (reader.IsDBNull(0)) { cashin = 0; } else { cashin = Convert.ToDecimal(reader[0]); } } dbConn.Close(); return(cashin); }
/// <summary> /// 获取活动授权用户信息 /// </summary> /// <param name="act"></param> private void GetActAssgn(wfActivity act) { OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = "select F_BASED_ON,F_USER_ID from WF_ASSGN_RULE where F_ACT_ID=" + act.ID; OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { if (!dr.IsDBNull(1)) { string uid = dr.GetString(1); string utype = dr.GetString(0); string uName = ""; if (utype == wfConsts.ASSIGN_TYPE_USER) { uName = dbData.UserNameFromUserCode(ConnStr, uid); } else { uName = dbData.RoleNameFromRoleID(ConnStr, uid); } act.UserList.Add(uid, utype, uName); } } }
public static double GTP(EIsPersonel EeO) { OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Veritabani\\Data.mdb;Jet OLEDB:Database Password=ayakkabi_gelisimsoft;"); if (con.State == ConnectionState.Closed) { con.Open(); } OleDbCommand com = new OleDbCommand("select SUM(Ucret) as [Ucret] from IsPersonel WHERE ((IsPersonel.personelID)=@ID)", con); com.Parameters.AddWithValue("@ID", EeO.personelID); OleDbDataReader dr = com.ExecuteReader(); while (dr.Read()) { if (!dr.IsDBNull(0)) { gidenGTP = Convert.ToDouble(dr["Ucret"].ToString()); } else { gidenGTP = 0; } } con.Close(); return(gidenGTP); }