private static string GetForAll(string tablename,
string key, string name, string nameField = "Name")
{
var nameValue = key.IsNullOrEmpty() ? name : key;
return(SAction.Select(tablename, nameField.ToLikeWhere(nameValue), "Name").ToJson());
}
public static string GetDept(string key, string id, bool isDept, string pid)
{
var where = "isUsing=1" +
" and " + "name".ToLikeWhere(key) +
" and " + "id".ToWhere(id) +
" and " + "pId".ToWhere(pid);
where += " and " + (isDept ? "id>1000 and id<999999" : "id>1000000");
return(SAction.Select("SysDepartment", where, "id", "name").ToJson().Replace(" 00:00:00", ""));
}
public static string GetPersonal(string key, string personalIdCard)
{
string where = "PersonalIdCard".ToInWhere(personalIdCard);
if (key.IsNotNullEmpty())
{
where += " and IsUsing=1 and " +
"fullname".ToLikeWhere(key);
}
return(SAction.Select("Personal", where,
"PersonalIdCard", "Fullname").ToJson());
}
public static string Login(string username, string pwd)
{
var cookie = HttpContext.Current.Request.Cookies["login"];
//if (cookie != null)
//{
// return SJson.GetError("您已经登录，请退出登录。");
//}
if (SAction.Select("SysUser", "Username".ToWhere(username, false) + " and " + "Password".ToWhere(pwd, false), "ID").Rows.Count > 0)
{
if (cookie == null)
{
cookie = new HttpCookie("login");
}
cookie.Values.Clear();
cookie.Values.Add("username", username);
HttpContext.Current.Response.Cookies.Clear();
//cookie.Expires = DateTime.Now.AddHours(1);
HttpContext.Current.Response.Cookies.Add(cookie);
return(SJson.Success);
}
return(SJson.Error);
}
public static string Get()
{
return(SAction.Select("SysMenu", "Isusing=1").ToJson());
}
