/// <summary>
/// 得到一个对象实体
/// </summary>
public BWJSLog.Model.SmsSendLog GetModel(int SmsLogId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SmsLogId, SendResult, SmsTemplateId, SendType, SmsContent, Mobile, Status, IsDeleted, CreateDate, SendDate ");
strSql.Append(" from SmsSendLog ");
strSql.Append(" where SmsLogId=@SmsLogId");
SqlParameter[] parameters =
{
new SqlParameter("@SmsLogId", SqlDbType.Int, 4)
};
parameters[0].Value = SmsLogId;
BWJSLog.Model.SmsSendLog model = new BWJSLog.Model.SmsSendLog();
DataSet ds = BWJSLogHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MofangSendLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MofangSendLog(");
strSql.Append("MothodName,FKID,TransNo,IsSend,Message,SendTime,CreatUserID,RecordUpdateUserID,RecordIsDelete,RecordUpdateTime,RecordCreateTime");
strSql.Append(") values (");
strSql.Append("@MothodName,@FKID,@TransNo,@IsSend,@Message,@SendTime,@CreatUserID,@RecordUpdateUserID,@RecordIsDelete,@RecordUpdateTime,@RecordCreateTime");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@MothodName", model.MothodName),
new SqlParameter("@FKID", model.FKID),
new SqlParameter("@TransNo", model.TransNo),
new SqlParameter("@IsSend", model.IsSend),
new SqlParameter("@Message", model.Message),
new SqlParameter("@SendTime", model.SendTime),
new SqlParameter("@CreatUserID", model.CreatUserID),
new SqlParameter("@RecordUpdateUserID", model.RecordUpdateUserID),
new SqlParameter("@RecordIsDelete", model.RecordIsDelete),
new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime),
new SqlParameter("@RecordCreateTime", model.RecordCreateTime)
};
object obj = BWJSLogHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BWJSLog.Model.ApiInvokingLog GetModel(int ApiInvokingLogId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ApiInvokingLogId, ResponseDate, ResponseData, IsDeleted, CreateId, CreateDate, CompanyId, BusinessType, RelationId, ClassName, MethodName, ApiUrl, RequestDate, RequestData ");
strSql.Append(" from dbo.[ApiInvokingLog] ");
strSql.Append(" where ApiInvokingLogId=@ApiInvokingLogId");
SqlParameter[] parameters =
{
new SqlParameter("@ApiInvokingLogId", SqlDbType.Int, 4)
};
parameters[0].Value = ApiInvokingLogId;
BWJSLog.Model.ApiInvokingLog model = new BWJSLog.Model.ApiInvokingLog();
DataSet ds = BWJSLogHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BWJSLog.Model.MachineLocationLog GetModel(int MachineLocationLogId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select MachineLocationLogId, CreateDate, IsDeleted, Remark, UserId, MachineId, IP, MAC, Latitude, Longitude, LocationAddress, LocationData ");
strSql.Append(" from dbo.[MachineLocationLog] ");
strSql.Append(" where MachineLocationLogId=@MachineLocationLogId");
SqlParameter[] parameters =
{
new SqlParameter("@MachineLocationLogId", SqlDbType.Int, 4)
};
parameters[0].Value = MachineLocationLogId;
BWJSLog.Model.MachineLocationLog model = new BWJSLog.Model.MachineLocationLog();
DataSet ds = BWJSLogHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BWJSLog.Model.OperationLog GetModel(int OperationLogId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select OperationLogId, DepartmentName, RoleId, RoleName, GroupId, GroupName, BusinessType, RelationId, LogContent, Ip, UserId, RealName, CreateDate, DepartmentId ");
strSql.Append(" from dbo.[OperationLog] ");
strSql.Append(" where OperationLogId=@OperationLogId");
SqlParameter[] parameters =
{
new SqlParameter("@OperationLogId", SqlDbType.Int, 4)
};
parameters[0].Value = OperationLogId;
BWJSLog.Model.OperationLog model = new BWJSLog.Model.OperationLog();
DataSet ds = BWJSLogHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BWJSLog.Model.SmsSendLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SmsSendLog(");
strSql.Append("SendResult,SmsTemplateId,SendType,SmsContent,Mobile,Status,IsDeleted,CreateDate,SendDate");
strSql.Append(") values (");
strSql.Append("@SendResult,@SmsTemplateId,@SendType,@SmsContent,@Mobile,@Status,@IsDeleted,@CreateDate,@SendDate");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@SendResult", model.SendResult),
new SqlParameter("@SmsTemplateId", model.SmsTemplateId),
new SqlParameter("@SendType", model.SendType),
new SqlParameter("@SmsContent", model.SmsContent),
new SqlParameter("@Mobile", model.Mobile),
new SqlParameter("@Status", model.Status),
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@SendDate", model.SendDate)
};
object obj = BWJSLogHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BWJSLog.Model.XinboweinuoLog GetModel(int XinboweinuoLogId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select XinboweinuoLogId, IsDeleted, CreateId, CreateDate, EditId, EditDate, NetLoanApplyId, ClassName, MethodName, ApiUrl, RequestDate, RequestData, ResponseDate, ResponseData ");
strSql.Append(" from dbo.[XinboweinuoLog] ");
strSql.Append(" where XinboweinuoLogId=@XinboweinuoLogId");
SqlParameter[] parameters =
{
new SqlParameter("@XinboweinuoLogId", SqlDbType.Int, 4)
};
parameters[0].Value = XinboweinuoLogId;
BWJSLog.Model.XinboweinuoLog model = new BWJSLog.Model.XinboweinuoLog();
DataSet ds = BWJSLogHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append("select * ");
tablesql.Append(" FROM dbo.[OperationLog] ");
return(BWJSLogHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM dbo.[OperationLog] ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(BWJSLogHelperSQL.Query(strSql.ToString()));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BWJSLog.Model.XinboweinuoLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo.[XinboweinuoLog] set ");
strSql.Append(" IsDeleted = @IsDeleted , ");
strSql.Append(" CreateId = @CreateId , ");
strSql.Append(" CreateDate = @CreateDate , ");
strSql.Append(" EditId = @EditId , ");
strSql.Append(" EditDate = @EditDate , ");
strSql.Append(" NetLoanApplyId = @NetLoanApplyId , ");
strSql.Append(" ClassName = @ClassName , ");
strSql.Append(" MethodName = @MethodName , ");
strSql.Append(" ApiUrl = @ApiUrl , ");
strSql.Append(" RequestDate = @RequestDate , ");
strSql.Append(" RequestData = @RequestData , ");
strSql.Append(" ResponseDate = @ResponseDate , ");
strSql.Append(" ResponseData = @ResponseData ");
strSql.Append(" where XinboweinuoLogId=@XinboweinuoLogId ");
SqlParameter[] parameters =
{
new SqlParameter("@XinboweinuoLogId", model.XinboweinuoLogId),
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@CreateId", model.CreateId),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@EditId", model.EditId),
new SqlParameter("@EditDate", model.EditDate),
new SqlParameter("@NetLoanApplyId", model.NetLoanApplyId),
new SqlParameter("@ClassName", model.ClassName),
new SqlParameter("@MethodName", model.MethodName),
new SqlParameter("@ApiUrl", model.ApiUrl),
new SqlParameter("@RequestDate", model.RequestDate),
new SqlParameter("@RequestData", model.RequestData),
new SqlParameter("@ResponseDate", model.ResponseDate),
new SqlParameter("@ResponseData", model.ResponseData)
};
int rows = BWJSLogHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BWJSLog.Model.OperationLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo.[OperationLog] set ");
strSql.Append(" DepartmentName = @DepartmentName , ");
strSql.Append(" RoleId = @RoleId , ");
strSql.Append(" RoleName = @RoleName , ");
strSql.Append(" GroupId = @GroupId , ");
strSql.Append(" GroupName = @GroupName , ");
strSql.Append(" BusinessType = @BusinessType , ");
strSql.Append(" RelationId = @RelationId , ");
strSql.Append(" LogContent = @LogContent , ");
strSql.Append(" Ip = @Ip , ");
strSql.Append(" UserId = @UserId , ");
strSql.Append(" RealName = @RealName , ");
strSql.Append(" CreateDate = @CreateDate , ");
strSql.Append(" DepartmentId = @DepartmentId ");
strSql.Append(" where OperationLogId=@OperationLogId ");
SqlParameter[] parameters =
{
new SqlParameter("@OperationLogId", model.OperationLogId),
new SqlParameter("@DepartmentName", model.DepartmentName),
new SqlParameter("@RoleId", model.RoleId),
new SqlParameter("@RoleName", model.RoleName),
new SqlParameter("@GroupId", model.GroupId),
new SqlParameter("@GroupName", model.GroupName),
new SqlParameter("@BusinessType", model.BusinessType),
new SqlParameter("@RelationId", model.RelationId),
new SqlParameter("@LogContent", model.LogContent),
new SqlParameter("@Ip", model.Ip),
new SqlParameter("@UserId", model.UserId),
new SqlParameter("@RealName", model.RealName),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@DepartmentId", model.DepartmentId)
};
int rows = BWJSLogHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BWJSLog.Model.ApiInvokingLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo.[ApiInvokingLog] set ");
strSql.Append(" ResponseDate = @ResponseDate , ");
strSql.Append(" ResponseData = @ResponseData , ");
strSql.Append(" IsDeleted = @IsDeleted , ");
strSql.Append(" CreateId = @CreateId , ");
strSql.Append(" CreateDate = @CreateDate , ");
strSql.Append(" CompanyId = @CompanyId , ");
strSql.Append(" BusinessType = @BusinessType , ");
strSql.Append(" RelationId = @RelationId , ");
strSql.Append(" ClassName = @ClassName , ");
strSql.Append(" MethodName = @MethodName , ");
strSql.Append(" ApiUrl = @ApiUrl , ");
strSql.Append(" RequestDate = @RequestDate , ");
strSql.Append(" RequestData = @RequestData ");
strSql.Append(" where ApiInvokingLogId=@ApiInvokingLogId ");
SqlParameter[] parameters =
{
new SqlParameter("@ApiInvokingLogId", model.ApiInvokingLogId),
new SqlParameter("@ResponseDate", model.ResponseDate),
new SqlParameter("@ResponseData", model.ResponseData),
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@CreateId", model.CreateId),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@CompanyId", model.CompanyId),
new SqlParameter("@BusinessType", model.BusinessType),
new SqlParameter("@RelationId", model.RelationId),
new SqlParameter("@ClassName", model.ClassName),
new SqlParameter("@MethodName", model.MethodName),
new SqlParameter("@ApiUrl", model.ApiUrl),
new SqlParameter("@RequestDate", model.RequestDate),
new SqlParameter("@RequestData", model.RequestData)
};
int rows = BWJSLogHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BWJSLog.Model.MachineLocationLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo.[MachineLocationLog] set ");
strSql.Append(" CreateDate = @CreateDate , ");
strSql.Append(" IsDeleted = @IsDeleted , ");
strSql.Append(" Remark = @Remark , ");
strSql.Append(" UserId = @UserId , ");
strSql.Append(" MachineId = @MachineId , ");
strSql.Append(" IP = @IP , ");
strSql.Append(" MAC = @MAC , ");
strSql.Append(" Latitude = @Latitude , ");
strSql.Append(" Longitude = @Longitude , ");
strSql.Append(" LocationAddress = @LocationAddress , ");
strSql.Append(" LocationData = @LocationData ");
strSql.Append(" where MachineLocationLogId=@MachineLocationLogId ");
SqlParameter[] parameters =
{
new SqlParameter("@MachineLocationLogId", model.MachineLocationLogId),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@UserId", model.UserId),
new SqlParameter("@MachineId", model.MachineId),
new SqlParameter("@IP", model.IP),
new SqlParameter("@MAC", model.MAC),
new SqlParameter("@Latitude", model.Latitude),
new SqlParameter("@Longitude", model.Longitude),
new SqlParameter("@LocationAddress", model.LocationAddress),
new SqlParameter("@LocationData", model.LocationData)
};
int rows = BWJSLogHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 批量删除一批数据
/// </summary>
public bool UpdateDeleteList(string MofangSendLogIDlist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MofangSendLog set RecordIsDelete =1 ");
strSql.Append(" where ID in (" + MofangSendLogIDlist + ") ");
int rows = BWJSLogHelperSQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 批量删除一批数据
/// </summary>
public bool DeleteList(string OperationLogIdlist, int userId)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("update dbo.[OperationLog] set IsDeleted=1,EditId={0},EditDate='{1}'", userId, DateTime.Now);
strSql.Append(" where OperationLogId in (" + OperationLogIdlist + ") ");
int rows = BWJSLogHelperSQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 批量删除一批数据
/// </summary>
public bool DeleteList(string SmsLogIdlist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SmsSendLog set IsDeleted=1");
strSql.Append(" where ID in (" + SmsLogIdlist + ") ");
int rows = BWJSLogHelperSQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" * ");
strSql.Append(" FROM dbo.[OperationLog] ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(BWJSLogHelperSQL.Query(strSql.ToString()));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BWJSLog.Model.SmsSendLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SmsSendLog set ");
strSql.Append(" SendResult = @SendResult , ");
strSql.Append(" SmsTemplateId = @SmsTemplateId , ");
strSql.Append(" SendType = @SendType , ");
strSql.Append(" SmsContent = @SmsContent , ");
strSql.Append(" Mobile = @Mobile , ");
strSql.Append(" Status = @Status , ");
strSql.Append(" IsDeleted = @IsDeleted , ");
strSql.Append(" CreateDate = @CreateDate , ");
strSql.Append(" SendDate = @SendDate ");
strSql.Append(" where SmsLogId=@SmsLogId ");
SqlParameter[] parameters =
{
new SqlParameter("@SmsLogId", model.SmsLogId),
new SqlParameter("@SendResult", model.SendResult),
new SqlParameter("@SmsTemplateId", model.SmsTemplateId),
new SqlParameter("@SendType", model.SendType),
new SqlParameter("@SmsContent", model.SmsContent),
new SqlParameter("@Mobile", model.Mobile),
new SqlParameter("@Status", model.Status),
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@SendDate", model.SendDate)
};
int rows = BWJSLogHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MofangReceivedLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MofangReceivedLog set ");
strSql.Append(" MothodName = @MothodName , ");
strSql.Append(" TransNo = @TransNo , ");
strSql.Append(" IsProcessed = @IsProcessed , ");
strSql.Append(" Message = @Message , ");
strSql.Append(" ReceivedTime = @ReceivedTime , ");
strSql.Append(" RecordUpdateUserID = @RecordUpdateUserID , ");
strSql.Append(" RecordUpdateTime = GetDate() ");
strSql.Append(" where MofangReceivedLogID=@MofangReceivedLogID and RecordUpdateTime = @RecordUpdateTime");
SqlParameter[] parameters =
{
new SqlParameter("@MofangReceivedLogID", model.MofangReceivedLogID),
new SqlParameter("@MothodName", model.MothodName),
new SqlParameter("@TransNo", model.TransNo),
new SqlParameter("@IsProcessed", model.IsProcessed),
new SqlParameter("@Message", model.Message),
new SqlParameter("@ReceivedTime", model.ReceivedTime),
new SqlParameter("@RecordUpdateUserID", model.RecordUpdateUserID),
new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime)
};
int rows = BWJSLogHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BWJSLog.Model.XinboweinuoLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo.[XinboweinuoLog](");
strSql.Append("IsDeleted,CreateId,CreateDate,EditId,EditDate,NetLoanApplyId,ClassName,MethodName,ApiUrl,RequestDate,RequestData,ResponseDate,ResponseData");
strSql.Append(") values (");
strSql.Append("@IsDeleted,@CreateId,@CreateDate,@EditId,@EditDate,@NetLoanApplyId,@ClassName,@MethodName,@ApiUrl,@RequestDate,@RequestData,@ResponseDate,@ResponseData");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@CreateId", model.CreateId),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@EditId", model.EditId),
new SqlParameter("@EditDate", model.EditDate),
new SqlParameter("@NetLoanApplyId", model.NetLoanApplyId),
new SqlParameter("@ClassName", model.ClassName),
new SqlParameter("@MethodName", model.MethodName),
new SqlParameter("@ApiUrl", model.ApiUrl),
new SqlParameter("@RequestDate", model.RequestDate),
new SqlParameter("@RequestData", model.RequestData),
new SqlParameter("@ResponseDate", model.ResponseDate),
new SqlParameter("@ResponseData", model.ResponseData)
};
object obj = BWJSLogHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BWJSLog.Model.ApiInvokingLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo.[ApiInvokingLog](");
strSql.Append("ResponseDate,ResponseData,IsDeleted,CreateId,CreateDate,CompanyId,BusinessType,RelationId,ClassName,MethodName,ApiUrl,RequestDate,RequestData");
strSql.Append(") values (");
strSql.Append("@ResponseDate,@ResponseData,@IsDeleted,@CreateId,@CreateDate,@CompanyId,@BusinessType,@RelationId,@ClassName,@MethodName,@ApiUrl,@RequestDate,@RequestData");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@ResponseDate", model.ResponseDate),
new SqlParameter("@ResponseData", model.ResponseData),
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@CreateId", model.CreateId),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@CompanyId", model.CompanyId),
new SqlParameter("@BusinessType", model.BusinessType),
new SqlParameter("@RelationId", model.RelationId),
new SqlParameter("@ClassName", model.ClassName),
new SqlParameter("@MethodName", model.MethodName),
new SqlParameter("@ApiUrl", model.ApiUrl),
new SqlParameter("@RequestDate", model.RequestDate),
new SqlParameter("@RequestData", model.RequestData)
};
object obj = BWJSLogHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BWJSLog.Model.OperationLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo.[OperationLog](");
strSql.Append("DepartmentName,RoleId,RoleName,GroupId,GroupName,BusinessType,RelationId,LogContent,Ip,UserId,RealName,CreateDate,DepartmentId");
strSql.Append(") values (");
strSql.Append("@DepartmentName,@RoleId,@RoleName,@GroupId,@GroupName,@BusinessType,@RelationId,@LogContent,@Ip,@UserId,@RealName,@CreateDate,@DepartmentId");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@DepartmentName", model.DepartmentName),
new SqlParameter("@RoleId", model.RoleId),
new SqlParameter("@RoleName", model.RoleName),
new SqlParameter("@GroupId", model.GroupId),
new SqlParameter("@GroupName", model.GroupName),
new SqlParameter("@BusinessType", model.BusinessType),
new SqlParameter("@RelationId", model.RelationId),
new SqlParameter("@LogContent", model.LogContent),
new SqlParameter("@Ip", model.Ip),
new SqlParameter("@UserId", model.UserId),
new SqlParameter("@RealName", model.RealName),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@DepartmentId", model.DepartmentId)
};
object obj = BWJSLogHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BWJSLog.Model.MachineLocationLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo.[MachineLocationLog](");
strSql.Append("CreateDate,IsDeleted,Remark,UserId,MachineId,IP,MAC,Latitude,Longitude,LocationAddress,LocationData");
strSql.Append(") values (");
strSql.Append("@CreateDate,@IsDeleted,@Remark,@UserId,@MachineId,@IP,@MAC,@Latitude,@Longitude,@LocationAddress,@LocationData");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@UserId", model.UserId),
new SqlParameter("@MachineId", model.MachineId),
new SqlParameter("@IP", model.IP),
new SqlParameter("@MAC", model.MAC),
new SqlParameter("@Latitude", model.Latitude),
new SqlParameter("@Longitude", model.Longitude),
new SqlParameter("@LocationAddress", model.LocationAddress),
new SqlParameter("@LocationData", model.LocationData)
};
object obj = BWJSLogHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int OperationLogId, int userId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo.[OperationLog] set IsDeleted=1,EditId=@EditId,EditDate=@EditDate");
strSql.Append(" where OperationLogId=@OperationLogId");
SqlParameter[] parameters =
{
new SqlParameter("@EditId", userId),
new SqlParameter("@EditDate", DateTime.Now),
new SqlParameter("@OperationLogId", OperationLogId),
};
int rows = BWJSLogHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int SmsLogId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SmsSendLog set IsDeleted=1");
strSql.Append(" where SmsLogId=@SmsLogId");
SqlParameter[] parameters =
{
new SqlParameter("@SmsLogId", SqlDbType.Int, 4)
};
parameters[0].Value = SmsLogId;
int rows = BWJSLogHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool UpdateDelete(int MofangSendLogID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MofangSendLog set RecordIsDelete =1 ");
strSql.Append(" where MofangSendLogID=@MofangSendLogID");
SqlParameter[] parameters =
{
new SqlParameter("@MofangSendLogID", SqlDbType.Int, 4)
};
parameters[0].Value = MofangSendLogID;
int rows = BWJSLogHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string tablesql, string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
return(BWJSLogHelperSQL.GetPageList(tablesql, where, pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MofangSendLog GetModel(int MofangSendLogID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select MofangSendLogID, MothodName, FKID, TransNo, IsSend, Message, SendTime, CreatUserID, RecordUpdateUserID, RecordIsDelete, RecordUpdateTime, RecordCreateTime ");
strSql.Append(" from MofangSendLog ");
strSql.Append(" where MofangSendLogID=@MofangSendLogID");
SqlParameter[] parameters =
{
new SqlParameter("@MofangSendLogID", SqlDbType.Int, 4)
};
parameters[0].Value = MofangSendLogID;
MofangSendLog model = new MofangSendLog();
DataSet ds = BWJSLogHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["MofangSendLogID"].ToString() != "")
{
model.MofangSendLogID = int.Parse(ds.Tables[0].Rows[0]["MofangSendLogID"].ToString());
}
model.MothodName = ds.Tables[0].Rows[0]["MothodName"].ToString();
if (ds.Tables[0].Rows[0]["FKID"].ToString() != "")
{
model.FKID = int.Parse(ds.Tables[0].Rows[0]["FKID"].ToString());
}
model.TransNo = ds.Tables[0].Rows[0]["TransNo"].ToString();
if (ds.Tables[0].Rows[0]["IsSend"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsSend"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsSend"].ToString().ToLower() == "true"))
{
model.IsSend = true;
}
else
{
model.IsSend = false;
}
}
model.Message = ds.Tables[0].Rows[0]["Message"].ToString();
if (ds.Tables[0].Rows[0]["SendTime"].ToString() != "")
{
model.SendTime = DateTime.Parse(ds.Tables[0].Rows[0]["SendTime"].ToString());
}
if (ds.Tables[0].Rows[0]["CreatUserID"].ToString() != "")
{
model.CreatUserID = int.Parse(ds.Tables[0].Rows[0]["CreatUserID"].ToString());
}
if (ds.Tables[0].Rows[0]["RecordUpdateUserID"].ToString() != "")
{
model.RecordUpdateUserID = int.Parse(ds.Tables[0].Rows[0]["RecordUpdateUserID"].ToString());
}
if (ds.Tables[0].Rows[0]["RecordIsDelete"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["RecordIsDelete"].ToString() == "1") || (ds.Tables[0].Rows[0]["RecordIsDelete"].ToString().ToLower() == "true"))
{
model.RecordIsDelete = true;
}
else
{
model.RecordIsDelete = false;
}
}
if (ds.Tables[0].Rows[0]["RecordUpdateTime"].ToString() != "")
{
model.RecordUpdateTime = DateTime.Parse(ds.Tables[0].Rows[0]["RecordUpdateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["RecordCreateTime"].ToString() != "")
{
model.RecordCreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["RecordCreateTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
