/// <summary>/// 删除数据/// </summary>/// <param name="_tableName">表单名称</param>/// <param name="_field">表单中字段</param>/// <param name="_fieldValue">表单中字段赋值</param>private void DeleteData(string _tableName, string[] _field, string[] _fieldValue){//sql.Delete("momo", new string[] { "qq", "email" }, new string[] { "34546546", "'
[email protected]'" });try{sql.Delete(_tableName, _field, _fieldValue);sql.Close();}catch (Exception e){Error = e.Message;}}/// <summary>/// 更新数据(通过关系字段及值确定在表中的数据组,并更新在数据组中需要更新的数据)/// </summary>/// <param name="tableName">数据表名</param>/// <param name="_field">需要更新的字段</param>/// <param name="_fieldValue">需要更新的字段对应的值</param>/// <param name="_verifyField">关系字段</param>/// <param name="_verifyFieldValue">关系字段值</param>private void UpdateData(string _tableName, string[] _field, string[] _fieldValue,string _verifyField,string _verifyFieldValue){//sql.UpdateInto("momo", new string[] { "name", "qq" }, new string[] { "'ruoruo'", "'11111111'" }, "email", "'
[email protected]'");try{sql.UpdateInto(_tableName, _field, _fieldValue, _verifyField, _verifyFieldValue);sql.Close();}catch (Exception e){Error = e.Message;}}/// <summary>/// 查找数据(通过关系字段及值确定在表中的数据组,并查找在数据组中需要查找的数据)/// </summary>/// <param name="_tableName"></param>/// <param name="_field">查找的数据字段</param>/// <param name="_verifyField">关系字段</param>/// <param name="_verifyFieldValue">关系字段值</param>private void SelectData(string _tableName, string[] _field, string[] _verifyField, string[] _verifyFieldValue){//DataSet ds = sql.SelectWhere("momo", new string[] { "name", "email" }, new string[] { "qq" }, new string[] { "=" }, new string[] { "34546546" });try{DataSet ds = sql.SelectWhere(_tableName, _field, _verifyField, new string[] { "=" }, _verifyFieldValue);sql.Close();if (ds != null){DataTable table = ds.Tables[0];foreach (DataRow row in table.Rows){foreach (DataColumn column in table.Columns){Debug.Log(row[column]);}}}}catch (Exception e){Error = e.Message;}}// Update is called once per framevoid OnGUI(){if (Error != null){GUILayout.Label(Error);}}}