/// <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; } }