public IList <BarcodeTemplateInfo> GetList()
{
StringBuilder sb = new StringBuilder(300);
sb.Append(@"select Id,UserId,Title,JContent,IsDefault,TypeName,LastUpdatedDate
from BarcodeTemplate
order by LastUpdatedDate desc " );
IList <BarcodeTemplateInfo> list = new List <BarcodeTemplateInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString()))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
BarcodeTemplateInfo model = new BarcodeTemplateInfo();
model.Id = reader.GetGuid(0);
model.UserId = reader.GetGuid(1);
model.Title = reader.GetString(2);
model.JContent = reader.GetString(3);
model.IsDefault = reader.GetBoolean(4);
model.TypeName = reader.GetString(5);
model.LastUpdatedDate = reader.GetDateTime(6);
list.Add(model);
}
}
}
return(list);
}
public int Update(BarcodeTemplateInfo model)
{
StringBuilder sb = new StringBuilder(500);
sb.Append(@"update BarcodeTemplate set UserId = @UserId,Title = @Title,JContent = @JContent,IsDefault = @IsDefault,TypeName = @TypeName,LastUpdatedDate = @LastUpdatedDate
where Id = @Id
" );
SqlParameter[] parms =
{
new SqlParameter("@Id", SqlDbType.UniqueIdentifier),
new SqlParameter("@UserId", SqlDbType.UniqueIdentifier),
new SqlParameter("@Title", SqlDbType.NVarChar, 256),
new SqlParameter("@JContent", SqlDbType.NVarChar),
new SqlParameter("@IsDefault", SqlDbType.Bit),
new SqlParameter("@TypeName", SqlDbType.NVarChar, 20),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.Id;
parms[1].Value = model.UserId;
parms[2].Value = model.Title;
parms[3].Value = model.JContent;
parms[4].Value = model.IsDefault;
parms[5].Value = model.TypeName;
parms[6].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), parms));
}
public int InsertByOutput(BarcodeTemplateInfo model)
{
StringBuilder sb = new StringBuilder(300);
sb.Append(@"insert into BarcodeTemplate (Id,UserId,Title,Html,Attr,IsDefault,TypeName,LastUpdatedDate)
values
(@Id,@UserId,@Title,@Html,@Attr,@IsDefault,@TypeName,@LastUpdatedDate)
" );
SqlParameter[] parms =
{
new SqlParameter("@Id", SqlDbType.UniqueIdentifier),
new SqlParameter("@UserId", SqlDbType.UniqueIdentifier),
new SqlParameter("@Title", SqlDbType.NVarChar, 256),
new SqlParameter("@Html", SqlDbType.NVarChar),
new SqlParameter("@Attr", SqlDbType.NVarChar),
new SqlParameter("@IsDefault", SqlDbType.Bit),
new SqlParameter("@TypeName", SqlDbType.NVarChar, 20),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.Id;
parms[1].Value = model.UserId;
parms[2].Value = model.Title;
parms[3].Value = model.Html;
parms[4].Value = model.Attr;
parms[5].Value = model.IsDefault;
parms[6].Value = model.TypeName;
parms[7].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), parms));
}
public BarcodeTemplateInfo GetModel(Guid id)
{
BarcodeTemplateInfo model = null;
StringBuilder sb = new StringBuilder(300);
sb.Append(@"select top 1 Id,UserId,Title,JContent,IsDefault,TypeName,LastUpdatedDate
from BarcodeTemplate
where Id = @Id " );
SqlParameter[] parms =
{
new SqlParameter("@Id", SqlDbType.UniqueIdentifier)
};
parms[0].Value = id;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), parms))
{
if (reader != null)
{
if (reader.Read())
{
model = new BarcodeTemplateInfo();
model.Id = reader.GetGuid(0);
model.UserId = reader.GetGuid(1);
model.Title = reader.GetString(2);
model.JContent = reader.GetString(3);
model.IsDefault = reader.GetBoolean(4);
model.TypeName = reader.GetString(5);
model.LastUpdatedDate = reader.GetDateTime(6);
}
}
}
return(model);
}
public IList <BarcodeTemplateInfo> GetList()
{
StringBuilder sb = new StringBuilder(300);
sb.Append(@"select Id,UserId,Title,Html,Attr,IsDefault,TypeName,LastUpdatedDate
from BarcodeTemplate
order by LastUpdatedDate desc " );
IList <BarcodeTemplateInfo> list = new List <BarcodeTemplateInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString()))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
BarcodeTemplateInfo model = new BarcodeTemplateInfo();
model.Id = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0);
model.UserId = reader.IsDBNull(1) ? Guid.Empty : reader.GetGuid(1);
model.Title = reader.IsDBNull(2) ? string.Empty : reader.GetString(2);
model.Html = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
model.Attr = reader.IsDBNull(4) ? string.Empty : reader.GetString(4);
model.IsDefault = reader.IsDBNull(5) ? false : reader.GetBoolean(5);
model.TypeName = reader.IsDBNull(6) ? string.Empty : reader.GetString(6);
model.LastUpdatedDate = reader.IsDBNull(7) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(7);
list.Add(model);
}
}
}
return(list);
}
public IList <BarcodeTemplateInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms)
{
StringBuilder sb = new StringBuilder(500);
sb.Append(@"select count(*) from BarcodeTemplate ");
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), cmdParms);
if (totalRecords == 0)
{
return(new List <BarcodeTemplateInfo>());
}
sb.Clear();
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
sb.Append(@"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber,
Id,UserId,Title,Html,Attr,IsDefault,TypeName,LastUpdatedDate
from BarcodeTemplate " );
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex);
IList <BarcodeTemplateInfo> list = new List <BarcodeTemplateInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
BarcodeTemplateInfo model = new BarcodeTemplateInfo();
model.Id = reader.IsDBNull(1) ? Guid.Empty : reader.GetGuid(1);
model.UserId = reader.IsDBNull(2) ? Guid.Empty : reader.GetGuid(2);
model.Title = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
model.Html = reader.IsDBNull(4) ? string.Empty : reader.GetString(4);
model.Attr = reader.IsDBNull(5) ? string.Empty : reader.GetString(5);
model.IsDefault = reader.IsDBNull(6) ? false : reader.GetBoolean(6);
model.TypeName = reader.IsDBNull(7) ? string.Empty : reader.GetString(7);
model.LastUpdatedDate = reader.IsDBNull(8) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(8);
list.Add(model);
}
}
}
return(list);
}
public IList <BarcodeTemplateInfo> GetList(int pageIndex, int pageSize, string sqlWhere, params SqlParameter[] cmdParms)
{
BarcodeTemplateInfo model = ConvertToModel.ToModel <BarcodeTemplateInfo>(cmdParms);
IEnumerable <BarcodeTemplateInfo> datas = _db.BarcodeTemplates.FindAll();
if (!string.IsNullOrEmpty(model.TypeName))
{
datas = datas.Where(m => m.TypeName.Equals(model.TypeName));
}
return(datas.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList());
}
public IList <BarcodeTemplateInfo> GetList(int pageIndex, int pageSize, string sqlWhere, params SqlParameter[] cmdParms)
{
StringBuilder sb = new StringBuilder(500);
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
sb.Append(@"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber,
Id,UserId,Title,JContent,IsDefault,TypeName,LastUpdatedDate
from BarcodeTemplate " );
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex);
IList <BarcodeTemplateInfo> list = new List <BarcodeTemplateInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
BarcodeTemplateInfo model = new BarcodeTemplateInfo();
model.Id = reader.GetGuid(1);
model.UserId = reader.GetGuid(2);
model.Title = reader.GetString(3);
model.JContent = reader.GetString(4);
model.IsDefault = reader.GetBoolean(5);
model.TypeName = reader.GetString(6);
model.LastUpdatedDate = reader.GetDateTime(7);
list.Add(model);
}
}
}
return(list);
}
public BarcodeTemplateInfo GetModelByDefault()
{
BarcodeTemplateInfo model = null;
var sb = new StringBuilder(300);
sb.Append(@"select top 1 Id,UserId,Title,Html,Attr,IsDefault,TypeName,LastUpdatedDate
from BarcodeTemplate
where IsDefault = @IsDefault " );
SqlParameter[] parms =
{
new SqlParameter("@IsDefault", SqlDbType.Bit)
};
parms[0].Value = true;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), parms))
{
if (reader != null)
{
if (reader.Read())
{
model = new BarcodeTemplateInfo();
model.Id = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0);
model.UserId = reader.IsDBNull(1) ? Guid.Empty : reader.GetGuid(1);
model.Title = reader.IsDBNull(2) ? string.Empty : reader.GetString(2);
model.Html = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
model.Attr = reader.IsDBNull(4) ? string.Empty : reader.GetString(4);
model.IsDefault = reader.IsDBNull(5) ? false : reader.GetBoolean(5);
model.TypeName = reader.IsDBNull(6) ? string.Empty : reader.GetString(6);
model.LastUpdatedDate = reader.IsDBNull(7) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(7);
}
}
}
return(model);
}
public IList <BarcodeTemplateInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms)
{
StringBuilder sb = new StringBuilder(500);
sb.Append(@"select Id,UserId,Title,JContent,IsDefault,TypeName,LastUpdatedDate
from BarcodeTemplate ");
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
sb.Append("order by LastUpdatedDate desc ");
IList <BarcodeTemplateInfo> list = new List <BarcodeTemplateInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
BarcodeTemplateInfo model = new BarcodeTemplateInfo();
model.Id = reader.GetGuid(0);
model.UserId = reader.GetGuid(1);
model.Title = reader.GetString(2);
model.JContent = reader.GetString(3);
model.IsDefault = reader.GetBoolean(4);
model.TypeName = reader.GetString(5);
model.LastUpdatedDate = reader.GetDateTime(6);
list.Add(model);
}
}
}
return(list);
}
public int SetDefault(Guid Id, bool isDefault, string typeName)
{
BarcodeTemplateInfo oldInfo = _db.BarcodeTemplates.FindById(Id);
if (oldInfo == null)
{
return(0);
}
oldInfo.IsDefault = isDefault;
oldInfo.LastUpdatedDate = DateTime.Now;
if (isDefault)
{
IEnumerable <BarcodeTemplateInfo> oldInfos = _db.BarcodeTemplates.Find(m => !m.Id.Equals(oldInfo.Id) && m.TypeName.Equals(typeName) && m.IsDefault);
foreach (BarcodeTemplateInfo item in oldInfos)
{
item.IsDefault = false;
_db.BarcodeTemplates.Update(item);
}
}
return(1);
}
public int Update(BarcodeTemplateInfo model)
{
return(dal.Update(model));
}
public int InsertByOutput(BarcodeTemplateInfo model)
{
return(dal.InsertByOutput(model));
}
public int InsertByOutput(BarcodeTemplateInfo model)
{
_db.BarcodeTemplates.Insert(model);
return(1);
}
public int Insert(BarcodeTemplateInfo model)
{
throw new NotImplementedException();
}
public int Update(BarcodeTemplateInfo model)
{
_db.BarcodeTemplates.Update(model);
return(1);
}