public ActionResult AjaxGetJsonData(int draw, int start, int length)
{
DataTableModels <TestModel> ._data = db.testTable.ToList();
string search = Request.QueryString["search[value]"];
int sortColumn = -1;
string sortDirection = "asc";
if (length == -1)
{
length = DataTableModels <TestModel> ._data.Count;
}
// note: we only sort one column at a time
if (Request.QueryString["order[0][column]"] != null)
{
sortColumn = int.Parse(Request.QueryString["order[0][column]"]);
}
if (Request.QueryString["order[0][dir]"] != null)
{
sortDirection = Request.QueryString["order[0][dir]"];
}
DataTableData <TestModel> dataTableData = new DataTableData <TestModel>();
dataTableData.draw = draw;
dataTableData.recordsTotal = DataTableModels <TestModel> ._data.Count;
int recordsFiltered = 0;
dataTableData.data = DataTableModels <TestModel> .FilterData(ref recordsFiltered, start, length, search, sortColumn, sortDirection);
dataTableData.recordsFiltered = recordsFiltered;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
public ActionResult CotizacionesTBL()
{
var Rangofechas = Request.Form[29];
string IDsProveedores = Request.Form[30];
DataTableModels dataTable = new DataTableModels
{
draw = 1
};
var reader = BaseController.ObtenerDatos("SP_MasCotizados '" + Rangofechas.ToString() + "','" + IDsProveedores.ToString() + "'");
List <CotizacionModels> listaProductos = new List <CotizacionModels>();
while (reader.Read())
{
CotizacionModels c = new CotizacionModels
{
Proveedor = reader["PROVEEDOR"].ToString(),
Producto = reader["NombreProducto"].ToString(),
ValorPesos = (int)(Int64)reader["VALOR_PESOS"],
Total = Convert.ToInt32(reader["TOTAL"]),
};
listaProductos.Add(c);
}
Conexion.Cerrar();
dataTable.data = listaProductos.ToArray();
dataTable.recordsTotal = listaProductos.Count;
dataTable.recordsFiltered = listaProductos.Count();
return(Json(dataTable, JsonRequestBehavior.AllowGet));
}
public object GetWorks(string typeValue, int num)
{
DataTable sysTable = SysParaBll.Instance.GetList($"Status='1' and RefType='noteType' and RefValue='{typeValue}'");
if (sysTable.Rows.Count > 0)
{
DataTable worksTable = WorksBll.Instance.GetList(num, $"Status='1' and WorksType='{sysTable.Rows[0]["id"]}'", "UpdateTime desc,WorksId desc");
//获得类型、封面
for (int i = 0; i < worksTable.Rows.Count; i++)
{
if (worksTable.Rows[i]["WorksType"].ToString() != "")
{
worksTable.Rows[i]["WorksType"] = SysParaBll.Instance.GetModel(Convert.ToInt32(worksTable.Rows[i]["WorksType"]))?.RefText;
}
if (worksTable.Rows[i]["type2"].ToString() != "")
{
worksTable.Rows[i]["type2"] = SysParaBll.Instance.GetModel(Convert.ToInt32(worksTable.Rows[i]["type2"]))?.RefText;
}
if (worksTable.Rows[i]["cover"].ToString() != "")
{
worksTable.Rows[i]["cover"] = SmallImgBll.Instance.GetModel(Convert.ToInt32(worksTable.Rows[i]["cover"])).ImgUrl;
}
}
DataTableModels dataTableModels = new DataTableModels
{
Dt = worksTable,
Status = StatusEnum.success
};
return(dataTableModels);
}
return(new Dictionary <string, string>()
{
{ "status", "204" }, { "message", "无内容" }
});
}
public object GetWorkByUserId(string uid, int num)
{
DataTable worksTable = WorksBll.Instance.GetList(num, $"Status>0 AND User_id='{uid}'", "ReleaseTime DESC,WorksId DESC");
//获得类型、封面
for (int i = 0; i < worksTable.Rows.Count; i++)
{
if (worksTable.Rows[i]["WorksType"].ToString() != "")
{
worksTable.Rows[i]["WorksType"] = SysParaBll.Instance.GetModel(Convert.ToInt32(worksTable.Rows[i]["WorksType"]))?.RefText;
}
if (worksTable.Rows[i]["type2"].ToString() != "")
{
worksTable.Rows[i]["type2"] = SysParaBll.Instance.GetModel(Convert.ToInt32(worksTable.Rows[i]["type2"]))?.RefText;
}
if (worksTable.Rows[i]["cover"].ToString() != "")
{
worksTable.Rows[i]["cover"] = SmallImgBll.Instance.GetModel(Convert.ToInt32(worksTable.Rows[i]["cover"])).ImgUrl;
}
}
DataTableModels dataTableModels = new DataTableModels
{
Dt = worksTable,
Status = StatusEnum.success
};
return(dataTableModels);
}
public ActionResult generarCotizacionTBL(int id = 0)
{
DataTableModels dataTable = new DataTableModels();
dataTable.draw = 1;
var reader = BaseController.ObtenerDatos("CalculoCotizacion " + id.ToString());
List <CotizacionModels> listaProductos = new List <CotizacionModels>();
while (reader.Read())
{
CotizacionModels c = new CotizacionModels
{
Proveedor = reader["PROVEEDOR"].ToString(),
Producto = reader["NombreProducto"].ToString(),
ValorPesos = (int)(Int64)reader["VALOR_PESOS"],
ValorCambio = Convert.ToDateTime(reader["FechaCambio"]).ToString("dd-MM-yyyy")
};
listaProductos.Add(c);
}
dataTable.data = listaProductos.ToArray();
dataTable.recordsTotal = listaProductos.Count;
dataTable.recordsFiltered = listaProductos.Count();
return(Json(dataTable, JsonRequestBehavior.AllowGet));
}
public object GetReplyByUserId(string userId, int num)
{
DataTable worksTable = ReplyBll.Instance.GetList(num, $"User_id='{userId}' AND Status>0 ", "ReleaseTime desc,ReplyId desc");
DataTableModels dataTableModels = new DataTableModels
{
Dt = worksTable,
Status = StatusEnum.success
};
return(dataTableModels);
}
