/// <summary> /// 更新一条数据 /// </summary> public bool Update(电子族谱管理系统.Model.Genaration model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [Genaration] set "); strSql.Append("[Gen_name]=@Gen_name, [Gen_red]=@Gen_red, [Gen_tag]=@Gen_tag, [Gen_char]=@Gen_char, [Gen_big]=@Gen_big "); strSql.Append(" where Gen_id=@Gen_id "); MSSQLHelper h = new MSSQLHelper(); h.CreateCommand(strSql.ToString()); if (model.Gen_id == null) { h.AddParameter("@Gen_id", DBNull.Value); } else { h.AddParameter("@Gen_id", model.Gen_id); } if (model.Gen_name == null) { h.AddParameter("@Gen_name", DBNull.Value); } else { h.AddParameter("@Gen_name", model.Gen_name); } if (model.Gen_red == null) { h.AddParameter("@Gen_red", DBNull.Value); } else { h.AddParameter("@Gen_red", model.Gen_red); } if (model.Gen_tag == null) { h.AddParameter("@Gen_tag", DBNull.Value); } else { h.AddParameter("@Gen_tag", model.Gen_tag); } if (model.Gen_char == null) { h.AddParameter("@Gen_char", DBNull.Value); } else { h.AddParameter("@Gen_char", model.Gen_char); } if (model.Gen_big == null) { h.AddParameter("@Gen_big", DBNull.Value); } else { h.AddParameter("@Gen_big", model.Gen_big); } return(h.ExecuteNonQuery()); }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int keyId) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from [User] "); strSql.Append(" where User_id=@User_id "); MSSQLHelper h = new MSSQLHelper(); h.CreateCommand(strSql.ToString()); h.AddParameter("@User_id", keyId); return(h.ExecuteNonQuery()); }
/// <summary> /// 计算记录数 /// </summary> /// <param name="p"></param> /// <returns></returns> public int CalcCount(string cond) { string sql = "select count(1) from [User]"; if (!string.IsNullOrEmpty(cond)) { sql += " where " + cond; } MSSQLHelper h = new MSSQLHelper(); h.CreateCommand(sql); return(int.Parse(h.ExecuteScalar())); }
/// <summary> /// 取一个字段的值 /// </summary> /// <param name="filed">字段,如sum(je)</param> /// <param name="cond">条件,如userid=2</param> /// <returns></returns> public string GetOneFiled(string filed, string cond) { string sql = "select " + filed + " from [User]"; if (!string.IsNullOrEmpty(cond)) { sql += " where " + cond; } MSSQLHelper h = new MSSQLHelper(); h.CreateCommand(sql); return(h.ExecuteScalar()); }
/// <summary> /// 根据条件删除数据 /// </summary> public bool DeleteByCond(string cond) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from [User] "); if (!string.IsNullOrEmpty(cond)) { strSql.Append(" where " + cond); } MSSQLHelper h = new MSSQLHelper(); h.CreateCommand(strSql.ToString()); return(h.ExecuteNonQuery()); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" FROM [User] "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } MSSQLHelper h = new MSSQLHelper(); h.CreateCommand(strSql.ToString()); DataTable dt = h.ExecuteQuery(); DataSet ds = new DataSet(); ds.Tables.Add(dt); return(ds); }
/// <summary> /// 得到一个对象实体 /// </summary> public 电子族谱管理系统.Model.User GetModel(int keyId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from [User] "); strSql.Append(" where User_id=@User_id "); MSSQLHelper h = new MSSQLHelper(); h.CreateCommand(strSql.ToString()); h.AddParameter("@User_id", keyId); 电子族谱管理系统.Model.User model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary> /// 根据条件得到一个对象实体 /// </summary> public 电子族谱管理系统.Model.User GetModelByCond(string cond) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from [User] "); if (!string.IsNullOrEmpty(cond)) { strSql.Append(" where " + cond); } MSSQLHelper h = new MSSQLHelper(); h.CreateCommand(strSql.ToString()); 电子族谱管理系统.Model.User model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary> /// 获得数据列表(比DataSet效率高,推荐使用) /// </summary> public List <电子族谱管理系统.Model.User> GetListArray(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" FROM [User] "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } List <电子族谱管理系统.Model.User> list = new List <电子族谱管理系统.Model.User>(); MSSQLHelper h = new MSSQLHelper(); h.CreateCommand(strSql.ToString()); using (IDataReader dataReader = h.ExecuteReader()) { while (dataReader.Read()) { list.Add(ReaderBind(dataReader)); } h.CloseConn(); } return(list); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(电子族谱管理系统.Model.User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [User]("); strSql.Append("[User_name], [User_pwd], [User_sex], [User_birth], [User_death], [User_wid], [User_fid], [User_no], [Gen_id] )"); strSql.Append(" values ("); strSql.Append("@User_name, @User_pwd, @User_sex, @User_birth, @User_death, @User_wid, @User_fid, @User_no, @Gen_id )"); strSql.Append(";select @@IDENTITY"); MSSQLHelper h = new MSSQLHelper(); h.CreateCommand(strSql.ToString()); if (model.User_name == null) { h.AddParameter("@User_name", DBNull.Value); } else { h.AddParameter("@User_name", model.User_name); } if (model.User_pwd == null) { h.AddParameter("@User_pwd", DBNull.Value); } else { h.AddParameter("@User_pwd", model.User_pwd); } if (model.User_sex == null) { h.AddParameter("@User_sex", DBNull.Value); } else { h.AddParameter("@User_sex", model.User_sex); } if (model.User_birth == null) { h.AddParameter("@User_birth", DateTime.Now); } else { h.AddParameter("@User_birth", model.User_birth); } if (model.User_death == null) { h.AddParameter("@User_death", DateTime.Now); } else { h.AddParameter("@User_death", model.User_death); } if (model.User_wid == null) { h.AddParameter("@User_wid", DBNull.Value); } else { h.AddParameter("@User_wid", model.User_wid); } if (model.User_fid == null) { h.AddParameter("@User_fid", DBNull.Value); } else { h.AddParameter("@User_fid", model.User_fid); } if (model.User_no == null) { h.AddParameter("@User_no", DBNull.Value); } else { h.AddParameter("@User_no", model.User_no); } if (model.Gen_id == null) { h.AddParameter("@Gen_id", DBNull.Value); } else { h.AddParameter("@Gen_id", model.Gen_id); } int result; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out result)) { return(0); } return(result); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(电子族谱管理系统.Model.User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [User] set "); strSql.Append("[User_name]=@User_name, [User_pwd]=@User_pwd, [User_sex]=@User_sex, [User_birth]=@User_birth, [User_death]=@User_death, [User_wid]=@User_wid, [User_fid]=@User_fid, [User_no]=@User_no, [Gen_id]=@Gen_id "); strSql.Append(" where User_id=@User_id "); MSSQLHelper h = new MSSQLHelper(); h.CreateCommand(strSql.ToString()); if (model.User_id == null) { h.AddParameter("@User_id", DBNull.Value); } else { h.AddParameter("@User_id", model.User_id); } if (model.User_name == null) { h.AddParameter("@User_name", DBNull.Value); } else { h.AddParameter("@User_name", model.User_name); } if (model.User_pwd == null) { h.AddParameter("@User_pwd", DBNull.Value); } else { h.AddParameter("@User_pwd", model.User_pwd); } if (model.User_sex == null) { h.AddParameter("@User_sex", DBNull.Value); } else { h.AddParameter("@User_sex", model.User_sex); } if (model.User_birth == null) { h.AddParameter("@User_birth", DBNull.Value); } else { h.AddParameter("@User_birth", model.User_birth); } if (model.User_death == null) { h.AddParameter("@User_death", DBNull.Value); } else { h.AddParameter("@User_death", model.User_death); } if (model.User_wid == null) { h.AddParameter("@User_wid", DBNull.Value); } else { h.AddParameter("@User_wid", model.User_wid); } if (model.User_fid == null) { h.AddParameter("@User_fid", DBNull.Value); } else { h.AddParameter("@User_fid", model.User_fid); } if (model.User_no == null) { h.AddParameter("@User_no", DBNull.Value); } else { h.AddParameter("@User_no", model.User_no); } if (model.Gen_id == null) { h.AddParameter("@Gen_id", DBNull.Value); } else { h.AddParameter("@Gen_id", model.Gen_id); } return(h.ExecuteNonQuery()); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(电子族谱管理系统.Model.Genaration model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [Genaration]("); strSql.Append("[Gen_id], [Gen_name], [Gen_red], [Gen_tag], [Gen_char], [Gen_big] )"); strSql.Append(" values ("); strSql.Append("@Gen_id, @Gen_name, @Gen_red, @Gen_tag, @Gen_char, @Gen_big )"); strSql.Append(";select @@IDENTITY"); MSSQLHelper h = new MSSQLHelper(); h.CreateCommand(strSql.ToString()); if (model.Gen_id == null) { h.AddParameter("@Gen_id", DBNull.Value); } else { h.AddParameter("@Gen_id", model.Gen_id); } if (model.Gen_name == null) { h.AddParameter("@Gen_name", DBNull.Value); } else { h.AddParameter("@Gen_name", model.Gen_name); } if (model.Gen_red == null) { h.AddParameter("@Gen_red", DBNull.Value); } else { h.AddParameter("@Gen_red", model.Gen_red); } if (model.Gen_tag == null) { h.AddParameter("@Gen_tag", DBNull.Value); } else { h.AddParameter("@Gen_tag", model.Gen_tag); } if (model.Gen_char == null) { h.AddParameter("@Gen_char", DBNull.Value); } else { h.AddParameter("@Gen_char", model.Gen_char); } if (model.Gen_big == null) { h.AddParameter("@Gen_big", DBNull.Value); } else { h.AddParameter("@Gen_big", model.Gen_big); } int result; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out result)) { return(0); } return(result); }