/** 版本信息模板在安装目录下，可自行修改。 * T_Sys_UserAccount.cs * * 功 能： N/A * 类 名： T_Sys_UserAccount * * Ver 变更日期 负责人 变更内容 * ─────────────────────────────────── * V0.01 2015/3/10 14:50:40 N/A 初版 * * Copyright (c) 2012 Maticsoft Corporation. All rights reserved. *┌──────────────────────────────────┐ *│　此技术信息为本公司机密信息，未经本公司书面同意禁止向第三方披露．　│ *│　版权所有：动软卓越（北京）科技有限公司　　　　　　　　　　　　　　│ *└──────────────────────────────────┘ */ using System; using System.Data; using System.Text; using System.Data.SqlClient; using YTSoft.DBUtility;//Please add references namespace YTSoft.BaseCallCenter.DAL { /// /// 数据访问类:T_Sys_UserAccount /// public partial class T_Sys_UserAccount { public T_Sys_UserAccount() {} #region BasicMethod /// /// 得到最大ID /// public int GetMaxId() { return DbHelperSQL.GetMaxID("F_UserId", "T_Sys_UserAccount"); } /// /// 是否存在该记录 /// public bool Exists(int F_UserId) { StringBuilder strSql=new StringBuilder(); strSql.Append("select count(1) from T_Sys_UserAccount"); strSql.Append(" where F_UserId=@F_UserId"); SqlParameter[] parameters = { new SqlParameter("@F_UserId", SqlDbType.Int,4) }; parameters[0].Value = F_UserId; return DbHelperSQL.Exists(strSql.ToString(),parameters); } /// /// 增加一条数据 /// public int Add(YTSoft.BaseCallCenter.Model.T_Sys_UserAccount model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into T_Sys_UserAccount("); strSql.Append("F_UserCode,F_Password,F_ExtensionNumber,F_UserName,F_DeptId,F_RoleId,F_GroupId,F_SeatFlag,F_SeatRight,F_SeatLevel,F_SexFlag,F_RemindFlag,F_Remark,F_Telephone,F_Mobile,F_HomePhone,F_Birthday,F_CreateOn,F_CancelOn,F_DeleteFlag,F_APPOnFlag,F_LastActiveTime,F_See,F_HJType,F_PId,F_TmId,F_WorkNumber,F_DeptCode)"); strSql.Append(" values ("); strSql.Append("@F_UserCode,@F_Password,@F_ExtensionNumber,@F_UserName,@F_DeptId,@F_RoleId,@F_GroupId,@F_SeatFlag,@F_SeatRight,@F_SeatLevel,@F_SexFlag,@F_RemindFlag,@F_Remark,@F_Telephone,@F_Mobile,@F_HomePhone,@F_Birthday,@F_CreateOn,@F_CancelOn,@F_DeleteFlag,@F_APPOnFlag,@F_LastActiveTime,@F_See,@F_HJType,@F_PId,@F_TmId,@F_WorkNumber,@F_DeptCode)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@F_UserCode", SqlDbType.VarChar,50), new SqlParameter("@F_Password", SqlDbType.VarChar,50), new SqlParameter("@F_ExtensionNumber", SqlDbType.VarChar,50), new SqlParameter("@F_UserName", SqlDbType.VarChar,50), new SqlParameter("@F_DeptId", SqlDbType.Int,4), new SqlParameter("@F_RoleId", SqlDbType.Int,4), new SqlParameter("@F_GroupId", SqlDbType.Int,4), new SqlParameter("@F_SeatFlag", SqlDbType.Bit,1), new SqlParameter("@F_SeatRight", SqlDbType.VarChar,50), new SqlParameter("@F_SeatLevel", SqlDbType.VarChar,50), new SqlParameter("@F_SexFlag", SqlDbType.VarChar,50), new SqlParameter("@F_RemindFlag", SqlDbType.Bit,1), new SqlParameter("@F_Remark", SqlDbType.VarChar,200), new SqlParameter("@F_Telephone", SqlDbType.VarChar,50), new SqlParameter("@F_Mobile", SqlDbType.VarChar,50), new SqlParameter("@F_HomePhone", SqlDbType.VarChar,50), new SqlParameter("@F_Birthday", SqlDbType.DateTime), new SqlParameter("@F_CreateOn", SqlDbType.DateTime), new SqlParameter("@F_CancelOn", SqlDbType.DateTime), new SqlParameter("@F_DeleteFlag", SqlDbType.SmallInt,2), new SqlParameter("@F_APPOnFlag", SqlDbType.Bit,1), new SqlParameter("@F_LastActiveTime", SqlDbType.DateTime), new SqlParameter("@F_See", SqlDbType.VarChar,100), new SqlParameter("@F_HJType", SqlDbType.Int,4), new SqlParameter("@F_PId", SqlDbType.Int,4), new SqlParameter("@F_TmId", SqlDbType.Int,4), new SqlParameter("@F_WorkNumber", SqlDbType.VarChar,15), new SqlParameter("@F_DeptCode", SqlDbType.VarChar,50)}; parameters[0].Value = model.F_UserCode; parameters[1].Value = model.F_Password; parameters[2].Value = model.F_ExtensionNumber; parameters[3].Value = model.F_UserName; parameters[4].Value = model.F_DeptId; parameters[5].Value = model.F_RoleId; parameters[6].Value = model.F_GroupId; parameters[7].Value = model.F_SeatFlag; parameters[8].Value = model.F_SeatRight; parameters[9].Value = model.F_SeatLevel; parameters[10].Value = model.F_SexFlag; parameters[11].Value = model.F_RemindFlag; parameters[12].Value = model.F_Remark; parameters[13].Value = model.F_Telephone; parameters[14].Value = model.F_Mobile; parameters[15].Value = model.F_HomePhone; parameters[16].Value = model.F_Birthday; parameters[17].Value = model.F_CreateOn; parameters[18].Value = model.F_CancelOn; parameters[19].Value = model.F_DeleteFlag; parameters[20].Value = model.F_APPOnFlag; parameters[21].Value = model.F_LastActiveTime; parameters[22].Value = model.F_See; parameters[23].Value = model.F_HJType; parameters[24].Value = model.F_PId; parameters[25].Value = model.F_TmId; parameters[26].Value = model.F_WorkNumber; parameters[27].Value = model.F_DeptCode; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } } /// /// 更新一条数据 /// public bool Update(YTSoft.BaseCallCenter.Model.T_Sys_UserAccount model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update T_Sys_UserAccount set "); strSql.Append("F_UserCode=@F_UserCode,"); strSql.Append("F_Password=@F_Password,"); strSql.Append("F_ExtensionNumber=@F_ExtensionNumber,"); strSql.Append("F_UserName=@F_UserName,"); strSql.Append("F_DeptId=@F_DeptId,"); strSql.Append("F_RoleId=@F_RoleId,"); strSql.Append("F_GroupId=@F_GroupId,"); strSql.Append("F_SeatFlag=@F_SeatFlag,"); strSql.Append("F_SeatRight=@F_SeatRight,"); strSql.Append("F_SeatLevel=@F_SeatLevel,"); strSql.Append("F_SexFlag=@F_SexFlag,"); strSql.Append("F_RemindFlag=@F_RemindFlag,"); strSql.Append("F_Remark=@F_Remark,"); strSql.Append("F_Telephone=@F_Telephone,"); strSql.Append("F_Mobile=@F_Mobile,"); strSql.Append("F_HomePhone=@F_HomePhone,"); strSql.Append("F_Birthday=@F_Birthday,"); strSql.Append("F_CreateOn=@F_CreateOn,"); strSql.Append("F_CancelOn=@F_CancelOn,"); strSql.Append("F_DeleteFlag=@F_DeleteFlag,"); strSql.Append("F_APPOnFlag=@F_APPOnFlag,"); strSql.Append("F_LastActiveTime=@F_LastActiveTime,"); strSql.Append("F_See=@F_See,"); strSql.Append("F_HJType=@F_HJType,"); strSql.Append("F_PId=@F_PId,"); strSql.Append("F_TmId=@F_TmId,"); strSql.Append("F_WorkNumber=@F_WorkNumber,"); strSql.Append("F_DeptCode=@F_DeptCode"); strSql.Append(" where F_UserId=@F_UserId"); SqlParameter[] parameters = { new SqlParameter("@F_UserCode", SqlDbType.VarChar,50), new SqlParameter("@F_Password", SqlDbType.VarChar,50), new SqlParameter("@F_ExtensionNumber", SqlDbType.VarChar,50), new SqlParameter("@F_UserName", SqlDbType.VarChar,50), new SqlParameter("@F_DeptId", SqlDbType.Int,4), new SqlParameter("@F_RoleId", SqlDbType.Int,4), new SqlParameter("@F_GroupId", SqlDbType.Int,4), new SqlParameter("@F_SeatFlag", SqlDbType.Bit,1), new SqlParameter("@F_SeatRight", SqlDbType.VarChar,50), new SqlParameter("@F_SeatLevel", SqlDbType.VarChar,50), new SqlParameter("@F_SexFlag", SqlDbType.VarChar,50), new SqlParameter("@F_RemindFlag", SqlDbType.Bit,1), new SqlParameter("@F_Remark", SqlDbType.VarChar,200), new SqlParameter("@F_Telephone", SqlDbType.VarChar,50), new SqlParameter("@F_Mobile", SqlDbType.VarChar,50), new SqlParameter("@F_HomePhone", SqlDbType.VarChar,50), new SqlParameter("@F_Birthday", SqlDbType.DateTime), new SqlParameter("@F_CreateOn", SqlDbType.DateTime), new SqlParameter("@F_CancelOn", SqlDbType.DateTime), new SqlParameter("@F_DeleteFlag", SqlDbType.SmallInt,2), new SqlParameter("@F_APPOnFlag", SqlDbType.Bit,1), new SqlParameter("@F_LastActiveTime", SqlDbType.DateTime), new SqlParameter("@F_See", SqlDbType.VarChar,100), new SqlParameter("@F_HJType", SqlDbType.Int,4), new SqlParameter("@F_PId", SqlDbType.Int,4), new SqlParameter("@F_TmId", SqlDbType.Int,4), new SqlParameter("@F_WorkNumber", SqlDbType.VarChar,15), new SqlParameter("@F_DeptCode", SqlDbType.VarChar,50), new SqlParameter("@F_UserId", SqlDbType.Int,4)}; parameters[0].Value = model.F_UserCode; parameters[1].Value = model.F_Password; parameters[2].Value = model.F_ExtensionNumber; parameters[3].Value = model.F_UserName; parameters[4].Value = model.F_DeptId; parameters[5].Value = model.F_RoleId; parameters[6].Value = model.F_GroupId; parameters[7].Value = model.F_SeatFlag; parameters[8].Value = model.F_SeatRight; parameters[9].Value = model.F_SeatLevel; parameters[10].Value = model.F_SexFlag; parameters[11].Value = model.F_RemindFlag; parameters[12].Value = model.F_Remark; parameters[13].Value = model.F_Telephone; parameters[14].Value = model.F_Mobile; parameters[15].Value = model.F_HomePhone; parameters[16].Value = model.F_Birthday; parameters[17].Value = model.F_CreateOn; parameters[18].Value = model.F_CancelOn; parameters[19].Value = model.F_DeleteFlag; parameters[20].Value = model.F_APPOnFlag; parameters[21].Value = model.F_LastActiveTime; parameters[22].Value = model.F_See; parameters[23].Value = model.F_HJType; parameters[24].Value = model.F_PId; parameters[25].Value = model.F_TmId; parameters[26].Value = model.F_WorkNumber; parameters[27].Value = model.F_DeptCode; parameters[28].Value = model.F_UserId; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } } /// /// 删除一条数据 /// public bool Delete(int F_UserId) { StringBuilder strSql=new StringBuilder(); strSql.Append("delete from T_Sys_UserAccount "); strSql.Append(" where F_UserId=@F_UserId"); SqlParameter[] parameters = { new SqlParameter("@F_UserId", SqlDbType.Int,4) }; parameters[0].Value = F_UserId; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } } /// /// 批量删除数据 /// public bool DeleteList(string F_UserIdlist ) { StringBuilder strSql=new StringBuilder(); strSql.Append("delete from T_Sys_UserAccount "); strSql.Append(" where F_UserId in ("+F_UserIdlist + ") "); int rows=DbHelperSQL.ExecuteSql(strSql.ToString()); if (rows > 0) { return true; } else { return false; } } /// /// 得到一个对象实体 /// public YTSoft.BaseCallCenter.Model.T_Sys_UserAccount GetModel(int F_UserId) { StringBuilder strSql=new StringBuilder(); strSql.Append(" select top 1 *,(SELECT F_RoleName FROM dbo.T_Sys_RoleInfo r WHERE r.F_RoleId=t.F_RoleId) AS roleName,(SELECT F_DeptName FROM dbo.T_Sys_Department d WHERE d.F_DeptId=t.F_DeptId) AS deptName from T_Sys_UserAccount t "); strSql.Append(" where t.F_UserId=@F_UserId"); SqlParameter[] parameters = { new SqlParameter("@F_UserId", SqlDbType.Int,4) }; parameters[0].Value = F_UserId; DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataTop1ToModel(ds.Tables[0].Rows[0]); } else { return null; } } /// /// 得到一个对象实体 /// public YTSoft.BaseCallCenter.Model.T_Sys_UserAccount GetModel(string Where) { StringBuilder strSql = new StringBuilder(); strSql.Append(" select top 1 *,(SELECT F_RoleName FROM dbo.T_Sys_RoleInfo r WHERE r.F_RoleId=t.F_RoleId) AS roleName,(SELECT F_DeptName FROM dbo.T_Sys_Department d WHERE d.F_DeptId=t.F_DeptId) AS deptName from T_Sys_UserAccount t "); strSql.Append(" where "); strSql.Append(Where); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return DataTop1ToModel(ds.Tables[0].Rows[0]); } else { return null; } } /// /// 得到一个对象实体 /// public YTSoft.BaseCallCenter.Model.T_Sys_UserAccount GetModelByUserCode(string userCode) { StringBuilder strSql = new StringBuilder(); strSql.Append(" select top 1 *,(SELECT F_RoleName FROM dbo.T_Sys_RoleInfo r WHERE r.F_RoleId=t.F_RoleId) AS roleName,(SELECT F_DeptName FROM dbo.T_Sys_Department d WHERE d.F_DeptId=t.F_DeptId) AS deptName from T_Sys_UserAccount t "); strSql.Append(" where t.F_UserCode=@F_UserCode"); SqlParameter[] parameters = { new SqlParameter("@F_UserCode", SqlDbType.NVarChar,50) }; parameters[0].Value = userCode; YTSoft.BaseCallCenter.Model.T_Sys_UserAccount model = new YTSoft.BaseCallCenter.Model.T_Sys_UserAccount(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataTop1ToModel(ds.Tables[0].Rows[0]); } else { return null; } } /// /// 得到一个对象实体 /// public YTSoft.BaseCallCenter.Model.T_Sys_UserAccount DataTop1ToModel(DataRow row) { YTSoft.BaseCallCenter.Model.T_Sys_UserAccount model=new YTSoft.BaseCallCenter.Model.T_Sys_UserAccount(); if (row != null) { if(row["F_UserId"]!=null && row["F_UserId"].ToString()!="") { model.F_UserId=int.Parse(row["F_UserId"].ToString()); } if(row["F_UserCode"]!=null) { model.F_UserCode=row["F_UserCode"].ToString(); } if(row["F_Password"]!=null) { model.F_Password=row["F_Password"].ToString(); } if(row["F_ExtensionNumber"]!=null) { model.F_ExtensionNumber=row["F_ExtensionNumber"].ToString(); } if(row["F_UserName"]!=null) { model.F_UserName=row["F_UserName"].ToString(); } if(row["F_DeptId"]!=null && row["F_DeptId"].ToString()!="") { model.F_DeptId=int.Parse(row["F_DeptId"].ToString()); } if(row["F_RoleId"]!=null && row["F_RoleId"].ToString()!="") { model.F_RoleId=int.Parse(row["F_RoleId"].ToString()); } if (row["roleName"] != null && row["roleName"].ToString() != "") { model.F_RoleName = row["roleName"].ToString(); } if (row["deptName"] != null && row["deptName"].ToString() != "") { model.F_DeptName = row["deptName"].ToString(); } if(row["F_GroupId"]!=null && row["F_GroupId"].ToString()!="") { model.F_GroupId=int.Parse(row["F_GroupId"].ToString()); } if(row["F_SeatFlag"]!=null && row["F_SeatFlag"].ToString()!="") { if((row["F_SeatFlag"].ToString()=="1")||(row["F_SeatFlag"].ToString().ToLower()=="true")) { model.F_SeatFlag=true; } else { model.F_SeatFlag=false; } } if(row["F_SeatRight"]!=null) { model.F_SeatRight=row["F_SeatRight"].ToString(); } if(row["F_SeatLevel"]!=null) { model.F_SeatLevel=row["F_SeatLevel"].ToString(); } if(row["F_SexFlag"]!=null) { model.F_SexFlag=row["F_SexFlag"].ToString(); } if(row["F_RemindFlag"]!=null && row["F_RemindFlag"].ToString()!="") { if((row["F_RemindFlag"].ToString()=="1")||(row["F_RemindFlag"].ToString().ToLower()=="true")) { model.F_RemindFlag=true; } else { model.F_RemindFlag=false; } } if(row["F_Remark"]!=null) { model.F_Remark=row["F_Remark"].ToString(); } if(row["F_Telephone"]!=null) { model.F_Telephone=row["F_Telephone"].ToString(); } if(row["F_Mobile"]!=null) { model.F_Mobile=row["F_Mobile"].ToString(); } if(row["F_HomePhone"]!=null) { model.F_HomePhone=row["F_HomePhone"].ToString(); } if(row["F_Birthday"]!=null && row["F_Birthday"].ToString()!="") { model.F_Birthday=DateTime.Parse(row["F_Birthday"].ToString()); } if(row["F_CreateOn"]!=null && row["F_CreateOn"].ToString()!="") { model.F_CreateOn=DateTime.Parse(row["F_CreateOn"].ToString()); } if(row["F_CancelOn"]!=null && row["F_CancelOn"].ToString()!="") { model.F_CancelOn=DateTime.Parse(row["F_CancelOn"].ToString()); } if(row["F_DeleteFlag"]!=null && row["F_DeleteFlag"].ToString()!="") { model.F_DeleteFlag=int.Parse(row["F_DeleteFlag"].ToString()); } if(row["F_APPOnFlag"]!=null && row["F_APPOnFlag"].ToString()!="") { if((row["F_APPOnFlag"].ToString()=="1")||(row["F_APPOnFlag"].ToString().ToLower()=="true")) { model.F_APPOnFlag=true; } else { model.F_APPOnFlag=false; } } if(row["F_LastActiveTime"]!=null && row["F_LastActiveTime"].ToString()!="") { model.F_LastActiveTime=DateTime.Parse(row["F_LastActiveTime"].ToString()); } if(row["F_See"]!=null) { model.F_See=row["F_See"].ToString(); } if(row["F_HJType"]!=null && row["F_HJType"].ToString()!="") { model.F_HJType=int.Parse(row["F_HJType"].ToString()); } if(row["F_PId"]!=null && row["F_PId"].ToString()!="") { model.F_PId=int.Parse(row["F_PId"].ToString()); } if(row["F_TmId"]!=null && row["F_TmId"].ToString()!="") { model.F_TmId=int.Parse(row["F_TmId"].ToString()); } if(row["F_WorkNumber"]!=null) { model.F_WorkNumber=row["F_WorkNumber"].ToString(); } if(row["F_DeptCode"]!=null) { model.F_DeptCode=row["F_DeptCode"].ToString(); } if (row["ExtensionCode"] != null) { model.ExtensionCode = row["ExtensionCode"].ToString(); } } return model; } /// /// 得到一个对象实体 /// public YTSoft.BaseCallCenter.Model.T_Sys_UserAccount DataRowToModel(DataRow row) { YTSoft.BaseCallCenter.Model.T_Sys_UserAccount model = new YTSoft.BaseCallCenter.Model.T_Sys_UserAccount(); if (row != null) { if (row["F_UserId"] != null && row["F_UserId"].ToString() != "") { model.F_UserId = int.Parse(row["F_UserId"].ToString()); } if (row["F_UserCode"] != null) { model.F_UserCode = row["F_UserCode"].ToString(); } if (row["F_Password"] != null) { model.F_Password = row["F_Password"].ToString(); } if (row["F_ExtensionNumber"] != null) { model.F_ExtensionNumber = row["F_ExtensionNumber"].ToString(); } if (row["F_UserName"] != null) { model.F_UserName = row["F_UserName"].ToString(); } if (row["F_DeptId"] != null && row["F_DeptId"].ToString() != "") { model.F_DeptId = int.Parse(row["F_DeptId"].ToString()); } if (row["F_RoleId"] != null && row["F_RoleId"].ToString() != "") { model.F_RoleId = int.Parse(row["F_RoleId"].ToString()); } if (row["F_GroupId"] != null && row["F_GroupId"].ToString() != "") { model.F_GroupId = int.Parse(row["F_GroupId"].ToString()); } if (row["F_SeatFlag"] != null && row["F_SeatFlag"].ToString() != "") { if ((row["F_SeatFlag"].ToString() == "1") || (row["F_SeatFlag"].ToString().ToLower() == "true")) { model.F_SeatFlag = true; } else { model.F_SeatFlag = false; } } if (row["F_SeatRight"] != null) { model.F_SeatRight = row["F_SeatRight"].ToString(); } if (row["F_SeatLevel"] != null) { model.F_SeatLevel = row["F_SeatLevel"].ToString(); } if (row["F_SexFlag"] != null) { model.F_SexFlag = row["F_SexFlag"].ToString(); } if (row["F_RemindFlag"] != null && row["F_RemindFlag"].ToString() != "") { if ((row["F_RemindFlag"].ToString() == "1") || (row["F_RemindFlag"].ToString().ToLower() == "true")) { model.F_RemindFlag = true; } else { model.F_RemindFlag = false; } } if (row["F_Remark"] != null) { model.F_Remark = row["F_Remark"].ToString(); } if (row["F_Telephone"] != null) { model.F_Telephone = row["F_Telephone"].ToString(); } if (row["F_Mobile"] != null) { model.F_Mobile = row["F_Mobile"].ToString(); } if (row["F_HomePhone"] != null) { model.F_HomePhone = row["F_HomePhone"].ToString(); } if (row["F_Birthday"] != null && row["F_Birthday"].ToString() != "") { model.F_Birthday = DateTime.Parse(row["F_Birthday"].ToString()); } if (row["F_CreateOn"] != null && row["F_CreateOn"].ToString() != "") { model.F_CreateOn = DateTime.Parse(row["F_CreateOn"].ToString()); } if (row["F_CancelOn"] != null && row["F_CancelOn"].ToString() != "") { model.F_CancelOn = DateTime.Parse(row["F_CancelOn"].ToString()); } if (row["F_DeleteFlag"] != null && row["F_DeleteFlag"].ToString() != "") { model.F_DeleteFlag = int.Parse(row["F_DeleteFlag"].ToString()); } if (row["F_APPOnFlag"] != null && row["F_APPOnFlag"].ToString() != "") { if ((row["F_APPOnFlag"].ToString() == "1") || (row["F_APPOnFlag"].ToString().ToLower() == "true")) { model.F_APPOnFlag = true; } else { model.F_APPOnFlag = false; } } if (row["F_LastActiveTime"] != null && row["F_LastActiveTime"].ToString() != "") { model.F_LastActiveTime = DateTime.Parse(row["F_LastActiveTime"].ToString()); } if (row["F_See"] != null) { model.F_See = row["F_See"].ToString(); } if (row["F_HJType"] != null && row["F_HJType"].ToString() != "") { model.F_HJType = int.Parse(row["F_HJType"].ToString()); } if (row["F_PId"] != null && row["F_PId"].ToString() != "") { model.F_PId = int.Parse(row["F_PId"].ToString()); } if (row["F_TmId"] != null && row["F_TmId"].ToString() != "") { model.F_TmId = int.Parse(row["F_TmId"].ToString()); } if (row["F_WorkNumber"] != null) { model.F_WorkNumber = row["F_WorkNumber"].ToString(); } if (row["F_DeptCode"] != null) { model.F_DeptCode = row["F_DeptCode"].ToString(); } if (row["ExtensionCode"] != null) { model.ExtensionCode = row["ExtensionCode"].ToString(); } } return model; } public YTSoft.BaseCallCenter.Model.T_Sys_UserAccount DataRowToModel1(DataRow row) { YTSoft.BaseCallCenter.Model.T_Sys_UserAccount model = new YTSoft.BaseCallCenter.Model.T_Sys_UserAccount(); if (row != null) { if (row["F_UserId"] != null && row["F_UserId"].ToString() != "") { model.F_UserId = int.Parse(row["F_UserId"].ToString()); } if (row["F_UserCode"] != null) { model.F_UserCode = row["F_UserCode"].ToString(); } if (row["F_UserName"] != null) { model.F_UserName = row["F_UserName"].ToString(); } if (row["F_GroupId"] != null && row["F_GroupId"].ToString() != "") { model.F_GroupId = int.Parse(row["F_GroupId"].ToString()); } } return model; } /// /// 获得数据列表 /// public DataSet GetList(string strWhere) { StringBuilder strSql=new StringBuilder(); strSql.Append("select F_UserId,F_UserCode,F_Password,F_ExtensionNumber,F_UserName,F_DeptId,F_RoleId,F_GroupId,F_SeatFlag,F_SeatRight,F_SeatLevel,F_SexFlag,F_RemindFlag,F_Remark,F_Telephone,F_Mobile,F_HomePhone,F_Birthday,F_CreateOn,F_CancelOn,F_DeleteFlag,F_APPOnFlag,F_LastActiveTime,F_See,F_HJType,F_PId,F_TmId,F_WorkNumber,F_DeptCode,ExtensionCode "); strSql.Append(" FROM T_Sys_UserAccount "); if(strWhere.Trim()!="") { strSql.Append(" where "+strWhere); } return DbHelperSQL.Query(strSql.ToString()); } /// /// 获得数据列表 /// public DataSet GetList(string userName,string passWord) { StringBuilder strSql = new StringBuilder(); strSql.Append("select F_UserId,F_UserCode,F_Password,F_ExtensionNumber,F_UserName,F_DeptId,F_RoleId,F_GroupId,F_SeatFlag,F_SeatRight,F_SeatLevel,F_SexFlag,F_RemindFlag,F_Remark,F_Telephone,F_Mobile,F_HomePhone,F_Birthday,F_CreateOn,F_CancelOn,F_DeleteFlag,F_APPOnFlag,F_LastActiveTime,F_See,F_HJType,F_PId,F_TmId,F_WorkNumber,F_DeptCode,ExtensionCode "); strSql.Append(" FROM T_Sys_UserAccount "); strSql.Append(" where F_UserCode=@F_UserCode"); strSql.Append(" and F_PassWord=@F_PassWord"); SqlParameter[] parameters = { new SqlParameter("@F_UserCode", SqlDbType.NVarChar,500), new SqlParameter("@F_PassWord", SqlDbType.NVarChar,500) }; parameters[0].Value = userName; parameters[1].Value = passWord; return DbHelperSQL.Query(strSql.ToString(), parameters); } public DataSet GetListView(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" FROM V_UserAccount "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return DbHelperSQL.Query(strSql.ToString()); } /// /// 获得前几行数据 /// 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(" F_UserId,F_UserCode,F_Password,F_ExtensionNumber,F_UserName,F_DeptId,F_RoleId,F_GroupId,F_SeatFlag,F_SeatRight,F_SeatLevel,F_SexFlag,F_RemindFlag,F_Remark,F_Telephone,F_Mobile,F_HomePhone,F_Birthday,F_CreateOn,F_CancelOn,F_DeleteFlag,F_APPOnFlag,F_LastActiveTime,F_See,F_HJType,F_PId,F_TmId,F_WorkNumber,F_DeptCode,ExtensionCode"); strSql.Append(" FROM T_Sys_UserAccount "); if(strWhere.Trim()!="") { strSql.Append(" where "+strWhere); } strSql.Append(" order by " + filedOrder); return DbHelperSQL.Query(strSql.ToString()); } /// /// 获取记录总数 /// public int GetRecordCount(string strWhere) { StringBuilder strSql=new StringBuilder(); strSql.Append("select count(1) FROM T_Sys_UserAccount "); if(strWhere.Trim()!="") { strSql.Append(" where "+strWhere); } object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } } /// /// 分页获取数据列表 /// public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex) { StringBuilder strSql=new StringBuilder(); strSql.Append("SELECT * FROM ( "); strSql.Append(" SELECT ROW_NUMBER() OVER ("); if (!string.IsNullOrEmpty(orderby.Trim())) { strSql.Append("order by T." + orderby ); } else { strSql.Append("order by T.F_UserId desc"); } strSql.Append(")AS Row, T.* from T_Sys_UserAccount T "); if (!string.IsNullOrEmpty(strWhere.Trim())) { strSql.Append(" WHERE " + strWhere); } strSql.Append(" ) TT"); strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex); return DbHelperSQL.Query(strSql.ToString()); } public bool UpdateWXId(string collName,int keyID,int userId) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Sys_UserAccount set "); strSql.Append(collName+"="+keyID); strSql.Append(" where F_UserId=" + userId); int rows = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rows > 0) { return true; } else { return false; } } #endregion BasicMethod #region ExtensionMethod #endregion ExtensionMethod } }