protected ActionLogModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new ActionLogModel();
if (DbTool.HasFields("ActionLogId", fields))
{
model.ActionLogId = DbTool.ConvertObject <System.Int32>(dr["ActionLogId"]);
}
if (DbTool.HasFields("ActionName", fields))
{
model.ActionName = DbTool.ConvertObject <System.String>(dr["ActionName"]);
}
if (DbTool.HasFields("UserName", fields))
{
model.UserName = DbTool.ConvertObject <System.String>(dr["UserName"]);
}
if (DbTool.HasFields("ActionResult", fields))
{
model.ActionResult = DbTool.ConvertObject <System.String>(dr["ActionResult"]);
}
if (DbTool.HasFields("KeyData", fields))
{
model.KeyData = DbTool.ConvertObject <System.String>(dr["KeyData"]);
}
if (DbTool.HasFields("Notes", fields))
{
model.Notes = DbTool.ConvertObject <System.String>(dr["Notes"]);
}
if (DbTool.HasFields("CreateOn", fields))
{
model.CreateOn = DbTool.ConvertObject <System.DateTime>(dr["CreateOn"]);
}
return(model);
}
public int Add(UpInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [UpInfo]");
strSql.Append("(Title,FileName,ApployTime,BathCode,Secret,CustomerEmail,Type,Url,Status,CreatedTime,UpdateTime,DownTime,CompleteTime,Remarks)");
strSql.Append(" values (@Title,@FileName,@ApployTime,@BathCode,@Secret,@CustomerEmail,@Type,@Url,@Status,@CreatedTime,@UpdateTime,@DownTime,@CompleteTime,@Remarks)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@Title", DbTool.FixSqlParameter(model.Title))
, new SqlParameter("@FileName", DbTool.FixSqlParameter(model.FileName))
, new SqlParameter("@ApployTime", DbTool.FixSqlParameter(model.ApployTime))
, new SqlParameter("@BathCode", DbTool.FixSqlParameter(model.BathCode))
, new SqlParameter("@Secret", DbTool.FixSqlParameter(model.Secret))
, new SqlParameter("@CustomerEmail", DbTool.FixSqlParameter(model.CustomerEmail))
, new SqlParameter("@Type", DbTool.FixSqlParameter(model.Type))
, new SqlParameter("@Url", DbTool.FixSqlParameter(model.Url))
, new SqlParameter("@Status", DbTool.FixSqlParameter(model.Status))
, new SqlParameter("@CreatedTime", DbTool.FixSqlParameter(model.CreatedTime))
, new SqlParameter("@UpdateTime", DbTool.FixSqlParameter(model.UpdateTime))
, new SqlParameter("@DownTime", DbTool.FixSqlParameter(model.DownTime))
, new SqlParameter("@CompleteTime", DbTool.FixSqlParameter(model.CompleteTime))
, new SqlParameter("@Remarks", DbTool.FixSqlParameter(model.Remarks))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
public int Add(YHFramework.SysModel.BoxNumberModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [BoxNumber]");
strSql.Append("(BoxNumber,ShortBoxNumber,IndexCode,BatchNumber,ContentStatusId,IsBind,BindTime,UpdateOn,CreateOn,ApployInfoId)");
strSql.Append(" values (@BoxNumber,@ShortBoxNumber,@IndexCode,@BatchNumber,@ContentStatusId,@IsBind,@BindTime,@UpdateOn,@CreateOn,@ApployInfoId)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@BoxNumber", DbTool.FixSqlParameter(model.BoxNumber))
, new SqlParameter("@ShortBoxNumber", DbTool.FixSqlParameter(model.ShortBoxNumber))
, new SqlParameter("@IndexCode", DbTool.FixSqlParameter(model.IndexCode))
, new SqlParameter("@BatchNumber", DbTool.FixSqlParameter(model.BatchNumber))
, new SqlParameter("@ContentStatusId", DbTool.FixSqlParameter(model.ContentStatusId))
, new SqlParameter("@IsBind", DbTool.FixSqlParameter(model.IsBind))
, new SqlParameter("@BindTime", DbTool.FixSqlParameter(model.BindTime))
, new SqlParameter("@UpdateOn", DbTool.FixSqlParameter(model.UpdateOn))
, new SqlParameter("@CreateOn", DbTool.FixSqlParameter(model.CreateOn))
, new SqlParameter("@ApployInfoId", DbTool.FixSqlParameter(model.ApployInfoId))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
/// <summary>
/// 获取记录数
/// </summary>
public int GetRowCount(string sqlwhere)
{
string sql = "select count(*) from ApployInfo where 1=1 " + sqlwhere;
var obj = SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, null);
return(DbTool.ConvertObject <int>(obj, 0));
}
/// <summary>
/// 获取记录数
/// </summary>
public int GetCodeRowCountByAppId(int appId)
{
string sql = "select COUNT(*) from dbo.CodeData where ContentStatusId=1 and ApployInfoId= " + appId;
var obj = SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, null);
return(DbTool.ConvertObject <int>(obj, 0));
}
/// <summary>
/// 获取记录数
/// </summary>
public int GetRowCount()
{
string sql = "select count(*) from UpInfo ";
var obj = SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, null);
return(DbTool.ConvertObject <int>(obj, 0));
}
public int CheckCount(string sqlwhere)
{
StringBuilder sql = new StringBuilder();
sql.Append("select count(1) from IpAccessControlLog where 1=1 ");
sql.Append(sqlwhere);
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql.ToString()), 0));
}
protected void BindDataReader(Model.Security.IpAccessControlSettingModel model, SqlDataReader dr)
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
model.LogType = DbTool.ConvertObject <System.String>(dr["LogType"]);
model.IPAccessEnable = DbTool.ConvertObject <System.Boolean>(dr["IPAccessEnable"]);
model.IPAccessMaxCount = DbTool.ConvertObject <System.Int32>(dr["IPAccessMaxCount"]);
model.IPAccessControlTime = DbTool.ConvertObject <System.Int32>(dr["IPAccessControlTime"]);
model.IPAccessControlLockTime = DbTool.ConvertObject <System.Int32>(dr["IPAccessControlLockTime"]);
}
protected void BindDataReader(Model.Security.IpAccessControlModel model, SqlDataReader dr)
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
model.LogType = DbTool.ConvertObject <System.String>(dr["LogType"]);
model.IpAddress = DbTool.ConvertObject <System.String>(dr["IpAddress"]);
model.AccessCount = DbTool.ConvertObject <System.Int32>(dr["AccessCount"]);
model.Islocked = DbTool.ConvertObject <System.Boolean>(dr["Islocked"]);
model.FistDateTime = DbTool.ConvertObject <System.DateTime>(dr["FistDateTime"]);
model.UpdateDate = DbTool.ConvertObject <System.DateTime>(dr["UpdateDate"]);
}
protected void BindDataReader(ActionLogModel model, SqlDataReader dr)
{
model.ActionLogId = DbTool.ConvertObject <System.Int32>(dr["ActionLogId"]);
model.ActionName = DbTool.ConvertObject <System.String>(dr["ActionName"]);
model.UserName = DbTool.ConvertObject <System.String>(dr["UserName"]);
model.ActionResult = DbTool.ConvertObject <System.String>(dr["ActionResult"]);
model.KeyData = DbTool.ConvertObject <System.String>(dr["KeyData"]);
model.Notes = DbTool.ConvertObject <System.String>(dr["Notes"]);
model.CreateOn = DbTool.ConvertObject <System.DateTime>(dr["CreateOn"]);
}
protected void BindDataReader(YHFramework.SysModel.ApployCheckLogModel model, SqlDataReader dr)
{
model.CheckLogId = DbTool.ConvertObject <System.Int32>(dr["CheckLogId"]);
model.ApployId = DbTool.ConvertObject <System.Int32>(dr["ApployId"]);
model.TypeCode = DbTool.ConvertObject <System.String>(dr["TypeCode"]);
model.FileName = DbTool.ConvertObject <System.String>(dr["FileName"]);
model.Number = DbTool.ConvertObject <System.Int64>(dr["Number"]);
model.Message = DbTool.ConvertObject <System.String>(dr["Message"]);
model.CreateOn = DbTool.ConvertObject <System.DateTime>(dr["CreateOn"]);
model.UpdateOn = DbTool.ConvertObject <System.DateTime>(dr["UpdateOn"]);
}
protected void BindDataReader(Model.Security.IpAccessControlLogModel model, SqlDataReader dr)
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
model.IpAddress = DbTool.ConvertObject <System.String>(dr["IpAddress"]);
model.LogType = DbTool.ConvertObject <System.String>(dr["LogType"]);
model.LockedDate = DbTool.ConvertObject <System.DateTime>(dr["LockedDate"]);
model.CreateOn = DbTool.ConvertObject <System.DateTime>(dr["CreateOn"]);
model.LockValue = DbTool.ConvertObject <System.String>(dr["LockValue"]);
model.LockReason = DbTool.ConvertObject <System.String>(dr["LockReason"]);
model.SourceURL = DbTool.ConvertObject <System.String>(dr["SourceURL"]);
}
protected void BindDataReader(YHFramework.SysModel.ExecutePlanModel model, SqlDataReader dr)
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
model.CodeType = DbTool.ConvertObject <System.Int32>(dr["CodeType"]);
model.MaxCount = DbTool.ConvertObject <System.Int32>(dr["MaxCount"]);
model.EachCount = DbTool.ConvertObject <System.Int32>(dr["EachCount"]);
model.BatchCodeBegin = DbTool.ConvertObject <System.Int32>(dr["BatchCodeBegin"]);
model.EffectiveDateBegin = DbTool.ConvertObject <System.DateTime>(dr["EffectiveDateBegin"]);
model.GeneratedCount = DbTool.ConvertObject <System.Int32>(dr["GeneratedCount"]);
model.CurrentBatchCode = DbTool.ConvertObject <System.Int32>(dr["CurrentBatchCode"]);
model.Status = DbTool.ConvertObject <System.Int32>(dr["Status"]);
model.CustomerEmail = DbTool.ConvertObject <System.String>(dr["CustomerEmail"]);
}
protected void BindDataReader(YHFramework.SysModel.CodeDataModel model, SqlDataReader dr)
{
model.CodeDataId = DbTool.ConvertObject <System.Int32>(dr["CodeDataId"]);
model.CodeData = DbTool.ConvertObject <System.String>(dr["CodeData"]);
model.ShortCodeData = DbTool.ConvertObject <System.String>(dr["ShortCodeData"]);
model.CodeIndex = DbTool.ConvertObject <System.String>(dr["CodeIndex"]);
model.BatchNumber = DbTool.ConvertObject <System.String>(dr["BatchNumber"]);
model.BoxNumberId = DbTool.ConvertObject <System.Int32>(dr["BoxNumberId"]);
model.ContentStatusId = DbTool.ConvertObject <System.Int32>(dr["ContentStatusId"]);
model.UpdateOn = DbTool.ConvertObject <System.DateTime>(dr["UpdateOn"]);
model.Createon = DbTool.ConvertObject <System.DateTime>(dr["Createon"]);
model.ApployInfoId = DbTool.ConvertObject <System.Int32>(dr["ApployInfoId"]);
}
protected YHFramework.SysModel.BoxNumberModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new YHFramework.SysModel.BoxNumberModel();
if (DbTool.HasFields("BoxNumberId", fields))
{
model.BoxNumberId = DbTool.ConvertObject <System.Int32>(dr["BoxNumberId"]);
}
if (DbTool.HasFields("BoxNumber", fields))
{
model.BoxNumber = DbTool.ConvertObject <System.String>(dr["BoxNumber"]);
}
if (DbTool.HasFields("ShortBoxNumber", fields))
{
model.ShortBoxNumber = DbTool.ConvertObject <System.String>(dr["ShortBoxNumber"]);
}
if (DbTool.HasFields("IndexCode", fields))
{
model.IndexCode = DbTool.ConvertObject <System.String>(dr["IndexCode"]);
}
if (DbTool.HasFields("BatchNumber", fields))
{
model.BatchNumber = DbTool.ConvertObject <System.String>(dr["BatchNumber"]);
}
if (DbTool.HasFields("ContentStatusId", fields))
{
model.ContentStatusId = DbTool.ConvertObject <System.String>(dr["ContentStatusId"]);
}
if (DbTool.HasFields("IsBind", fields))
{
model.IsBind = DbTool.ConvertObject <System.Boolean>(dr["IsBind"]);
}
if (DbTool.HasFields("BindTime", fields))
{
model.BindTime = DbTool.ConvertObject <System.DateTime>(dr["BindTime"]);
}
if (DbTool.HasFields("UpdateOn", fields))
{
model.UpdateOn = DbTool.ConvertObject <System.DateTime>(dr["UpdateOn"]);
}
if (DbTool.HasFields("CreateOn", fields))
{
model.CreateOn = DbTool.ConvertObject <System.DateTime>(dr["CreateOn"]);
}
if (DbTool.HasFields("ApployInfoId", fields))
{
model.ApployInfoId = DbTool.ConvertObject <System.Int32>(dr["ApployInfoId"]);
}
return(model);
}
protected void BindDataReader(YHFramework.SysModel.BoxNumberModel model, SqlDataReader dr)
{
model.BoxNumberId = DbTool.ConvertObject <System.Int32>(dr["BoxNumberId"]);
model.BoxNumber = DbTool.ConvertObject <System.String>(dr["BoxNumber"]);
model.ShortBoxNumber = DbTool.ConvertObject <System.String>(dr["ShortBoxNumber"]);
model.IndexCode = DbTool.ConvertObject <System.String>(dr["IndexCode"]);
model.BatchNumber = DbTool.ConvertObject <System.String>(dr["BatchNumber"]);
model.ContentStatusId = DbTool.ConvertObject <System.String>(dr["ContentStatusId"]);
model.IsBind = DbTool.ConvertObject <System.Boolean>(dr["IsBind"]);
model.BindTime = DbTool.ConvertObject <System.DateTime>(dr["BindTime"]);
model.UpdateOn = DbTool.ConvertObject <System.DateTime>(dr["UpdateOn"]);
model.CreateOn = DbTool.ConvertObject <System.DateTime>(dr["CreateOn"]);
model.ApployInfoId = DbTool.ConvertObject <System.Int32>(dr["ApployInfoId"]);
}
/// <summary>
/// 获取记录数
/// </summary>
public int GetRowCountByCodelist(List <string> codelist)
{
List <YHFramework.SysModel.CodeDataModel> result = new List <YHFramework.SysModel.CodeDataModel>();
string sql = "select count(*) from CodeData where isnull(BoxNumberId,0)=0 and CodeData in ({0})";
StringBuilder codebuilder = new StringBuilder();
foreach (var item in codelist)
{
codebuilder.Append("'" + item.FixSql() + "',");
}
sql = string.Format(sql, codebuilder.ToString().TrimEnd(','));
var obj = SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, null);
return(DbTool.ConvertObject <int>(obj, 0));
}
protected YHFramework.SysModel.ExecutePlanModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new YHFramework.SysModel.ExecutePlanModel();
if (DbTool.HasFields("Id", fields))
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
}
if (DbTool.HasFields("CodeType", fields))
{
model.CodeType = DbTool.ConvertObject <System.Int32>(dr["CodeType"]);
}
if (DbTool.HasFields("MaxCount", fields))
{
model.MaxCount = DbTool.ConvertObject <System.Int32>(dr["MaxCount"]);
}
if (DbTool.HasFields("EachCount", fields))
{
model.EachCount = DbTool.ConvertObject <System.Int32>(dr["EachCount"]);
}
if (DbTool.HasFields("BatchCodeBegin", fields))
{
model.BatchCodeBegin = DbTool.ConvertObject <System.Int32>(dr["BatchCodeBegin"]);
}
if (DbTool.HasFields("EffectiveDateBegin", fields))
{
model.EffectiveDateBegin = DbTool.ConvertObject <System.DateTime>(dr["EffectiveDateBegin"]);
}
if (DbTool.HasFields("GeneratedCount", fields))
{
model.GeneratedCount = DbTool.ConvertObject <System.Int32>(dr["GeneratedCount"]);
}
if (DbTool.HasFields("CurrentBatchCode", fields))
{
model.CurrentBatchCode = DbTool.ConvertObject <System.Int32>(dr["CurrentBatchCode"]);
}
if (DbTool.HasFields("Status", fields))
{
model.Status = DbTool.ConvertObject <System.Int32>(dr["Status"]);
}
if (DbTool.HasFields("CustomerEmail", fields))
{
model.CustomerEmail = DbTool.ConvertObject <System.String>(dr["CustomerEmail"]);
}
return(model);
}
protected void BindDataReader(UpInfoModel model, SqlDataReader dr)
{
model.ID = DbTool.ConvertObject <System.Int32>(dr["ID"]);
model.Title = DbTool.ConvertObject <System.String>(dr["Title"]);
model.FileName = DbTool.ConvertObject <System.String>(dr["FileName"]);
model.ApployTime = DbTool.ConvertObject <System.DateTime>(dr["ApployTime"]);
model.BathCode = DbTool.ConvertObject <System.String>(dr["BathCode"]);
model.Secret = DbTool.ConvertObject <System.String>(dr["Secret"]);
model.CustomerEmail = DbTool.ConvertObject <System.String>(dr["CustomerEmail"]);
model.Type = DbTool.ConvertObject <System.Int32>(dr["Type"]);
model.Url = DbTool.ConvertObject <System.String>(dr["Url"]);
model.Status = DbTool.ConvertObject <System.Int32>(dr["Status"]);
model.CreatedTime = DbTool.ConvertObject <System.DateTime>(dr["CreatedTime"]);
model.UpdateTime = DbTool.ConvertObject <System.DateTime>(dr["UpdateTime"]);
model.DownTime = DbTool.ConvertObject <System.DateTime>(dr["DownTime"]);
model.CompleteTime = DbTool.ConvertObject <System.DateTime>(dr["CompleteTime"]);
model.Remarks = DbTool.ConvertObject <System.String>(dr["Remarks"]);
}
public int Add(Model.Security.IpAccessControlSettingModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [IpAccessControlSetting]");
strSql.Append("(LogType,IPAccessEnable,IPAccessMaxCount,IPAccessControlTime,IPAccessControlLockTime)");
strSql.Append(" values (@LogType,@IPAccessEnable,@IPAccessMaxCount,@IPAccessControlTime,@IPAccessControlLockTime)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@LogType", DbTool.FixSqlParameter(model.LogType))
, new SqlParameter("@IPAccessEnable", DbTool.FixSqlParameter(model.IPAccessEnable))
, new SqlParameter("@IPAccessMaxCount", DbTool.FixSqlParameter(model.IPAccessMaxCount))
, new SqlParameter("@IPAccessControlTime", DbTool.FixSqlParameter(model.IPAccessControlTime))
, new SqlParameter("@IPAccessControlLockTime", DbTool.FixSqlParameter(model.IPAccessControlLockTime))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
public int Add(ActionLogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [ActionLog]");
strSql.Append("(ActionName,UserName,ActionResult,KeyData,Notes,CreateOn)");
strSql.Append(" values (@ActionName,@UserName,@ActionResult,@KeyData,@Notes,@CreateOn)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@ActionName", DbTool.FixSqlParameter(model.ActionName))
, new SqlParameter("@UserName", DbTool.FixSqlParameter(model.UserName))
, new SqlParameter("@ActionResult", DbTool.FixSqlParameter(model.ActionResult))
, new SqlParameter("@KeyData", DbTool.FixSqlParameter(model.KeyData))
, new SqlParameter("@Notes", DbTool.FixSqlParameter(model.Notes))
, new SqlParameter("@CreateOn", DbTool.FixSqlParameter(model.CreateOn))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
public int Add(Model.Security.IpAccessControlModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [IpAccessControl]");
strSql.Append("(LogType,IpAddress,AccessCount,Islocked,FistDateTime,UpdateDate)");
strSql.Append(" values (@LogType,@IpAddress,@AccessCount,@Islocked,@FistDateTime,@UpdateDate)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@LogType", DbTool.FixSqlParameter(model.LogType))
, new SqlParameter("@IpAddress", DbTool.FixSqlParameter(model.IpAddress))
, new SqlParameter("@AccessCount", DbTool.FixSqlParameter(model.AccessCount))
, new SqlParameter("@Islocked", DbTool.FixSqlParameter(model.Islocked))
, new SqlParameter("@FistDateTime", DbTool.FixSqlParameter(model.FistDateTime))
, new SqlParameter("@UpdateDate", DbTool.FixSqlParameter(model.UpdateDate))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
public int Add(Model.Security.IpAccessControlLogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [IpAccessControlLog]");
strSql.Append("(IpAddress,LogType,LockedDate,CreateOn,LockValue,LockReason,SourceURL)");
strSql.Append(" values (@IpAddress,@LogType,@LockedDate,@CreateOn,@LockValue,@LockReason,@SourceURL)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@IpAddress", DbTool.FixSqlParameter(model.IpAddress))
, new SqlParameter("@LogType", DbTool.FixSqlParameter(model.LogType))
, new SqlParameter("@LockedDate", DbTool.FixSqlParameter(model.LockedDate))
, new SqlParameter("@CreateOn", DbTool.FixSqlParameter(model.CreateOn))
, new SqlParameter("@LockValue", DbTool.FixSqlParameter(model.LockValue))
, new SqlParameter("@LockReason", DbTool.FixSqlParameter(model.LockReason))
, new SqlParameter("@SourceURL", DbTool.FixSqlParameter(model.SourceURL))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
protected Model.Security.IpAccessControlLogModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new Model.Security.IpAccessControlLogModel();
if (DbTool.HasFields("Id", fields))
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
}
if (DbTool.HasFields("IpAddress", fields))
{
model.IpAddress = DbTool.ConvertObject <System.String>(dr["IpAddress"]);
}
if (DbTool.HasFields("LogType", fields))
{
model.LogType = DbTool.ConvertObject <System.String>(dr["LogType"]);
}
if (DbTool.HasFields("LockedDate", fields))
{
model.LockedDate = DbTool.ConvertObject <System.DateTime>(dr["LockedDate"]);
}
if (DbTool.HasFields("CreateOn", fields))
{
model.CreateOn = DbTool.ConvertObject <System.DateTime>(dr["CreateOn"]);
}
if (DbTool.HasFields("LockValue", fields))
{
model.LockValue = DbTool.ConvertObject <System.String>(dr["LockValue"]);
}
if (DbTool.HasFields("LockReason", fields))
{
model.LockReason = DbTool.ConvertObject <System.String>(dr["LockReason"]);
}
if (DbTool.HasFields("SourceURL", fields))
{
model.SourceURL = DbTool.ConvertObject <System.String>(dr["SourceURL"]);
}
return(model);
}
protected YHFramework.SysModel.ApployCheckLogModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new YHFramework.SysModel.ApployCheckLogModel();
if (DbTool.HasFields("CheckLogId", fields))
{
model.CheckLogId = DbTool.ConvertObject <System.Int32>(dr["CheckLogId"]);
}
if (DbTool.HasFields("ApployId", fields))
{
model.ApployId = DbTool.ConvertObject <System.Int32>(dr["ApployId"]);
}
if (DbTool.HasFields("TypeCode", fields))
{
model.TypeCode = DbTool.ConvertObject <System.String>(dr["TypeCode"]);
}
if (DbTool.HasFields("FileName", fields))
{
model.FileName = DbTool.ConvertObject <System.String>(dr["FileName"]);
}
if (DbTool.HasFields("Number", fields))
{
model.Number = DbTool.ConvertObject <System.Int64>(dr["Number"]);
}
if (DbTool.HasFields("Message", fields))
{
model.Message = DbTool.ConvertObject <System.String>(dr["Message"]);
}
if (DbTool.HasFields("CreateOn", fields))
{
model.CreateOn = DbTool.ConvertObject <System.DateTime>(dr["CreateOn"]);
}
if (DbTool.HasFields("UpdateOn", fields))
{
model.UpdateOn = DbTool.ConvertObject <System.DateTime>(dr["UpdateOn"]);
}
return(model);
}
public int Add(YHFramework.SysModel.ApployCheckLogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [ApployCheckLog]");
strSql.Append("(ApployId,TypeCode,FileName,Number,Message,CreateOn,UpdateOn)");
strSql.Append(" values (@ApployId,@TypeCode,@FileName,@Number,@Message,@CreateOn,@UpdateOn)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@ApployId", DbTool.FixSqlParameter(model.ApployId))
, new SqlParameter("@TypeCode", DbTool.FixSqlParameter(model.TypeCode))
, new SqlParameter("@FileName", DbTool.FixSqlParameter(model.FileName))
, new SqlParameter("@Number", DbTool.FixSqlParameter(model.Number))
, new SqlParameter("@Message", DbTool.FixSqlParameter(model.Message))
, new SqlParameter("@CreateOn", DbTool.FixSqlParameter(model.CreateOn))
, new SqlParameter("@UpdateOn", DbTool.FixSqlParameter(model.UpdateOn))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
public int Add(YHFramework.SysModel.ExecutePlanModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [ExecutePlan]");
strSql.Append("(CodeType,MaxCount,EachCount,BatchCodeBegin,EffectiveDateBegin,GeneratedCount,CurrentBatchCode,Status,CustomerEmail)");
strSql.Append(" values (@CodeType,@MaxCount,@EachCount,@BatchCodeBegin,@EffectiveDateBegin,@GeneratedCount,@CurrentBatchCode,@Status,@CustomerEmail)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@CodeType", DbTool.FixSqlParameter(model.CodeType))
, new SqlParameter("@MaxCount", DbTool.FixSqlParameter(model.MaxCount))
, new SqlParameter("@EachCount", DbTool.FixSqlParameter(model.EachCount))
, new SqlParameter("@BatchCodeBegin", DbTool.FixSqlParameter(model.BatchCodeBegin))
, new SqlParameter("@EffectiveDateBegin", DbTool.FixSqlParameter(model.EffectiveDateBegin))
, new SqlParameter("@GeneratedCount", DbTool.FixSqlParameter(model.GeneratedCount))
, new SqlParameter("@CurrentBatchCode", DbTool.FixSqlParameter(model.CurrentBatchCode))
, new SqlParameter("@Status", DbTool.FixSqlParameter(model.Status))
, new SqlParameter("@CustomerEmail", DbTool.FixSqlParameter(model.CustomerEmail))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
public int Add(YHFramework.SysModel.CodeDataModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [CodeData]");
strSql.Append("(CodeData,ShortCodeData,CodeIndex,BatchNumber,BoxNumberId,ContentStatusId,UpdateOn,Createon,ApployInfoId)");
strSql.Append(" values (@CodeData,@ShortCodeData,@CodeIndex,@BatchNumber,@BoxNumberId,@ContentStatusId,@UpdateOn,@Createon,@ApployInfoId)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@CodeData", DbTool.FixSqlParameter(model.CodeData))
, new SqlParameter("@ShortCodeData", DbTool.FixSqlParameter(model.ShortCodeData))
, new SqlParameter("@CodeIndex", DbTool.FixSqlParameter(model.CodeIndex))
, new SqlParameter("@BatchNumber", DbTool.FixSqlParameter(model.BatchNumber))
, new SqlParameter("@BoxNumberId", DbTool.FixSqlParameter(model.BoxNumberId))
, new SqlParameter("@ContentStatusId", DbTool.FixSqlParameter(model.ContentStatusId))
, new SqlParameter("@UpdateOn", DbTool.FixSqlParameter(model.UpdateOn))
, new SqlParameter("@Createon", DbTool.FixSqlParameter(model.Createon))
, new SqlParameter("@ApployInfoId", DbTool.FixSqlParameter(model.ApployInfoId))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
protected UpInfoModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new UpInfoModel();
if (DbTool.HasFields("ID", fields))
{
model.ID = DbTool.ConvertObject <System.Int32>(dr["ID"]);
}
if (DbTool.HasFields("Title", fields))
{
model.Title = DbTool.ConvertObject <System.String>(dr["Title"]);
}
if (DbTool.HasFields("FileName", fields))
{
model.FileName = DbTool.ConvertObject <System.String>(dr["FileName"]);
}
if (DbTool.HasFields("ApployTime", fields))
{
model.ApployTime = DbTool.ConvertObject <System.DateTime>(dr["ApployTime"]);
}
if (DbTool.HasFields("BathCode", fields))
{
model.BathCode = DbTool.ConvertObject <System.String>(dr["BathCode"]);
}
if (DbTool.HasFields("Secret", fields))
{
model.Secret = DbTool.ConvertObject <System.String>(dr["Secret"]);
}
if (DbTool.HasFields("CustomerEmail", fields))
{
model.CustomerEmail = DbTool.ConvertObject <System.String>(dr["CustomerEmail"]);
}
if (DbTool.HasFields("Type", fields))
{
model.Type = DbTool.ConvertObject <System.Int32>(dr["Type"]);
}
if (DbTool.HasFields("Url", fields))
{
model.Url = DbTool.ConvertObject <System.String>(dr["Url"]);
}
if (DbTool.HasFields("Status", fields))
{
model.Status = DbTool.ConvertObject <System.Int32>(dr["Status"]);
}
if (DbTool.HasFields("CreatedTime", fields))
{
model.CreatedTime = DbTool.ConvertObject <System.DateTime>(dr["CreatedTime"]);
}
if (DbTool.HasFields("UpdateTime", fields))
{
model.UpdateTime = DbTool.ConvertObject <System.DateTime>(dr["UpdateTime"]);
}
if (DbTool.HasFields("DownTime", fields))
{
model.DownTime = DbTool.ConvertObject <System.DateTime>(dr["DownTime"]);
}
if (DbTool.HasFields("CompleteTime", fields))
{
model.CompleteTime = DbTool.ConvertObject <System.DateTime>(dr["CompleteTime"]);
}
if (DbTool.HasFields("Remarks", fields))
{
model.Remarks = DbTool.ConvertObject <System.String>(dr["Remarks"]);
}
return(model);
}