You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
488 lines
16 KiB
C#
488 lines
16 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Collections.Generic;
|
|
using MySql.Data.MySqlClient;
|
|
using CommonFunc;
|
|
using System.Text;
|
|
using XGL.Models;
|
|
namespace XGL.Data
|
|
{
|
|
public class filedatasDb : IDisposable
|
|
{
|
|
public void Dispose()
|
|
{
|
|
Dispose(true);
|
|
GC.SuppressFinalize(true);
|
|
}
|
|
protected virtual void Dispose(bool disposing)
|
|
{
|
|
if (!disposing)
|
|
return;
|
|
}
|
|
///<summary>
|
|
///判断是否存在记录
|
|
///</summary>
|
|
public bool Exists(int id)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select count(1) from role");
|
|
strSql.Append(" where ");
|
|
strSql.Append(" id = @id ");
|
|
MySqlParameter[] parameters = {
|
|
new MySqlParameter("@id", MySqlDbType.Int32)
|
|
};
|
|
parameters[0].Value = id;
|
|
return DbHelperSQLServer.Exists(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 增加一条数据
|
|
/// </summary>
|
|
public int Add(filedatasModel model)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("insert into filedatas(");
|
|
strSql.Append("typeNo,sysFileNa,preFileNa,fileSize,urlPath,absolutPath,isImage,imageWidth,imageHeight,usingNum,useEmpId,isPerson,mark,IsDeleted,CreateTime,CreateId,CreateBy,ModifyTime,ModifyId,ModifyBy)");
|
|
strSql.Append(" values (");
|
|
strSql.Append("@typeNo,@sysFileNa,@preFileNa,@fileSize,@urlPath,@absolutPath,@isImage,@imageWidth,@imageHeight,@usingNum,@useEmpId,@isPerson,@mark,@IsDeleted,@CreateTime,@CreateId,@CreateBy,@ModifyTime,@ModifyId,@ModifyBy)");
|
|
strSql.Append("; select @@IDENTITY");
|
|
MySqlParameter[] parameters = {
|
|
new MySqlParameter("@Id",model.Id),
|
|
new MySqlParameter("@typeNo",model.typeNo),
|
|
new MySqlParameter("@sysFileNa",model.sysFileNa),
|
|
new MySqlParameter("@preFileNa",model.preFileNa),
|
|
new MySqlParameter("@fileSize",model.fileSize),
|
|
new MySqlParameter("@urlPath",model.urlPath),
|
|
new MySqlParameter("@absolutPath",model.absolutPath),
|
|
new MySqlParameter("@isImage",model.isImage),
|
|
new MySqlParameter("@imageWidth",model.imageWidth),
|
|
new MySqlParameter("@imageHeight",model.imageHeight),
|
|
new MySqlParameter("@usingNum",model.usingNum),
|
|
new MySqlParameter("@useEmpId",model.useEmpId),
|
|
new MySqlParameter("@isPerson",model.isPerson),
|
|
new MySqlParameter("@mark",model.mark),
|
|
new MySqlParameter("@IsDeleted",model.IsDeleted),
|
|
new MySqlParameter("@CreateTime",model.CreateTime),
|
|
new MySqlParameter("@CreateId",model.CreateId),
|
|
new MySqlParameter("@CreateBy",model.CreateBy),
|
|
new MySqlParameter("@ModifyTime",model.ModifyTime),
|
|
new MySqlParameter("@ModifyId",model.ModifyId),
|
|
new MySqlParameter("@ModifyBy",model.ModifyBy),
|
|
};
|
|
object obj = DbHelperSQLServer.ExecuteScalar(strSql.ToString(), parameters);
|
|
if (obj == null)
|
|
{
|
|
return 0;
|
|
}
|
|
else
|
|
{
|
|
return Convert.ToInt32(obj);
|
|
}
|
|
}
|
|
/// </summary>
|
|
/// 修改一条数据
|
|
/// </summary>
|
|
bool Update(filedatasModel model)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update filedatas set");
|
|
strSql.Append( " typeNo = @typeNo , ");
|
|
strSql.Append( " sysFileNa = @sysFileNa , ");
|
|
strSql.Append( " preFileNa = @preFileNa , ");
|
|
strSql.Append( " fileSize = @fileSize , ");
|
|
strSql.Append( " urlPath = @urlPath , ");
|
|
strSql.Append( " absolutPath = @absolutPath , ");
|
|
strSql.Append( " isImage = @isImage , ");
|
|
strSql.Append( " imageWidth = @imageWidth , ");
|
|
strSql.Append( " imageHeight = @imageHeight , ");
|
|
strSql.Append( " usingNum = @usingNum , ");
|
|
strSql.Append( " useEmpId = @useEmpId , ");
|
|
strSql.Append( " isPerson = @isPerson , ");
|
|
strSql.Append( " mark = @mark , ");
|
|
strSql.Append( " IsDeleted = @IsDeleted , ");
|
|
strSql.Append( " CreateTime = @CreateTime , ");
|
|
strSql.Append( " CreateId = @CreateId , ");
|
|
strSql.Append( " CreateBy = @CreateBy , ");
|
|
strSql.Append( " ModifyTime = @ModifyTime , ");
|
|
strSql.Append( " ModifyId = @ModifyId , ");
|
|
strSql.Append(" ModifyBy = @ModifyBy");
|
|
strSql.Append( " where Id = @Id");
|
|
MySqlParameter[] parameters = {
|
|
new MySqlParameter("@Id", model.Id),
|
|
new MySqlParameter("@typeNo", model.typeNo),
|
|
new MySqlParameter("@sysFileNa", model.sysFileNa),
|
|
new MySqlParameter("@preFileNa", model.preFileNa),
|
|
new MySqlParameter("@fileSize", model.fileSize),
|
|
new MySqlParameter("@urlPath", model.urlPath),
|
|
new MySqlParameter("@absolutPath", model.absolutPath),
|
|
new MySqlParameter("@isImage", model.isImage),
|
|
new MySqlParameter("@imageWidth", model.imageWidth),
|
|
new MySqlParameter("@imageHeight", model.imageHeight),
|
|
new MySqlParameter("@usingNum", model.usingNum),
|
|
new MySqlParameter("@useEmpId", model.useEmpId),
|
|
new MySqlParameter("@isPerson", model.isPerson),
|
|
new MySqlParameter("@mark", model.mark),
|
|
new MySqlParameter("@IsDeleted", model.IsDeleted),
|
|
new MySqlParameter("@CreateTime", model.CreateTime),
|
|
new MySqlParameter("@CreateId", model.CreateId),
|
|
new MySqlParameter("@CreateBy", model.CreateBy),
|
|
new MySqlParameter("@ModifyTime", model.ModifyTime),
|
|
new MySqlParameter("@ModifyId", model.ModifyId),
|
|
new MySqlParameter("@ModifyBy", model.ModifyBy),
|
|
};
|
|
int rows = DbHelperSQLServer.ExecuteNonQuery(strSql.ToString(), parameters);
|
|
if (rows > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 删除一条数据
|
|
/// </summary>
|
|
public bool Delete(int id)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("delete from role ");
|
|
strSql.Append(" where id=@id");
|
|
MySqlParameter[] parameters = {
|
|
new MySqlParameter("@id", MySqlDbType.Int32)
|
|
};
|
|
parameters[0].Value = id;
|
|
int rows = DbHelperSQLServer.ExecuteNonQuery(strSql.ToString(), parameters);
|
|
if (rows > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 得到一个对象实体
|
|
/// </summary>
|
|
public filedatasModel GetModel(int id)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select");
|
|
strSql.Append(" Id, typeNo, sysFileNa, preFileNa, fileSize, urlPath, absolutPath, isImage, imageWidth, imageHeight, usingNum, useEmpId, isPerson, mark, IsDeleted, DATE_FORMAT(CreateTime,'%Y-%m-%d %H:%i:%s') CreateTime, CreateId, CreateBy, DATE_FORMAT(ModifyTime,'%Y-%m-%d %H:%i:%s') ModifyTime, ModifyId, ModifyBy");
|
|
strSql.Append(" from filedatas");
|
|
strSql.Append(" where id=@id");
|
|
MySqlParameter[] parameters = {
|
|
new MySqlParameter("@id", MySqlDbType.Int32)
|
|
};
|
|
parameters[0].Value = id;
|
|
filedatasModel model= new filedatasModel();
|
|
DataSet ds = DbHelperSQLServer.Query(strSql.ToString(), parameters);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
if(ds.Tables[0].Rows[0]["Id"] !=DBNull.Value)
|
|
{
|
|
model.Id =Convert.ToInt32(ds.Tables[0].Rows[0]["Id"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["typeNo"] !=DBNull.Value)
|
|
{
|
|
model.typeNo =Convert.ToString(ds.Tables[0].Rows[0]["typeNo"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["sysFileNa"] !=DBNull.Value)
|
|
{
|
|
model.sysFileNa =Convert.ToString(ds.Tables[0].Rows[0]["sysFileNa"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["preFileNa"] !=DBNull.Value)
|
|
{
|
|
model.preFileNa =Convert.ToString(ds.Tables[0].Rows[0]["preFileNa"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["fileSize"] !=DBNull.Value)
|
|
{
|
|
model.fileSize =Convert.ToInt32(ds.Tables[0].Rows[0]["fileSize"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["urlPath"] !=DBNull.Value)
|
|
{
|
|
model.urlPath =Convert.ToString(ds.Tables[0].Rows[0]["urlPath"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["absolutPath"] !=DBNull.Value)
|
|
{
|
|
model.absolutPath =Convert.ToString(ds.Tables[0].Rows[0]["absolutPath"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["isImage"] !=DBNull.Value)
|
|
{
|
|
model.isImage = ds.Tables[0].Rows[0]["isImage"].ToString() == "False" ? false : true;
|
|
}
|
|
if(ds.Tables[0].Rows[0]["imageWidth"] !=DBNull.Value)
|
|
{
|
|
model.imageWidth =Convert.ToInt32(ds.Tables[0].Rows[0]["imageWidth"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["imageHeight"] !=DBNull.Value)
|
|
{
|
|
model.imageHeight =Convert.ToInt32(ds.Tables[0].Rows[0]["imageHeight"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["usingNum"] !=DBNull.Value)
|
|
{
|
|
model.usingNum =Convert.ToInt32(ds.Tables[0].Rows[0]["usingNum"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["useEmpId"] !=DBNull.Value)
|
|
{
|
|
model.useEmpId =Convert.ToInt32(ds.Tables[0].Rows[0]["useEmpId"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["isPerson"] !=DBNull.Value)
|
|
{
|
|
model.isPerson = ds.Tables[0].Rows[0]["isPerson"].ToString() == "False" ? false : true;
|
|
}
|
|
if(ds.Tables[0].Rows[0]["mark"] !=DBNull.Value)
|
|
{
|
|
model.mark =Convert.ToString(ds.Tables[0].Rows[0]["mark"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["IsDeleted"] !=DBNull.Value)
|
|
{
|
|
model.IsDeleted = ds.Tables[0].Rows[0]["IsDeleted"].ToString() == "False" ? false : true;
|
|
}
|
|
if(ds.Tables[0].Rows[0]["CreateTime"] !=DBNull.Value)
|
|
{
|
|
model.CreateTime =Convert.ToString(ds.Tables[0].Rows[0]["CreateTime"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["CreateId"] !=DBNull.Value)
|
|
{
|
|
model.CreateId =Convert.ToInt32(ds.Tables[0].Rows[0]["CreateId"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["CreateBy"] !=DBNull.Value)
|
|
{
|
|
model.CreateBy =Convert.ToString(ds.Tables[0].Rows[0]["CreateBy"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["ModifyTime"] !=DBNull.Value)
|
|
{
|
|
model.ModifyTime =Convert.ToString(ds.Tables[0].Rows[0]["ModifyTime"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["ModifyId"] !=DBNull.Value)
|
|
{
|
|
model.ModifyId =Convert.ToInt32(ds.Tables[0].Rows[0]["ModifyId"]);
|
|
}
|
|
if(ds.Tables[0].Rows[0]["ModifyBy"] !=DBNull.Value)
|
|
{
|
|
model.ModifyBy =Convert.ToString(ds.Tables[0].Rows[0]["ModifyBy"]);
|
|
}
|
|
return model;
|
|
}
|
|
else{
|
|
return null;
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 得到一个对象实体集合
|
|
/// </summary>
|
|
public List<filedatasModel> GetList(string strWhere)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select");
|
|
strSql.Append(" Id, typeNo, sysFileNa, preFileNa, fileSize, urlPath, absolutPath, isImage, imageWidth, imageHeight, usingNum, useEmpId, isPerson, mark, IsDeleted, DATE_FORMAT(CreateTime,'%Y-%m-%d %H:%i:%s') CreateTime, CreateId, CreateBy, DATE_FORMAT(ModifyTime,'%Y-%m-%d %H:%i:%s') ModifyTime, ModifyId, ModifyBy");
|
|
strSql.Append(" from filedatas");
|
|
if( !string.IsNullOrWhiteSpace(strWhere))
|
|
strSql.Append(" where " + strWhere);
|
|
List<filedatasModel> Items= new List<filedatasModel>();
|
|
DataSet ds = DbHelperSQLServer.Query(strSql.ToString());
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
foreach(DataRow row in ds.Tables[0].Rows)
|
|
{
|
|
filedatasModel model= new filedatasModel();
|
|
if(row["Id"] !=DBNull.Value)
|
|
{
|
|
model.Id =Convert.ToInt32(row["Id"]);
|
|
}
|
|
if(row["typeNo"] !=DBNull.Value)
|
|
{
|
|
model.typeNo =Convert.ToString(row["typeNo"]);
|
|
}
|
|
if(row["sysFileNa"] !=DBNull.Value)
|
|
{
|
|
model.sysFileNa =Convert.ToString(row["sysFileNa"]);
|
|
}
|
|
if(row["preFileNa"] !=DBNull.Value)
|
|
{
|
|
model.preFileNa =Convert.ToString(row["preFileNa"]);
|
|
}
|
|
if(row["fileSize"] !=DBNull.Value)
|
|
{
|
|
model.fileSize =Convert.ToInt32(row["fileSize"]);
|
|
}
|
|
if(row["urlPath"] !=DBNull.Value)
|
|
{
|
|
model.urlPath =Convert.ToString(row["urlPath"]);
|
|
}
|
|
if(row["absolutPath"] !=DBNull.Value)
|
|
{
|
|
model.absolutPath =Convert.ToString(row["absolutPath"]);
|
|
}
|
|
if(row["isImage"] !=DBNull.Value)
|
|
{
|
|
model.isImage = row["isImage"].ToString() == "False" ? false : true;
|
|
}
|
|
if(row["imageWidth"] !=DBNull.Value)
|
|
{
|
|
model.imageWidth =Convert.ToInt32(row["imageWidth"]);
|
|
}
|
|
if(row["imageHeight"] !=DBNull.Value)
|
|
{
|
|
model.imageHeight =Convert.ToInt32(row["imageHeight"]);
|
|
}
|
|
if(row["usingNum"] !=DBNull.Value)
|
|
{
|
|
model.usingNum =Convert.ToInt32(row["usingNum"]);
|
|
}
|
|
if(row["useEmpId"] !=DBNull.Value)
|
|
{
|
|
model.useEmpId =Convert.ToInt32(row["useEmpId"]);
|
|
}
|
|
if(row["isPerson"] !=DBNull.Value)
|
|
{
|
|
model.isPerson = row["isPerson"].ToString() == "False" ? false : true;
|
|
}
|
|
if(row["mark"] !=DBNull.Value)
|
|
{
|
|
model.mark =Convert.ToString(row["mark"]);
|
|
}
|
|
if(row["IsDeleted"] !=DBNull.Value)
|
|
{
|
|
model.IsDeleted = row["IsDeleted"].ToString() == "False" ? false : true;
|
|
}
|
|
if(row["CreateTime"] !=DBNull.Value)
|
|
{
|
|
model.CreateTime =Convert.ToString(row["CreateTime"]);
|
|
}
|
|
if(row["CreateId"] !=DBNull.Value)
|
|
{
|
|
model.CreateId =Convert.ToInt32(row["CreateId"]);
|
|
}
|
|
if(row["CreateBy"] !=DBNull.Value)
|
|
{
|
|
model.CreateBy =Convert.ToString(row["CreateBy"]);
|
|
}
|
|
if(row["ModifyTime"] !=DBNull.Value)
|
|
{
|
|
model.ModifyTime =Convert.ToString(row["ModifyTime"]);
|
|
}
|
|
if(row["ModifyId"] !=DBNull.Value)
|
|
{
|
|
model.ModifyId =Convert.ToInt32(row["ModifyId"]);
|
|
}
|
|
if(row["ModifyBy"] !=DBNull.Value)
|
|
{
|
|
model.ModifyBy =Convert.ToString(row["ModifyBy"]);
|
|
}
|
|
Items.Add(model);
|
|
}
|
|
}
|
|
return Items;
|
|
}
|
|
/// <summary>
|
|
/// 得到一个对象实体集合
|
|
/// </summary>
|
|
public List<filedatasModel> GetList(string strWhere,MySqlParameter[] parameters)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select");
|
|
strSql.Append(" Id, typeNo, sysFileNa, preFileNa, fileSize, urlPath, absolutPath, isImage, imageWidth, imageHeight, usingNum, useEmpId, isPerson, mark, IsDeleted, DATE_FORMAT(CreateTime,'%Y-%m-%d %H:%i:%s') CreateTime, CreateId, CreateBy, DATE_FORMAT(ModifyTime,'%Y-%m-%d %H:%i:%s') ModifyTime, ModifyId, ModifyBy");
|
|
strSql.Append(" from filedatas");
|
|
if( !string.IsNullOrWhiteSpace(strWhere))
|
|
strSql.Append(" where " + strWhere);
|
|
List<filedatasModel> Items= new List<filedatasModel>();
|
|
DataSet ds = DbHelperSQLServer.Query(strSql.ToString(), parameters);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
foreach(DataRow row in ds.Tables[0].Rows)
|
|
{
|
|
filedatasModel model= new filedatasModel();
|
|
if(row["Id"] !=DBNull.Value)
|
|
{
|
|
model.Id =Convert.ToInt32(row["Id"]);
|
|
}
|
|
if(row["typeNo"] !=DBNull.Value)
|
|
{
|
|
model.typeNo =Convert.ToString(row["typeNo"]);
|
|
}
|
|
if(row["sysFileNa"] !=DBNull.Value)
|
|
{
|
|
model.sysFileNa =Convert.ToString(row["sysFileNa"]);
|
|
}
|
|
if(row["preFileNa"] !=DBNull.Value)
|
|
{
|
|
model.preFileNa =Convert.ToString(row["preFileNa"]);
|
|
}
|
|
if(row["fileSize"] !=DBNull.Value)
|
|
{
|
|
model.fileSize =Convert.ToInt32(row["fileSize"]);
|
|
}
|
|
if(row["urlPath"] !=DBNull.Value)
|
|
{
|
|
model.urlPath =Convert.ToString(row["urlPath"]);
|
|
}
|
|
if(row["absolutPath"] !=DBNull.Value)
|
|
{
|
|
model.absolutPath =Convert.ToString(row["absolutPath"]);
|
|
}
|
|
if(row["isImage"] !=DBNull.Value)
|
|
{
|
|
model.isImage = row["isImage"].ToString() == "False" ? false : true;
|
|
}
|
|
if(row["imageWidth"] !=DBNull.Value)
|
|
{
|
|
model.imageWidth =Convert.ToInt32(row["imageWidth"]);
|
|
}
|
|
if(row["imageHeight"] !=DBNull.Value)
|
|
{
|
|
model.imageHeight =Convert.ToInt32(row["imageHeight"]);
|
|
}
|
|
if(row["usingNum"] !=DBNull.Value)
|
|
{
|
|
model.usingNum =Convert.ToInt32(row["usingNum"]);
|
|
}
|
|
if(row["useEmpId"] !=DBNull.Value)
|
|
{
|
|
model.useEmpId =Convert.ToInt32(row["useEmpId"]);
|
|
}
|
|
if(row["isPerson"] !=DBNull.Value)
|
|
{
|
|
model.isPerson = row["isPerson"].ToString() == "False" ? false : true;
|
|
}
|
|
if(row["mark"] !=DBNull.Value)
|
|
{
|
|
model.mark =Convert.ToString(row["mark"]);
|
|
}
|
|
if(row["IsDeleted"] !=DBNull.Value)
|
|
{
|
|
model.IsDeleted = row["IsDeleted"].ToString() == "False" ? false : true;
|
|
}
|
|
if(row["CreateTime"] !=DBNull.Value)
|
|
{
|
|
model.CreateTime =Convert.ToString(row["CreateTime"]);
|
|
}
|
|
if(row["CreateId"] !=DBNull.Value)
|
|
{
|
|
model.CreateId =Convert.ToInt32(row["CreateId"]);
|
|
}
|
|
if(row["CreateBy"] !=DBNull.Value)
|
|
{
|
|
model.CreateBy =Convert.ToString(row["CreateBy"]);
|
|
}
|
|
if(row["ModifyTime"] !=DBNull.Value)
|
|
{
|
|
model.ModifyTime =Convert.ToString(row["ModifyTime"]);
|
|
}
|
|
if(row["ModifyId"] !=DBNull.Value)
|
|
{
|
|
model.ModifyId =Convert.ToInt32(row["ModifyId"]);
|
|
}
|
|
if(row["ModifyBy"] !=DBNull.Value)
|
|
{
|
|
model.ModifyBy =Convert.ToString(row["ModifyBy"]);
|
|
}
|
|
Items.Add(model);
|
|
}
|
|
}
|
|
return Items;
|
|
}
|
|
}
|
|
}
|