/// <summary> /// 根据实体生成更新语句 /// </summary> /// <param name="UObject"></param> /// <returns></returns> public static String UpdateString(FYSOFT.HMIS.Models.Dictionary UObject) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE T_DICTIONARY SET "); strSql.AppendFormat("DICTIONARYVALUE='{0}',", UObject.DictionaryValue); strSql.AppendFormat("DICTIONARYNAME='{0}'", UObject.DictionaryName); strSql.AppendFormat(" WHERE DICTIONARYID='{0}'", UObject.DictionaryID); return(strSql.ToString()); }
/// <summary> /// 根据实体生成插入语句 /// </summary> /// <param name="UObject"></param> /// <returns></returns> public static String InsertString(FYSOFT.HMIS.Models.Dictionary UObject) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO T_DICTIONARY("); strSql.Append("DICTIONARYID,DICTIONARYVALUE,DICTIONARYNAME)"); strSql.Append(" VALUES ("); strSql.AppendFormat("'{0}','{1}','{2}')", Guid.NewGuid().ToString(), UObject.DictionaryValue, UObject.DictionaryName); return(strSql.ToString()); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(FYSOFT.HMIS.Models.Dictionary model) { object obj = DbHelperOLE.ExecuteSql(DictionarySQLS.InsertString(model)); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }