|
本帖最后由 kisshexuxia 于 2016-5-16 15:11 编辑
- public static JSONObject queryCount(JSONObject paramsObject, ActionContext context)
- {
- JSONObject ret = new JSONObject();
- string x = paramsObject["x"].ToString();
- string y = paramsObject["y"].ToString();
- ret.Add("orderCount", x + y);
- ret.Add("x", x);
- ret.Add("y", y);
- using (var conn = context.Connection("lngy"))
- {
- const string sql = "SELECT COUNT(*) AS orderCount "
- + " FROM RS_BMGL ";
- int count = int.Parse(Util.GetValueBySql((DbConnection)conn, sql, null).ToString());
- ret.Add("queryCount", count);
- // ((HttpResponse)context.Get(ActionContext.RESPONSE)).Write(ret.ToString());
- }
- return ret;
- }
复制代码
在VS2015调试的时候执行到
- int count = int.Parse(Util.GetValueBySql((DbConnection)conn, sql, null).ToString());
复制代码 数据库是sql server2008
报{"ExecuteScalar 要求已打开且可用的 Connection。连接的当前状态为已关闭。"}
连接sql server2008数据库不知道怎么写
- using (var conn = context.Connection("lngy"))
复制代码 是不是这样写是错误的、lngy这个是我在WEX5里配置的数据库
上面的问题解决了、是因为我没写Open();小白了我~~~~~~~
- public class CRUD
- {
- public const string QUERY_TREE_PARENT_VAR_NAME = "_sys_tree_parent_value_";
- public CRUD();
- public static JObject query(JObject jObject, ActionContext context);
- public static JObject query(JObject jObject, IDbConnection conn);
- public static JObject save(JObject jObject, ActionContext context);
- public static JObject save(JObject jObject, DbConnection conn);
- public static JObject sqlQuery(JObject paramObject, ActionContext context);
- }
复制代码
这边的代码封装的我们看不见吧、我想返回整个表的数据不知道要怎么修改。
- public static JSONObject queryCount(JSONObject paramsObject, ActionContext context)
- {
- JSONObject ret = new JSONObject();
- using (var conn = context.Connection("lngy"))
- {
- const string sql = "SELECT * "
- + " FROM RS_BMGL ";
- conn.Open();
- var table = Util.QueryData(conn, sql, null, null, null, null);
- }
- return ret;
- }
复制代码
问题已解决源码路径在D:\WeX5_V3.4\source\baas.net\Com.Justep.Baas
|
|