/// <summary>
/// 得到一个对象实体
/// </summary>
public FYSOFT.HMIS.Models.User GetModel(String UserID)
{
FYSOFT.HMIS.Models.User model = new FYSOFT.HMIS.Models.User();
DataSet ds = DbHelperOLE.Query(UserSQLS.Select1String(UserID));
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["userid"] != null && ds.Tables[0].Rows[0]["userid"].ToString() != "")
{
model.UserID = 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();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <FYSOFT.HMIS.Models.User> DataTableToList(DataTable dt)
{
List <FYSOFT.HMIS.Models.User> modelList = new List <FYSOFT.HMIS.Models.User>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
FYSOFT.HMIS.Models.User model;
for (int n = 0; n < rowsCount; n++)
{
model = new FYSOFT.HMIS.Models.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);
}
public bool Update(string strModel, string WSPassword)
{
if (!WSHelper.CheckPassword(WSPassword))
{
throw new Exception("未授权使用服务！");
}
FYSOFT.HMIS.Models.User model = Common.CommonHelper.DeSerialize(typeof(FYSOFT.HMIS.Models.User), strModel) as FYSOFT.HMIS.Models.User;
return(bllUser.Update(model));
}
/// <summary>
/// 根据实体生成更新语句
/// </summary>
/// <param name="UObject"></param>
/// <returns></returns>
public static String UpdateString(FYSOFT.HMIS.Models.User UObject)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE T_USER SET ");
strSql.AppendFormat("USERNAME='******',", UObject.UserName);
strSql.AppendFormat("USERPASSWORD='******'", UObject.UserPassword);
strSql.AppendFormat(" WHERE USERID='{0}'", UObject.UserID);
return(strSql.ToString());
}
/// <summary>
/// 根据实体生成插入语句
/// </summary>
/// <param name="UObject"></param>
/// <returns></returns>
public static String InsertString(FYSOFT.HMIS.Models.User UObject)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO T_USER(");
strSql.Append("USERID,USERNAME,USERPASSWORD)");
strSql.Append(" VALUES (");
strSql.AppendFormat("'{0}','{1}','{2}')", Guid.NewGuid().ToString(), UObject.UserName, UObject.UserPassword);
return(strSql.ToString());
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FYSOFT.HMIS.Models.User model)
{
int rows = DbHelperOLE.ExecuteSql(UserSQLS.UpdateString(model));
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FYSOFT.HMIS.Models.User model)
{
object obj = DbHelperOLE.ExecuteSql(UserSQLS.InsertString(model));
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(FYSOFT.HMIS.Models.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 = UfidaPMSService.InvokeWebService(WsFullURL, "Update", args);
return((bool)oResult);
}
}
catch (Exception ex)
{
throw ex;
}
}
