public int insertUpdateBoardWrite(string userId, string userName, string category, string mainBoardTitle, string mainBoardContent, DateTime nowDate, string statementType) { int result = -1; BoardUserInfo boardUserInfo = new BoardUserInfo(); boardUserInfo.userID = userId; boardUserInfo.userName = userName; boardUserInfo.category = category; boardUserInfo.mainBoardTitle = mainBoardTitle; boardUserInfo.mainBoardContent = mainBoardContent; boardUserInfo.mainBoardPwd = ""; boardUserInfo.writeDate = nowDate; using (SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ToString())) { string spName = "sp_MainBoard_CRUD"; using (SqlCommand sqlComm = new SqlCommand(spName, sqlConn)) { sqlComm.Parameters.Add("@mainBoardNo", SqlDbType.NVarChar).Value = 0; sqlComm.Parameters.Add("@userID", SqlDbType.NVarChar).Value = userId; sqlComm.Parameters.Add("@id_Name", SqlDbType.NVarChar).Value = userName; sqlComm.Parameters.Add("@category", SqlDbType.NVarChar).Value = category; sqlComm.Parameters.Add("@mainBoardTitle", SqlDbType.NVarChar).Value = mainBoardTitle; sqlComm.Parameters.Add("@mainBoardContent", SqlDbType.NVarChar).Value = mainBoardContent; sqlComm.Parameters.Add("@writeDate", SqlDbType.DateTime).Value = nowDate; sqlComm.Parameters.Add("@StatementType", SqlDbType.NVarChar).Value = statementType; sqlComm.CommandType = CommandType.StoredProcedure; sqlConn.Open(); result = Convert.ToInt32(sqlComm.ExecuteScalar()); } } return(result); }
public DataTable SelectBoardView(string userId, string category, string boardNo, string statementType) { BoardUserInfo boardUserInfo = new BoardUserInfo(); DataSet result = new DataSet(); boardUserInfo.userID = userId; boardUserInfo.category = category; boardUserInfo.boardNo = boardNo; using (SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ToString())) { string spName = "sp_MainBoard_CRUD"; using (SqlCommand sqlComm = new SqlCommand(spName, sqlConn)) { using (SqlDataAdapter sqlAdt = new SqlDataAdapter(sqlComm)) { sqlComm.Parameters.Add("@mainBoardNo", SqlDbType.NVarChar).Value = boardNo; sqlComm.Parameters.Add("@userID", SqlDbType.NVarChar).Value = userId; sqlComm.Parameters.Add("@category", SqlDbType.NVarChar).Value = category; sqlComm.Parameters.Add("@StatementType", SqlDbType.NVarChar).Value = statementType; sqlComm.CommandType = CommandType.StoredProcedure; sqlConn.Open(); sqlAdt.Fill(result); } } } if (result.Tables.Count >= 1) { return(result.Tables[0]); } else { return(null); } }