public string GetNoJson(DatabseSend database) { var com = database.No; var sb = new StringBuilder(); sb.Append("{"); foreach (var p in com.GetType().GetProperties()) { sb.Append("\"" + p.Name + "\":\"" + p.GetValue(com, null) + "\","); } return(sb.ToString().TrimEnd(',') + "}"); }
public string SuperBoyAnalytical(DatabseSend database) { // Model.Public.DatabseSend database = new Model.Public.DatabseSend(); IAnalyticalModel analytical = new AnalyticalModel(); var sendStr = ""; switch (database.SendType) { case EnumArryModel.SendType.Select: sendStr = analytical.Select(database); break; case EnumArryModel.SendType.Update: sendStr = analytical.Update(database); break; case EnumArryModel.SendType.Delete: sendStr = analytical.Delete(database); break; case EnumArryModel.SendType.Inster: sendStr = analytical.Inster(database); break; case EnumArryModel.SendType.Online: sendStr = analytical.Online(database); break; case EnumArryModel.SendType.Manage: sendStr = analytical.Manage(database); break; default: break; } return(sendStr); }
public string Select(DatabseSend database) { _dic = database.Dic; //通过权限表 //权限审核通过后执行拆分并组装 var sqlStr = new StringBuilder(); sqlStr.Append("[" + GetNoJson(database) + ","); sqlStr.Append("{\"Type\":\"SELECT\""); //行数 if (_dic.ContainsKey(EnumArryModel.Database.Top)) { sqlStr.Append(",\"TOP\":\"" + _dic[EnumArryModel.Database.Top] + "\""); } else { sqlStr.Append(",\"TOP\":\"false\""); } //字段名 if (_dic.ContainsKey(EnumArryModel.Database.Field)) { sqlStr.Append(",\"Field\":\""); var str = (string[])_dic[EnumArryModel.Database.Field]; if (str[0].Trim() != "*") { var item = string.Join(",", str); sqlStr.Append(item + "\""); } else { sqlStr.Append("*\""); } } else { sqlStr.Append(",\"Field\":*"); } //表名 sqlStr.Append(",\"From\":\"" + _dic[EnumArryModel.Database.TableName] + "\""); //条件,如果条件存在,并且条件不等于false if (_dic.ContainsKey(EnumArryModel.Database.Where) && Convert.ToBoolean(_dic[EnumArryModel.Database.Where])) { /* * public static Object Parse(Type enumType,string value) * 例如:(Colors)Enum.Parse(typeof(Colors), "Red") */ //对比 var whereType = (EnumArryModel.WhereType) Enum.Parse(typeof(EnumArryModel.WhereType), _dic[EnumArryModel.Database.Wheretype].ToString()); sqlStr.Append(",\"Key\":" + "\"" + _dic[EnumArryModel.Database.Key] + "\""); sqlStr.Append(",\"Value\":" + "\"" + _dic[EnumArryModel.Database.Value] + "\""); sqlStr.Append(",\"Where\":\"true\""); sqlStr.Append(",\"WhereType\":"); switch (whereType) { case EnumArryModel.WhereType.Equal: sqlStr.Append("\"Equal\""); break; case EnumArryModel.WhereType.Greater: sqlStr.Append("\"Greater\""); break; case EnumArryModel.WhereType.Less: sqlStr.Append("\"Less\""); break; case EnumArryModel.WhereType.Like: sqlStr.Append("\"Like\""); break; case EnumArryModel.WhereType.LiftLike: sqlStr.Append("\"LiftLike\""); break; case EnumArryModel.WhereType.RightLike: sqlStr.Append("\"RightLike\""); break; default: break; } } switch (database.ReturnType) { case EnumArryModel.ReturnType.Json: sqlStr.Append(",\"ReturnType\":\"JSON\""); break; case EnumArryModel.ReturnType.Xml: sqlStr.Append(",\"ReturnType\":\"XML\""); break; case EnumArryModel.ReturnType.KeyValue: sqlStr.Append(",\"ReturnType\":\"KeyValue\""); break; case EnumArryModel.ReturnType.List: sqlStr.Append(",\"ReturnType\":\"LIST\""); break; case EnumArryModel.ReturnType.Dict: sqlStr.Append(",\"ReturnType\":\"DICT\""); break; default: sqlStr.Append(",\"ReturnType\":\"KeyValue\""); break; } sqlStr.Append("}]"); return(sqlStr.ToString()); }
public string Manage(DatabseSend database) { throw new NotImplementedException(); }
public string Inster(DatabseSend database) { throw new NotImplementedException(); }