public ConfigMiniPokerItem GetConfigXengDetail(int id) { var rs = new ConfigMiniPokerItem(); var sql = "SELECT * FROM [newDB].[dbo].configQuayXeng where id = " + id; var conn = new SqlConnection(Constants.DBConnection); var MyCommand = new SqlCommand(sql, conn); SqlDataReader MyReader; conn.Open(); MyReader = MyCommand.ExecuteReader(); while (MyReader.Read()) { rs = new ConfigMiniPokerItem { Id = MyReader.GetInt32(MyReader.GetOrdinal("id")), a = MyReader.GetInt32(MyReader.GetOrdinal("a")), a1 = MyReader.GetInt32(MyReader.GetOrdinal("a1")), a2 = MyReader.GetInt32(MyReader.GetOrdinal("a2")), a3 = MyReader.GetInt32(MyReader.GetOrdinal("a3")), a4 = MyReader.GetInt32(MyReader.GetOrdinal("a4")), a5 = MyReader.GetInt32(MyReader.GetOrdinal("a5")), a6 = MyReader.GetInt32(MyReader.GetOrdinal("a6")) }; } MyReader.Close(); conn.Close(); return(rs); }
public int UpdateConfigTaiXiu(ConfigMiniPokerItem obj) { var rowAffected = 0; const string sql = "update [newDB].[dbo].configBotTaixiu set a1 = @a1, a2 = @a2, a3=@a3, a4=@a4, a5=@a5, a6=@a6 , a7=@a7 ,a8=@a8 ,a9=@a9 ,a10=@a10 ,a11=@a11 ,a12=@a12 ,a13=@a13 ,a14=@a14 ,a15=@a15 ,a16=@a16 ,a17=@a17 ,a18=@a18 ,a19=@a19"; var conn = new SqlConnection(Constants.DBConnection); var myCommand = new SqlCommand(sql, conn); myCommand.Parameters.AddWithValue("a1", obj.a1); myCommand.Parameters.AddWithValue("a2", obj.a2); myCommand.Parameters.AddWithValue("a3", obj.a3); myCommand.Parameters.AddWithValue("a4", obj.a4); myCommand.Parameters.AddWithValue("a5", obj.a5); myCommand.Parameters.AddWithValue("a6", obj.a6); myCommand.Parameters.AddWithValue("a7", obj.a7); myCommand.Parameters.AddWithValue("a8", obj.a8); myCommand.Parameters.AddWithValue("a9", obj.a9); myCommand.Parameters.AddWithValue("a10", obj.a10); myCommand.Parameters.AddWithValue("a11", obj.a11); myCommand.Parameters.AddWithValue("a12", obj.a12); myCommand.Parameters.AddWithValue("a13", obj.a13); myCommand.Parameters.AddWithValue("a14", obj.a14); myCommand.Parameters.AddWithValue("a15", obj.a15); myCommand.Parameters.AddWithValue("a16", obj.a16); myCommand.Parameters.AddWithValue("a17", obj.a17); myCommand.Parameters.AddWithValue("a18", obj.a18); myCommand.Parameters.AddWithValue("a19", obj.a19); conn.Open(); rowAffected = myCommand.ExecuteNonQuery(); conn.Close(); return(rowAffected); }
public List <ConfigMiniPokerItem> GetConfigXeng() { var rs = new List <ConfigMiniPokerItem>(); var sql = "SELECT top 1 * FROM [newDB].[dbo].configQuayXeng ORDER BY id DESC"; var conn = new SqlConnection(Constants.DBConnection); var MyCommand = new SqlCommand(sql, conn); SqlDataReader MyReader; conn.Open(); MyReader = MyCommand.ExecuteReader(); while (MyReader.Read()) { var u = new ConfigMiniPokerItem { Id = MyReader.GetInt32(MyReader.GetOrdinal("id")), a = MyReader.GetInt32(MyReader.GetOrdinal("a")), a1 = MyReader.GetInt32(MyReader.GetOrdinal("a1")), a2 = MyReader.GetInt32(MyReader.GetOrdinal("a2")), a3 = MyReader.GetInt32(MyReader.GetOrdinal("a3")), a4 = MyReader.GetInt32(MyReader.GetOrdinal("a4")), a5 = MyReader.GetInt32(MyReader.GetOrdinal("a5")), a6 = MyReader.GetInt32(MyReader.GetOrdinal("a6")) }; rs.Add(u); } MyReader.Close(); conn.Close(); return(rs); }
public ActionResult Action(ConfigMiniPokerItem objSubmit) { gamePlayerRepository.UpdateConfigXeng(objSubmit); var objLogs = new tblGameConfigLogs { a = objSubmit.a, a1 = objSubmit.a1, a2 = objSubmit.a2, a3 = objSubmit.a3, a4 = objSubmit.a4, a5 = objSubmit.a5, a6 = objSubmit.a6, a7 = objSubmit.a7, a8 = objSubmit.a8, a9 = objSubmit.a9, a10 = objSubmit.a10, DateCreared = DateTime.Now, CreateBy = User.Identity.Name, gameId = 19 }; //gamePlayerRepository.AddGameLogs(objLogs); return(Json(new { Error = false }, JsonRequestBehavior.AllowGet)); }
public ActionResult EditForm(int?id) { var obj = new ConfigMiniPokerItem(); if (id.HasValue) { obj = gamePlayerRepository.GetConfigXengDetail(id.Value); } return(Json(new { data = obj }, JsonRequestBehavior.AllowGet)); }
public List <ConfigMiniPokerItem> GetConfigTaiXiu() { var rs = new List <ConfigMiniPokerItem>(); var sql = "SELECT * FROM [newDB].[dbo].configBotTaixiu"; var conn = new SqlConnection(Constants.DBConnection); var MyCommand = new SqlCommand(sql, conn); SqlDataReader MyReader; conn.Open(); MyReader = MyCommand.ExecuteReader(); while (MyReader.Read()) { var u = new ConfigMiniPokerItem { a1 = MyReader.GetInt32(MyReader.GetOrdinal("a1")), a2 = MyReader.GetInt32(MyReader.GetOrdinal("a2")), a3 = MyReader.GetInt32(MyReader.GetOrdinal("a3")), a4 = MyReader.GetInt32(MyReader.GetOrdinal("a4")), a5 = MyReader.GetInt32(MyReader.GetOrdinal("a5")), a6 = MyReader.GetInt32(MyReader.GetOrdinal("a6")), a7 = MyReader.GetInt32(MyReader.GetOrdinal("a7")), a8 = MyReader.GetInt32(MyReader.GetOrdinal("a8")), a9 = MyReader.GetInt32(MyReader.GetOrdinal("a9")), a10 = MyReader.GetInt32(MyReader.GetOrdinal("a10")), a11 = MyReader.GetInt32(MyReader.GetOrdinal("a11")), a12 = MyReader.GetInt32(MyReader.GetOrdinal("a12")), a13 = MyReader.GetInt32(MyReader.GetOrdinal("a13")), a14 = MyReader.GetInt32(MyReader.GetOrdinal("a14")), a15 = MyReader.GetInt32(MyReader.GetOrdinal("a15")), a16 = MyReader.GetInt32(MyReader.GetOrdinal("a16")), a17 = MyReader.GetInt32(MyReader.GetOrdinal("a17")), a18 = MyReader.GetInt32(MyReader.GetOrdinal("a18")), a19 = MyReader.GetInt32(MyReader.GetOrdinal("a19")), }; rs.Add(u); } MyReader.Close(); conn.Close(); return(rs); }
public int UpdateConfigXeng(ConfigMiniPokerItem obj) { var rowAffected = 0; const string sql = "update [newDB].[dbo].configQuayXeng set a=@a, a1 = @a1, a2 = @a2, a3=@a3, a4=@a4, a5=@a5, a6=@a6 where id = @id"; var conn = new SqlConnection(Constants.DBConnection); var myCommand = new SqlCommand(sql, conn); myCommand.Parameters.AddWithValue("a", obj.a); myCommand.Parameters.AddWithValue("a1", obj.a1); myCommand.Parameters.AddWithValue("a2", obj.a2); myCommand.Parameters.AddWithValue("a3", obj.a3); myCommand.Parameters.AddWithValue("a4", obj.a4); myCommand.Parameters.AddWithValue("a5", obj.a5); myCommand.Parameters.AddWithValue("a6", obj.a6); myCommand.Parameters.AddWithValue("id", obj.Id); conn.Open(); rowAffected = myCommand.ExecuteNonQuery(); conn.Close(); return(rowAffected); }