public void GetBooks(string path)
{
response = Client.Client.Create().Get <Books>(path);
Assert.That(response.StatusCode, Is.EqualTo(HttpStatusCode.OK), "OKEY");
List <Books> booksResponse_Exp =
JsonConverter.ConvertJson <List <Books> >(response.Content); //deserialize edilir
Assert.That(booksResponse_Exp, Is.Not.Null);
Assert.IsInstanceOf <List <Books> >(booksResponse_Exp);
}
// Burda idsi 3 numaralı kitap var mı diye test ediyorum.
//Ama elimizde sadece 2 tane kitap var bundan dolayı da çalışmadığını gösteriyorum.
public void GetBookWithInvalidId(string name, string value, ParameterType type, string path)
{
response = Client.Client.Create().Get <Books>(new Parameter(name, value, type), path);
Assert.That(response.StatusCode, Is.EqualTo(HttpStatusCode.OK), "oldu");
var booksResponse_Exp =
JsonConverter.ConvertJson <Books>(response.Content); //deserialize edilir
Assert.That(booksResponse_Exp, Is.Null);
Assert.IsInstanceOf <Books>(booksResponse_Exp, "Bulunamadı");
}
public static dynamic SqlFunctionForDynamic(this Database db,
string sql,
params object[] parameters)
{
IDbConnection conn = DefaultConnection;
//ADO.NET数据库连接字符串
conn.ConnectionString = DefaultConnectionString;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
IDbCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
if (parameters != null)
{
foreach (var item in parameters)
{
cmd.Parameters.Add(item);
}
}
//1、DataReader查询数据
using (IDataReader dataReader = cmd.ExecuteReader())
{
if (!dataReader.Read())
{
return(null);
}
//2、DataReader转换Json
string jsonstr = JsonConverter.ToJson(dataReader);
dataReader.Close();
dataReader.Dispose();
cmd.Dispose();
conn.Close();
conn.Dispose();
//3、Json转换动态类
dynamic dyna = JsonConverter.ConvertJson(jsonstr);
return(dyna);
}
}
public ActionResult SignUpFile()
{
var jsonM = new JsonHelper()
{
Status = "n", Msg = "success"
};
try
{
//取得上传文件
HttpPostedFileBase upfile = Request.Files["fileUp"];
//原始文件路径
string delpath = Request.QueryString["delpath"];
//缩略图
bool isThumbnail = string.IsNullOrEmpty(Request.QueryString["isThumbnail"]) ? false : Request.QueryString["isThumbnail"].ToLower() == "true" ? true : false;
//水印
bool isWater = string.IsNullOrEmpty(Request.QueryString["isWater"]) ? false : Request.QueryString["isWater"].ToLower() == "true" ? true : false;
if (upfile == null)
{
jsonM.Msg = "请选择要上传文件！";
return(Json(jsonM));
}
jsonM = FileSaveAs(upfile, isThumbnail, isWater);
#region 移除原始文件
if (jsonM.Status == "y" && !string.IsNullOrEmpty(delpath))
{
if (System.IO.File.Exists(Utils.GetMapPath(delpath)))
{
System.IO.File.Delete(Utils.GetMapPath(delpath));
}
}
#endregion
if (jsonM.Status == "y")
{
#region 记录上传数据
string unit = string.Empty;
var jsonValue = JsonConverter.ConvertJson(jsonM.Data.ToString());
var entity = new Domain.COM_UPLOAD()
{
ID = Guid.NewGuid().ToString(),
FK_USERID = CurrentUser.Id.ToString(),
UPOPEATOR = CurrentUser.Name,
UPTIME = DateTime.Now,
UPOLDNAME = jsonValue.oldname,
UPNEWNAME = jsonValue.newname,
UPFILESIZE = FileHelper.GetDiyFileSize(long.Parse(jsonValue.size), out unit),
UPFILEUNIT = unit,
UPFILEPATH = jsonValue.path,
UPFILESUFFIX = jsonValue.ext,
UPFILETHUMBNAIL = jsonValue.thumbpath,
UPFILEIP = Utils.GetIP(),
UPFILEURL = "http://" + Request.Url.AbsoluteUri.Replace("http://", "").Substring(0, Request.Url.AbsoluteUri.Replace("http://", "").IndexOf('/'))
};
this.UploadManage.Save(entity);
#endregion
#region 返回文件信息
jsonM.Data = "{\"oldname\": \"" + jsonValue.oldname + "\","; //原始名称
jsonM.Data += " \"newname\":\"" + jsonValue.newname + "\","; //新名称
jsonM.Data += " \"path\": \"" + jsonValue.path + "\", "; //路径
jsonM.Data += " \"thumbpath\":\"" + jsonValue.thumbpath + "\","; //缩略图
jsonM.Data += " \"size\": \"" + jsonValue.size + "\","; //大小
jsonM.Data += " \"id\": \"" + entity.ID + "\","; //上传文件ID
jsonM.Data += " \"uptime\": \"" + entity.UPTIME + "\","; //上传时间
jsonM.Data += " \"operator\": \"" + entity.UPOPEATOR + "\","; //上传人
jsonM.Data += " \"unitsize\": \"" + entity.UPFILESIZE + unit + "\","; //带单位大小
jsonM.Data += "\"ext\":\"" + jsonValue.ext + "\"}"; //后缀名
#endregion
}
}
catch (Exception ex)
{
jsonM.Msg = "上传过程中发生错误，消息：" + ex.Message;
jsonM.Status = "n";
}
return(Json(jsonM));
}
/// <summary>
/// 将Queryable转换为Dynamic
/// </summary>
/// <typeparam name="T">实体类型</typeparam>
/// <param name="queryable">查询对象</param>
/// <returns>dynamic</returns>
public static dynamic ToDynamic <T>(this Queryable <T> queryable)
{
return(JsonConverter.ConvertJson(ToJson(queryable)));
}
