/// <summary>
/// 获得数据列表
/// </summary>
public List <BES.Entities.User> DataTableToList(DataTable dt)
{
List <BES.Entities.User> modelList = new List <BES.Entities.User>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
BES.Entities.User model;
for (int n = 0; n < rowsCount; n++)
{
model = new BES.Entities.User();
if (dt.Rows[n]["userid"] != null && dt.Rows[n]["userid"].ToString() != "")
{
model.UserID = int.Parse(dt.Rows[n]["userid"].ToString());
}
if (dt.Rows[n]["username"] != null && dt.Rows[n]["username"].ToString() != "")
{
model.UserName = dt.Rows[n]["username"].ToString();
}
if (dt.Rows[n]["userpassword"] != null && dt.Rows[n]["userpassword"].ToString() != "")
{
model.UserPassword = dt.Rows[n]["userpassword"].ToString();
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BES.Entities.User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_User set ");
strSql.Append("username=@username,");
strSql.Append("userpassword=@userpassword,");
strSql.Append("usertype=@usertype,");
strSql.Append("companycode=@companycode");
strSql.Append(" where userid=@userid");
SqlParameter[] parameters =
{
new SqlParameter("@username", SqlDbType.VarChar, 20),
new SqlParameter("@userpassword", SqlDbType.VarChar, 20),
new SqlParameter("@usertype", SqlDbType.Int, 4),
new SqlParameter("@userid", SqlDbType.Int, 4),
new SqlParameter("@companycode", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.UserPassword;
parameters[2].Value = model.UserType;
parameters[3].Value = model.UserID;
parameters[4].Value = model.UserCompanyCode;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public EditUser(int UserId, DataTable DtCompany)
{
InitializeComponent();
this.DTCompany = DtCompany;
try
{
BES.Entities.User u = WSAL.WSUser.GetModel(UserId);
tbUserName.Text = u.UserName;
tbUserName.ReadOnly = true;
tbPassWord.Text = u.UserPassword;
try
{
cbType.SelectedIndex = u.UserType;
}
catch
{
cbType.SelectedIndex = 0;
}
try
{
cbCompany.SelectedValue = u.UserCompanyCode;
}
catch
{
cbType.SelectedIndex = 0;
}
this.userid = UserId;
}
catch
{
this.Dispose();
}
}
/// <summary>
/// 获取对象模型
/// </summary>
/// <returns></returns>
private BES.Entities.User GetModel()
{
BES.Entities.User model = new BES.Entities.User();
model.UserName = tbUserName.Text;
model.UserPassword = tbUserPassword.Text;
model.UserType = cbType.SelectedIndex;
model.UserCompanyCode = cbCompany.SelectedValue.ToString();
return(model);
}
public bool Update(string strModel, string WSPassword)
{
if (!WSHelper.CheckPassword(WSPassword))
{
throw new Exception("未授权使用服务！");
}
BES.Entities.User model = Common.CommonHelper.DeSerialize(typeof(BES.Entities.User), strModel) as BES.Entities.User;
return(bllUser.Update(model));
}
/// <summary>
/// 通过用户名得到一个对象实体
/// </summary>
public BES.Entities.User GetModelByName(String UserName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 userid,username,userpassword, case usertype when 1 then '管理员' else '出版公司' end as utype,usertype,companycode,COMPANY.SHORTNAME from t_User left join COMPANY on t_User.companycode=COMPANY.CODE");
strSql.Append(" where username=@username");
SqlParameter[] parameters =
{
new SqlParameter("@username", SqlDbType.VarChar, 50)
};
parameters[0].Value = UserName;
BES.Entities.User model = new BES.Entities.User();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["userid"] != null && ds.Tables[0].Rows[0]["userid"].ToString() != "")
{
model.UserID = int.Parse(ds.Tables[0].Rows[0]["userid"].ToString());
}
if (ds.Tables[0].Rows[0]["username"] != null && ds.Tables[0].Rows[0]["username"].ToString() != "")
{
model.UserName = ds.Tables[0].Rows[0]["username"].ToString();
}
if (ds.Tables[0].Rows[0]["userpassword"] != null && ds.Tables[0].Rows[0]["userpassword"].ToString() != "")
{
model.UserPassword = ds.Tables[0].Rows[0]["userpassword"].ToString();
}
if (ds.Tables[0].Rows[0]["utype"] != null && ds.Tables[0].Rows[0]["utype"].ToString() != "")
{
model.UserTypeName = ds.Tables[0].Rows[0]["utype"].ToString();
}
if (ds.Tables[0].Rows[0]["usertype"] != null && ds.Tables[0].Rows[0]["usertype"].ToString() != "")
{
model.UserType = int.Parse(ds.Tables[0].Rows[0]["usertype"].ToString());
}
else
{
model.UserType = 0;
}
if (ds.Tables[0].Rows[0]["companycode"] != null && ds.Tables[0].Rows[0]["companycode"].ToString() != "")
{
model.UserCompanyCode = ds.Tables[0].Rows[0]["companycode"].ToString();
}
if (ds.Tables[0].Rows[0]["SHORTNAME"] != null && ds.Tables[0].Rows[0]["SHORTNAME"].ToString() != "")
{
model.UserCompanyName = ds.Tables[0].Rows[0]["SHORTNAME"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(BES.Entities.User model)
{
try
{
if (WSInfo.WsURL.Trim() == "")
{
throw new Exception("服务地址配置错误！");
}
else
{
string WsFullURL = WSInfo.WsURL + "UserService.asmx";
string[] args = new string[2];
args[0] = CommonHelper.Serialize(model);
args[1] = WSInfo.SPassword;
object oResult = BESService.InvokeWebService(WsFullURL, "Update", args);
return((bool)oResult);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BES.Entities.User model)
{
if (!CheckUserName(model.UserName))
{
return(0);
}
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_User(");
strSql.Append("username,userpassword,usertype,companycode)");
strSql.Append(" values (");
strSql.Append("@username,@userpassword,@usertype,@companycode)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@username", SqlDbType.VarChar, 20),
new SqlParameter("@userpassword", SqlDbType.VarChar, 20),
new SqlParameter("@usertype", SqlDbType.Int, 4),
new SqlParameter("@companycode", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.UserPassword;
parameters[2].Value = model.UserType;
parameters[3].Value = model.UserCompanyCode;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
