public static bool Update(string name) { bool rst = false; try { SqlDbOperHandler doh = new SqlDbOperHandler(); doh.Reset(); doh.SqlCmd = "UPDATE Table_test set name ='" + name + "' where (Password ='******') "; doh.ExecuteSqlNonQuery(); doh.Dispose(); rst = true; return(rst); } catch (Exception e) { return(rst); } }
public static bool Added(string name, string Password, string id) { bool rst = false; try { SqlDbOperHandler doh = new SqlDbOperHandler(); doh.Reset(); doh.SqlCmd = "insert into Table_test (name,Password,id) values ('" + name + "'," + Password + ",'" + id + "')"; doh.ExecuteSqlNonQuery(); doh.Dispose(); rst = true; return(rst); } catch (Exception e) { return(rst); } }
public static bool Deleteing(string name) { bool rst = false; try { SqlDbOperHandler doh = new SqlDbOperHandler(); doh.Reset(); doh.SqlCmd = "DELETE FROM Table_2 WHERE name = '" + name + "' "; doh.ExecuteSqlNonQuery(); doh.Dispose(); rst = true; return(rst); } catch (Exception e) { return(rst); } }
public static bool Added(string contend, string name, string time) { bool rst = false; try { SqlDbOperHandler doh = new SqlDbOperHandler(); doh.Reset(); doh.SqlCmd = "insert into Table_yan (contend,name,time) values ('" + contend + "','" + name + "','" + time + "')"; doh.ExecuteSqlNonQuery(); doh.Dispose(); rst = true; return(rst); } catch (Exception e) { return(rst); } }
/// <summary> /// 将注册的用户更新到表中 /// </summary> /// <param name="name"></param> /// <param name="password"></param> /// <param name="id"></param> /// <returns></returns> public static bool insertToTabel(string name, string password) { bool rst = false; try { SqlDbOperHandler doh = new SqlDbOperHandler(); doh.Reset(); doh.SqlCmd = " set rowcount 1 update Table_test set name = '" + name + "' where (name is null or name = '') and password = '******' and id = 1 '" + "'"; doh.ExecuteSqlNonQuery(); doh.Dispose(); rst = true; return(rst); } catch (Exception e) { return(rst); } }
private int InsertTicketsSql(DateTime meal_date, string meal_location, string meal_type, string meal, decimal amount, string identification, string operator_man, DateTime ticketCreate) { try { SqlDbOperHandler doh = new SqlDbOperHandler();//开启数据库连接 doh.Reset(); doh.SqlCmd = String.Format("insert into [m_t_application] (meal_date,meal_location,meal_type,meal,amount,identification,operator_man,ticketStatus,ticketCreate)" + " values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}');", meal_date.Date, meal_location, meal_type, meal, amount.ToString("#0.00"), identification, operator_man, "未使用", ticketCreate); //"insert into [m_t_application] (meal_date,meal_location,,meal_type,meal,amount,identification,operator_man,ticketStatus,ticketCreate) values();";//sql语句 doh.ExecuteSqlNonQuery(); //执行不返回的方法 doh.Dispose(); //释放资源 } catch (Exception e) { //自己写的打印日志的工具类 LogClass.CreateLog("error:" + e.Message.ToString()); return(1); } return(0); }