/// <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 CompanyRelation ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(BWJSHelperSQL.Query(strSql.ToString()));
}
/// <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.[NL_ConsultStatusChangeLog] ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(BWJSHelperSQL.Query(strSql.ToString()));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BWJS.Model.NL_Contacts model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo.[NL_Contacts] set ");
strSql.Append(" EditId = @EditId , ");
strSql.Append(" EditDate = @EditDate , ");
strSql.Append(" ConsultId = @ConsultId , ");
strSql.Append(" FullName = @FullName , ");
strSql.Append(" Mobile = @Mobile , ");
strSql.Append(" RelationId = @RelationId , ");
strSql.Append(" Depth = @Depth , ");
strSql.Append(" IsDeleted = @IsDeleted , ");
strSql.Append(" CreateId = @CreateId , ");
strSql.Append(" CreateDate = @CreateDate ");
strSql.Append(" where ContactId=@ContactId ");
SqlParameter[] parameters =
{
new SqlParameter("@ContactId", model.ContactId),
new SqlParameter("@EditId", model.EditId),
new SqlParameter("@EditDate", model.EditDate),
new SqlParameter("@ConsultId", model.ConsultId),
new SqlParameter("@FullName", model.FullName),
new SqlParameter("@Mobile", model.Mobile),
new SqlParameter("@RelationId", model.RelationId),
new SqlParameter("@Depth", model.Depth),
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@CreateId", model.CreateId),
new SqlParameter("@CreateDate", model.CreateDate)
};
int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取广告
/// </summary>
/// <returns></returns>
public DataTable GetReleaseExpandL(string where)
{
try
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append(@"select
a.*,b.[AdPositionID] PositionId,b.[Name] PositionName ,b.Sort
from [BWJSDB].[dbo].[AdRelease] a left join [BWJSDB].[dbo].[AdPosition] b on b.[AdReleaseID]=a.[AdReleaseID] AND b.RecordIsDelete=0 ");
if (!string.IsNullOrEmpty(where))
{
tablesql.AppendFormat(" where {0} ", where);
}
return(BWJSHelperSQL.ReturnDataTable(tablesql.ToString()));
}
catch
{
}
return(null);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BWJS.Model.AdRelease model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AdRelease set ");
strSql.Append(" AdReleaseName = @AdReleaseName , ");
strSql.Append(" Remark = @Remark , ");
strSql.Append(" BeginTime = @BeginTime , ");
strSql.Append(" EndTime = @EndTime , ");
strSql.Append(" ResourceID = @ResourceID , ");
strSql.Append(" CreatUserID = @CreatUserID , ");
strSql.Append(" RecordUpdateUserID = @RecordUpdateUserID , ");
strSql.Append(" RecordIsDelete = @RecordIsDelete , ");
strSql.Append(" RecordUpdateTime = @RecordUpdateTime , ");
strSql.Append(" RecordCreateTime = @RecordCreateTime ");
strSql.Append(" where AdReleaseID=@AdReleaseID ");
SqlParameter[] parameters =
{
new SqlParameter("@AdReleaseID", model.AdReleaseID),
new SqlParameter("@AdReleaseName", model.AdReleaseName),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@BeginTime", model.BeginTime),
new SqlParameter("@EndTime", model.EndTime),
new SqlParameter("@ResourceID", model.ResourceID),
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)
};
int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BWJS.Model.CompanyRebate model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo.[CompanyRebate](");
strSql.Append("SettlementMethod,SalesPercentage,ProfitDescription,Remark,IsDeleted,CreateId,CreateDate,EditId,EditDate,CompanyId,ProductId,CaseCode,RebateName,CompanyRebatePer,MerchantRebate,AgentRebate,HQRebate");
strSql.Append(") values (");
strSql.Append("@SettlementMethod,@SalesPercentage,@ProfitDescription,@Remark,@IsDeleted,@CreateId,@CreateDate,@EditId,@EditDate,@CompanyId,@ProductId,@CaseCode,@RebateName,@CompanyRebatePer,@MerchantRebate,@AgentRebate,@HQRebate");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@SettlementMethod", model.SettlementMethod),
new SqlParameter("@SalesPercentage", model.SalesPercentage),
new SqlParameter("@ProfitDescription", model.ProfitDescription),
new SqlParameter("@Remark", model.Remark),
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("@CompanyId", model.CompanyId),
new SqlParameter("@ProductId", model.ProductId),
new SqlParameter("@CaseCode", model.CaseCode),
new SqlParameter("@RebateName", model.RebateName),
new SqlParameter("@CompanyRebatePer", model.CompanyRebatePer),
new SqlParameter("@MerchantRebate", model.MerchantRebate),
new SqlParameter("@AgentRebate", model.AgentRebate),
new SqlParameter("@HQRebate", model.HQRebate)
};
object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Resource model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Resource set ");
strSql.Append(" ResourceName = @ResourceName , ");
strSql.Append(" FileName = @FileName , ");
strSql.Append(" VirtualPath = @VirtualPath , ");
strSql.Append(" FilePath = @FilePath , ");
strSql.Append(" FileSuffix = @FileSuffix , ");
strSql.Append(" MD5 = @MD5 , ");
strSql.Append(" RecordUpdateUserID = @RecordUpdateUserID , ");
strSql.Append(" RecordUpdateTime = GetDate() ");
strSql.Append(" where ResourceID=@ResourceID and RecordUpdateTime = @RecordUpdateTime");
SqlParameter[] parameters =
{
new SqlParameter("@ResourceID", model.ResourceID),
new SqlParameter("@ResourceName", model.ResourceName),
new SqlParameter("@FileName", model.FileName),
new SqlParameter("@VirtualPath", model.VirtualPath),
new SqlParameter("@FilePath", model.FilePath),
new SqlParameter("@FileSuffix", model.FileSuffix),
new SqlParameter("@MD5", model.MD5),
new SqlParameter("@RecordUpdateUserID", model.RecordUpdateUserID),
new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime)
};
int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DataSet GetAssignCheck(int RoleId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" from RoleFunction ");
strSql.Append(" where RoleId=@RoleId and IsDeleted=0");
SqlParameter[] parameters =
{
new SqlParameter("@RoleId", SqlDbType.Int, 4)
};
parameters[0].Value = RoleId;
BWJS.Model.RoleFunction model = new BWJS.Model.RoleFunction();
DataSet ds = BWJSHelperSQL.Query(strSql.ToString(), parameters);
return(ds);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BWJS.Model.Role model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [Role] set ");
strSql.Append(" IsDeleted = @IsDeleted , ");
strSql.Append(" RoleName = @RoleName , ");
strSql.Append(" RoleType = @RoleType , ");
strSql.Append(" RoleStatus = @RoleStatus , ");
strSql.Append(" ParentId = @ParentId , ");
strSql.Append(" Remark = @Remark , ");
strSql.Append(" EditId = @EditId , ");
strSql.Append(" EditDate = @EditDate, ");
strSql.Append(" IsManager = @IsManager ");
strSql.Append(" where RoleId=@RoleId ");
SqlParameter[] parameters =
{
new SqlParameter("@RoleId", model.RoleId),
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@RoleName", model.RoleName),
new SqlParameter("@RoleType", model.RoleType),
new SqlParameter("@RoleStatus", model.RoleStatus),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@ParentId", model.ParentId),
new SqlParameter("@IsManager", model.IsManager),
new SqlParameter("@EditId", model.EditId),
new SqlParameter("@EditDate", model.EditDate)
};
int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BWJS.Model.SysSettings model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo.[SysSettings](");
strSql.Append("TimerSeconds,Remark,Status,IsDeleted,CreateId,CreateDate,EditId,EditDate,CompnayName,IP,DomainName,Logo,Icon,RecordNumber,TimerHours,TimerMinutes");
strSql.Append(") values (");
strSql.Append("@TimerSeconds,@Remark,@Status,@IsDeleted,@CreateId,@CreateDate,@EditId,@EditDate,@CompnayName,@IP,@DomainName,@Logo,@Icon,@RecordNumber,@TimerHours,@TimerMinutes");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@TimerSeconds", model.TimerSeconds),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@Status", model.Status),
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("@CompnayName", model.CompnayName),
new SqlParameter("@IP", model.IP),
new SqlParameter("@DomainName", model.DomainName),
new SqlParameter("@Logo", model.Logo),
new SqlParameter("@Icon", model.Icon),
new SqlParameter("@RecordNumber", model.RecordNumber),
new SqlParameter("@TimerHours", model.TimerHours),
new SqlParameter("@TimerMinutes", model.TimerMinutes)
};
object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BWJS.Model.SysConfig model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo.[SysConfig] set ");
strSql.Append(" RecordCreateTime = @RecordCreateTime , ");
strSql.Append(" KeyType = @KeyType , ");
strSql.Append(" KeyName = @KeyName , ");
strSql.Append(" KeyVal = @KeyVal , ");
strSql.Append(" Description = @Description , ");
strSql.Append(" CreatUserID = @CreatUserID , ");
strSql.Append(" RecordUpdateUserID = @RecordUpdateUserID , ");
strSql.Append(" RecordIsDelete = @RecordIsDelete , ");
strSql.Append(" RecordUpdateTime = @RecordUpdateTime ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", model.Id),
new SqlParameter("@RecordCreateTime", model.RecordCreateTime),
new SqlParameter("@KeyType", model.KeyType),
new SqlParameter("@KeyName", model.KeyName),
new SqlParameter("@KeyVal", model.KeyVal),
new SqlParameter("@Description", model.Description),
new SqlParameter("@CreatUserID", model.CreatUserID),
new SqlParameter("@RecordUpdateUserID", model.RecordUpdateUserID),
new SqlParameter("@RecordIsDelete", model.RecordIsDelete),
new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime)
};
int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取记录总数
/// </summary>
public int GetRecordCount(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) FROM R_UsersMachine ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
object obj = BWJSHelperSQL.GetSingle(strSql.ToString());
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 用户登录
/// </summary>
/// <returns></returns>
public Users AdminLogin(string AdminName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from Users where RecordIsDelete=0 and LoginName=@LoginName");
SqlParameter[] parameters =
{
new SqlParameter("@LoginName", AdminName)
};
Users model = new Users();
DataSet ds = BWJSHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public bool ChangeSort(int AdPositionID, int Sort)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE AdPosition SET Sort=@Sort,RecordUpdateTime=GETDATE(),RecordUpdateUserID=1 WHERE AdPositionID=@AdPositionID AND RecordIsDelete=0 ");
SqlParameter[] parameters =
{
new SqlParameter("@Sort", Sort),
new SqlParameter("@AdPositionID", AdPositionID)
};
int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(XBWN.Model.xbwn_UserBank model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo.[xbwn_UserBank](");
strSql.Append("Flag,IsDeleted,CreateId,CreateDate,EditId,EditDate,NetLoanApplyId,No,RealName,IdNo,BankCardNo,TelNo,Cash,SmsCode");
strSql.Append(") values (");
strSql.Append("@Flag,@IsDeleted,@CreateId,@CreateDate,@EditId,@EditDate,@NetLoanApplyId,@No,@RealName,@IdNo,@BankCardNo,@TelNo,@Cash,@SmsCode");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@Flag", model.Flag),
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("@No", model.No),
new SqlParameter("@RealName", model.RealName),
new SqlParameter("@IdNo", model.IdNo),
new SqlParameter("@BankCardNo", model.BankCardNo),
new SqlParameter("@TelNo", model.TelNo),
new SqlParameter("@Cash", model.Cash),
new SqlParameter("@SmsCode", model.SmsCode)
};
object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BWJS.Model.Function model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Function](");
strSql.Append("Status,OrderId,CreateId,CreateDate,EditId,EditDate,IsDeleted,Remark,FunctionName,FunctionCode,FunctionIcon,FunctionClass,ClassId,ParentId,ExternalLinkAddress,FunctionDir");
strSql.Append(") values (");
strSql.Append("@Status,@OrderId,@CreateId,@CreateDate,@EditId,@EditDate,@IsDeleted,@Remark,@FunctionName,@FunctionCode,@FunctionIcon,@FunctionClass,@ClassId,@ParentId,@ExternalLinkAddress,@FunctionDir");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@Status", model.Status),
new SqlParameter("@OrderId", model.OrderId),
new SqlParameter("@CreateId", model.CreateId),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@EditId", model.EditId),
new SqlParameter("@EditDate", model.EditDate),
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@FunctionName", model.FunctionName),
new SqlParameter("@FunctionCode", model.FunctionCode),
new SqlParameter("@FunctionIcon", model.FunctionIcon),
new SqlParameter("@FunctionClass", model.FunctionClass),
new SqlParameter("@ClassId", model.ClassId),
new SqlParameter("@ParentId", model.ParentId),
new SqlParameter("@ExternalLinkAddress", model.ExternalLinkAddress),
new SqlParameter("@FunctionDir", model.FunctionDir)
};
object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BWJS.Model.UserBank model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo.[UserBank](");
strSql.Append("Remark,CreateId,CreateDate,EditId,EditDate,IsDeleted,UserId,BankCode,OpeningBank,CardHolder,CardNumber,BankAddress,AlipayAccount,IsDefault");
strSql.Append(") values (");
strSql.Append("@Remark,@CreateId,@CreateDate,@EditId,@EditDate,@IsDeleted,@UserId,@BankCode,@OpeningBank,@CardHolder,@CardNumber,@BankAddress,@AlipayAccount,@IsDefault");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@CreateId", model.CreateId),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@EditId", model.EditId),
new SqlParameter("@EditDate", model.EditDate),
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@UserId", model.UserId),
new SqlParameter("@BankCode", model.BankCode),
new SqlParameter("@OpeningBank", model.OpeningBank),
new SqlParameter("@CardHolder", model.CardHolder),
new SqlParameter("@CardNumber", model.CardNumber),
new SqlParameter("@BankAddress", model.BankAddress),
new SqlParameter("@AlipayAccount", model.AlipayAccount),
new SqlParameter("@IsDefault", model.IsDefault)
};
object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(XBWN.Model.xbwn_Picture model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo.[xbwn_Picture] set ");
strSql.Append(" NetLoanApplyId = @NetLoanApplyId , ");
strSql.Append(" Base64Code = @Base64Code , ");
strSql.Append(" ImgId = @ImgId , ");
strSql.Append(" IsDeleted = @IsDeleted , ");
strSql.Append(" CreateId = @CreateId , ");
strSql.Append(" CreateDate = @CreateDate , ");
strSql.Append(" EditId = @EditId , ");
strSql.Append(" EditDate = @EditDate ");
strSql.Append(" where PictiureId=@PictiureId ");
SqlParameter[] parameters =
{
new SqlParameter("@PictiureId", model.PictiureId),
new SqlParameter("@NetLoanApplyId", model.NetLoanApplyId),
new SqlParameter("@Base64Code", model.Base64Code),
new SqlParameter("@ImgId", model.ImgId),
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)
};
int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool UpdateDelete(int AdPositionID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update AdPosition set RecordIsDelete=1 ");
strSql.Append(" where AdPositionID=@AdPositionID");
SqlParameter[] parameters =
{
new SqlParameter("@AdPositionID", AdPositionID)
};
int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(XBWN.Model.xbwn_Task model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo.[xbwn_Task](");
strSql.Append("IsDeleted,CreateId,CreateDate,EditId,EditDate,NetLoanApplyId,TelNo,ServicePwd,TaskId,State,TaskStatus,ImgStr,Mark");
strSql.Append(") values (");
strSql.Append("@IsDeleted,@CreateId,@CreateDate,@EditId,@EditDate,@NetLoanApplyId,@TelNo,@ServicePwd,@TaskId,@State,@TaskStatus,@ImgStr,@Mark");
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("@TelNo", model.TelNo),
new SqlParameter("@ServicePwd", model.ServicePwd),
new SqlParameter("@TaskId", model.TaskId),
new SqlParameter("@State", model.State),
new SqlParameter("@TaskStatus", model.TaskStatus),
new SqlParameter("@ImgStr", model.ImgStr),
new SqlParameter("@Mark", model.Mark)
};
object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 根据Key的名称 查询Key值
/// </summary>
/// <param name="Keyname"></param>
/// <returns></returns>
public string GetValue(string Keyname)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select KeyVal from SysConfig ");
strSql.Append(" where KeyName=@keyname ");
SqlParameter[] parameters =
{
new SqlParameter("@keyname", SqlDbType.NVarChar)
};
parameters[0].Value = Keyname;
object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters);
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
return("");
}
else
{
return(obj.ToString());
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BWJS.Model.OrderPayApply model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OrderPayApply(");
strSql.Append("PayJson,CreateDate,PayDate,Remark,IsDeleted,OrderRebateId,OrderMoney,PayOrderNumber,PayStatus,PayPlatform,PayMethod,PayCode,PayText");
strSql.Append(") values (");
strSql.Append("@PayJson,@CreateDate,@PayDate,@Remark,@IsDeleted,@OrderRebateId,@OrderMoney,@PayOrderNumber,@PayStatus,@PayPlatform,@PayMethod,@PayCode,@PayText");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@PayJson", model.PayJson),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@PayDate", model.PayDate),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@OrderRebateId", model.OrderRebateId),
new SqlParameter("@OrderMoney", model.OrderMoney),
new SqlParameter("@PayOrderNumber", model.PayOrderNumber),
new SqlParameter("@PayStatus", model.PayStatus),
new SqlParameter("@PayPlatform", model.PayPlatform),
new SqlParameter("@PayMethod", model.PayMethod),
new SqlParameter("@PayCode", model.PayCode),
new SqlParameter("@PayText", model.PayText)
};
object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BWJS.Model.DepartmentInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [DepartmentInfo] set ");
strSql.Append(" DepartmentName = @DepartmentName , ");
strSql.Append(" ParentID = @ParentID , ");
strSql.Append(" DepartmentCode = @DepartmentCode , ");
strSql.Append(" Remark = @Remark , ");
strSql.Append(" UpdateUser = @UpdateUser , ");
strSql.Append(" IsReceiveBusiness = @IsReceiveBusiness , ");
strSql.Append(" RecordIsDelete = @RecordIsDelete , ");
strSql.Append(" RecordUpdateTime = @RecordUpdateTime ");
strSql.Append(" where DepartmentID=@DepartmentID ");
SqlParameter[] parameters =
{
new SqlParameter("@DepartmentID", model.DepartmentID),
new SqlParameter("@DepartmentName", model.DepartmentName),
new SqlParameter("@ParentID", model.ParentID),
new SqlParameter("@DepartmentCode", model.DepartmentCode),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@UpdateUser", model.UpdateUser),
new SqlParameter("@IsReceiveBusiness", model.IsReceiveBusiness),
new SqlParameter("@RecordIsDelete", model.RecordIsDelete),
new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime)
};
int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool UpdateDelete(int RoleId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update [Role] set IsDeleted=1 where RoleId=@RoleId; UPDATE UserRole SET IsDeleted=1 WHERE RoleId=@RoleId AND IsDeleted=0");
SqlParameter[] parameters =
{
new SqlParameter("@RoleId", RoleId)
};
int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BWJS.Model.RoleFunction model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update RoleFunction set ");
strSql.Append(" RoleFunctionId = @RoleFunctionId , ");
strSql.Append(" RoleId = @RoleId , ");
strSql.Append(" FunctionId = @FunctionId , ");
strSql.Append(" CreateId = @CreateId , ");
strSql.Append(" CreateDate = @CreateDate , ");
strSql.Append(" EditId = @EditId , ");
strSql.Append(" EditDate = @EditDate , ");
strSql.Append(" IsDeleted = @IsDeleted ");
strSql.Append(" where RoleFunctionId=@RoleFunctionId ");
SqlParameter[] parameters =
{
new SqlParameter("@RoleFunctionId", model.RoleFunctionId),
new SqlParameter("@RoleId", model.RoleId),
new SqlParameter("@FunctionId", model.FunctionId),
new SqlParameter("@CreateId", model.CreateId),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@EditId", model.EditId),
new SqlParameter("@EditDate", model.EditDate),
new SqlParameter("@IsDeleted", model.IsDeleted)
};
int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改默认银行卡
/// </summary>
public bool SetDefault(int userBankId, int userId, int editId)
{
List <String> tsql = new List <String>();
StringBuilder tableSql = new StringBuilder();
tableSql.AppendFormat("update UserBank set IsDefault=0,EditId={0},EditDate='{1}' where UserId={2}", editId, DateTime.Now, userId);
tsql.Add(tableSql.ToString());
tableSql = new StringBuilder();
tableSql.AppendFormat("update UserBank set IsDefault=1,EditId={0},EditDate='{1}' where UserBankId={2}", editId, DateTime.Now, userBankId);
tsql.Add(tableSql.ToString());
int rows = BWJSHelperSQL.ExecuteSqlTran(tsql);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public string GetSignName(int SId)
{
string resultStr = string.Empty;
StringBuilder strSql = new StringBuilder();
strSql.Append("select SignName ");
strSql.Append(" from SupplierInfo ");
strSql.Append(" where SId=@SId");
SqlParameter[] parameters =
{
new SqlParameter("@SId", SqlDbType.Int, 4)
};
parameters[0].Value = SId;
SupplierInfo model = new SupplierInfo();
DataSet ds = BWJSHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
resultStr = ds.Tables[0].Rows[0]["SignName"].ToString();
}
return(resultStr);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BWJS.Model.NL_ProfessionInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo.[NL_ProfessionInfo](");
strSql.Append("ConsultId,FullName,Age,MonthlyIncome,Company,UnitNature,WorkingHour,Payroll,JobPosition,SocialSecurit,Fund,Degree,GraduationYear");
strSql.Append(") values (");
strSql.Append("@ConsultId,@FullName,@Age,@MonthlyIncome,@Company,@UnitNature,@WorkingHour,@Payroll,@JobPosition,@SocialSecurit,@Fund,@Degree,@GraduationYear");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@ConsultId", model.ConsultId),
new SqlParameter("@FullName", model.FullName),
new SqlParameter("@Age", model.Age),
new SqlParameter("@MonthlyIncome", model.MonthlyIncome),
new SqlParameter("@Company", model.Company),
new SqlParameter("@UnitNature", model.UnitNature),
new SqlParameter("@WorkingHour", model.WorkingHour),
new SqlParameter("@Payroll", model.Payroll),
new SqlParameter("@JobPosition", model.JobPosition),
new SqlParameter("@SocialSecurit", model.SocialSecurit),
new SqlParameter("@Fund", model.Fund),
new SqlParameter("@Degree", model.Degree),
new SqlParameter("@GraduationYear", model.GraduationYear)
};
object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(R_UsersMachine model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update R_UsersMachine set ");
strSql.Append("UserID=@UserID,");
strSql.Append("MachineID=@MachineID,");
strSql.Append("RecordIsDelete=@RecordIsDelete,");
strSql.Append("RecordCreateTime=@RecordCreateTime,");
strSql.Append("RecordUpdateTime@=RecordUpdateTime");
strSql.Append(" where RUMID=@RUMID");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@MachineID", SqlDbType.Int, 4),
new SqlParameter("@RecordIsDelete", SqlDbType.Bit, 1),
new SqlParameter("@RecordCreateTime", SqlDbType.DateTime),
new SqlParameter("@RecordUpdateTime", SqlDbType.DateTime),
new SqlParameter("@RUMID", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.MachineID;
parameters[2].Value = model.RecordIsDelete;
parameters[3].Value = model.RecordCreateTime;
parameters[4].Value = model.RecordUpdateTime;
parameters[5].Value = model.RUMID;
int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BWJS.Model.OrderRebate GetModel(int OrderRebateId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select OrderRebateId, AgentMoney, AgentRebate, HQRebate, HQMoney, NetProfit, PayStatus, IsSettled, IsCancel, SettlementDate, CreateDate, TransNo, Remark, IsDeleted, CompanyId, UserId, OrderApplyId, CompanyRebateId, OrderMoney, MerchantRebate, MerchantMoney ");
strSql.Append(" from dbo.[OrderRebate] ");
strSql.Append(" where OrderRebateId=@OrderRebateId");
SqlParameter[] parameters = {
new SqlParameter("@OrderRebateId", SqlDbType.Int,4)
};
parameters[0].Value = OrderRebateId;
BWJS.Model.OrderRebate model = new BWJS.Model.OrderRebate();
DataSet ds = BWJSHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
