/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.InfoType model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into InfoType("); strSql.Append("IName,SPID,AttaID,SortNum,Status)"); strSql.Append(" values ("); strSql.Append("@IName,@SPID,@AttaID,@SortNum,@Status)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "IName", DbType.String, model.IName); db.AddInParameter(dbCommand, "SPID", DbType.Int32, model.SPID); db.AddInParameter(dbCommand, "AttaID", DbType.String, model.AttaID); db.AddInParameter(dbCommand, "SortNum", DbType.Int32, model.SortNum); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.InfoType GetModel(string strWhere, List <SqlParameter> parameters) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from InfoType "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); if (parameters.Count > 0) { foreach (SqlParameter sqlParameter in parameters) { dbCommand.Parameters.Add(sqlParameter); } } Model.InfoType model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 对象实体绑定数据 /// </summary> public Model.InfoType ReaderBind(IDataReader dataReader) { Model.InfoType model = new Model.InfoType(); object ojb; ojb = dataReader["ITID"]; if (ojb != null && ojb != DBNull.Value) { model.ITID = Convert.ToInt32(ojb); } model.IName = dataReader["IName"].ToString(); ojb = dataReader["SPID"]; if (ojb != null && ojb != DBNull.Value) { model.SPID = Convert.ToInt32(ojb); } model.AttaID = dataReader["AttaID"].ToString(); ojb = dataReader["SortNum"]; if (ojb != null && ojb != DBNull.Value) { model.SortNum = Convert.ToInt32(ojb); } ojb = dataReader["Status"]; if (ojb != null && ojb != DBNull.Value) { model.Status = Convert.ToInt32(ojb); } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.InfoType DataRowToModel(DataRow row) { Model.InfoType model = new Model.InfoType(); if (row != null) { if (row["ITID"] != null && row["ITID"].ToString() != "") { model.ITID = Convert.ToInt32(row["ITID"].ToString()); } if (row["IName"] != null) { model.IName = row["IName"].ToString(); } if (row["SPID"] != null && row["SPID"].ToString() != "") { model.SPID = Convert.ToInt32(row["SPID"].ToString()); } if (row["AttaID"] != null) { model.AttaID = row["AttaID"].ToString(); } if (row["SortNum"] != null && row["SortNum"].ToString() != "") { model.SortNum = Convert.ToInt32(row["SortNum"].ToString()); } if (row["Status"] != null && row["Status"].ToString() != "") { model.Status = Convert.ToInt32(row["Status"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.InfoType model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update InfoType set "); strSql.Append("IName=@IName,"); strSql.Append("SPID=@SPID,"); strSql.Append("AttaID=@AttaID,"); strSql.Append("SortNum=@SortNum,"); strSql.Append("Status=@Status"); strSql.Append(" where ITID=@ITID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ITID", DbType.Int32, model.ITID); db.AddInParameter(dbCommand, "IName", DbType.String, model.IName); db.AddInParameter(dbCommand, "SPID", DbType.Int32, model.SPID); db.AddInParameter(dbCommand, "AttaID", DbType.String, model.AttaID); db.AddInParameter(dbCommand, "SortNum", DbType.Int32, model.SortNum); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); int rows = db.ExecuteNonQuery(dbCommand); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.InfoType GetModel(int ITID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ITID,IName,SPID,AttaID,SortNum,Status from InfoType "); strSql.Append(" where ITID=@ITID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ITID", DbType.Int32, ITID); Model.InfoType model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
public bool DelPackType(Model.InfoType model) { Database db = DatabaseFactory.CreateDatabase(); bool result = false; using (DbConnection conn = db.CreateConnection()) { conn.Open(); DbTransaction trans = conn.BeginTransaction(); try { #region 除分类及资讯 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from AdInfos where "); strSql.Append( " Inf_IID in(select IID from dbo.Infos where TIID in (select TIID from dbo.TempInfo where ITID=@ITID )); "); strSql.Append("delete from InfoLabel where "); strSql.Append( " IID in(select IID from dbo.Infos where TIID in (select TIID from dbo.TempInfo where ITID=@ITID )); "); strSql.Append("delete from AttaList where "); strSql.Append( " IID in(select IID from dbo.Infos where TIID in (select TIID from dbo.TempInfo where ITID=@ITID )); "); //strSql.Append(" delete from TmpInfoList where TIID in (select TIID from dbo.TempInfo where ITID=@ITID );"); strSql.Append(" delete from Infos where TIID in (select TIID from dbo.TempInfo where ITID=@ITID );"); strSql.Append(" delete from TempInfo where ITID=@ITID;"); strSql.Append(" delete from InfoType where ITID=@ITID;"); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ITID", DbType.Int32, model.ITID); object obj = db.ExecuteNonQuery(dbCommand, trans); #endregion StringBuilder strSql3 = new StringBuilder(); strSql3.Append("select * from InfoType where SPID=" + model.SPID + " and SortNum>" + model.SortNum); DbCommand dbCommandDel = db.GetSqlStringCommand(strSql3.ToString()); var dt = db.ExecuteDataSet(dbCommandDel, trans).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { var sql = "update InfoType set SortNum=SortNum-1 where ITID=" + dt.Rows[i]["ITID"]; DbCommand dbCommand2 = db.GetSqlStringCommand(sql.ToString()); db.ExecuteNonQuery(dbCommand2, trans); } } trans.Commit(); result = true; } catch { trans.Rollback(); } conn.Close(); return(result); } }
public bool DelPackType(Model.InfoType model) { Database db = DatabaseFactory.CreateDatabase(); bool result = false; using (DbConnection conn = db.CreateConnection()) { conn.Open(); DbTransaction trans = conn.BeginTransaction(); try { #region 除分类及资讯 #region var AttaList = new StringBuilder(); AttaList.Append(" select * from AttaList where "); AttaList.Append( " IID in(select IID from dbo.Infos where TIID in (select TIID from dbo.TempInfo where ITID=" + model.ITID + " )); "); DbCommand dbComAttList = db.GetSqlStringCommand(AttaList.ToString()); var dtAttList = db.ExecuteDataSet(dbComAttList, trans).Tables[0]; var Infos = new StringBuilder(); Infos.Append(" select * from Infos where TIID in (select TIID from dbo.TempInfo where ITID=" + model.ITID + " );"); DbCommand dbComInfos = db.GetSqlStringCommand(Infos.ToString()); var dtInfos = db.ExecuteDataSet(dbComInfos, trans).Tables[0]; var TempInfo = new StringBuilder(); TempInfo.Append(" select * from TempInfo where ITID=" + model.ITID + " "); DbCommand dbComTempInfo = db.GetSqlStringCommand(TempInfo.ToString()); var dtTempInfo = db.ExecuteDataSet(dbComTempInfo, trans).Tables[0]; #endregion StringBuilder strSql = new StringBuilder(); strSql.Append("delete from AdInfos where "); strSql.Append( " Inf_IID in(select IID from dbo.Infos where TIID in (select TIID from dbo.TempInfo where ITID=@ITID )); "); strSql.Append("delete from InfoLabel where "); strSql.Append( " IID in(select IID from dbo.Infos where TIID in (select TIID from dbo.TempInfo where ITID=@ITID )); "); strSql.Append("delete from AttaList where "); strSql.Append( " IID in(select IID from dbo.Infos where TIID in (select TIID from dbo.TempInfo where ITID=@ITID )); "); //strSql.Append(" delete from TmpInfoList where TIID in (select TIID from dbo.TempInfo where ITID=@ITID );"); strSql.Append(" delete from Infos where TIID in (select TIID from dbo.TempInfo where ITID=@ITID );"); strSql.Append(" delete from TempInfo where ITID=@ITID;"); strSql.Append(" delete from InfoType where ITID=@ITID;"); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ITID", DbType.Int32, model.ITID); object obj = db.ExecuteNonQuery(dbCommand, trans); #endregion StringBuilder strSql3 = new StringBuilder(); strSql3.Append("select * from InfoType where SPID=" + model.SPID + " and SortNum>" + model.SortNum); DbCommand dbCommandDel = db.GetSqlStringCommand(strSql3.ToString()); var dt = db.ExecuteDataSet(dbCommandDel, trans).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { var sql = "update InfoType set SortNum=SortNum-1 where ITID=" + dt.Rows[i]["ITID"]; DbCommand dbCommand2 = db.GetSqlStringCommand(sql.ToString()); db.ExecuteNonQuery(dbCommand2, trans); } } trans.Commit(); #region delete files if (dtAttList.Rows.Count > 0) { for (int i = 0; i < dtAttList.Rows.Count; i++) { try { var oldbpic = new FileInfo( HttpContext.Current.Server.MapPath("/UploadFiles/" + dtAttList.Rows[i]["AttID"])); if (!string.IsNullOrEmpty(dtAttList.Rows[i]["AttID"].ToString()) && oldbpic.Exists) { oldbpic.Delete(); } } catch (Exception) { } } } if (dtInfos.Rows.Count > 0) { for (int i = 0; i < dtInfos.Rows.Count; i++) { try { var oldbpic = new FileInfo( HttpContext.Current.Server.MapPath("/UploadFiles/" + dtInfos.Rows[i]["PicAttID"])); if (!string.IsNullOrEmpty(dtInfos.Rows[i]["PicAttID"].ToString()) && oldbpic.Exists) { oldbpic.Delete(); } } catch (Exception) { } try { var oldbpic1 = new FileInfo( HttpContext.Current.Server.MapPath("/UploadFiles/" + dtInfos.Rows[i]["VideoAttID"])); if (!string.IsNullOrEmpty(dtInfos.Rows[i]["VideoAttID"].ToString()) && oldbpic1.Exists) { oldbpic1.Delete(); } } catch (Exception) { } try { var oldbpic2 = new FileInfo( HttpContext.Current.Server.MapPath("/UploadFiles/" + dtInfos.Rows[i]["ADPic"])); if (!string.IsNullOrEmpty(dtInfos.Rows[i]["ADPic"].ToString()) && oldbpic2.Exists) { oldbpic2.Delete(); } } catch (Exception) { } } } if (dtTempInfo.Rows.Count > 0) { for (int i = 0; i < dtTempInfo.Rows.Count; i++) { try { var oldbpic = new FileInfo( HttpContext.Current.Server.MapPath("/UploadFiles/" + dtTempInfo.Rows[i]["AttID"])); if (!string.IsNullOrEmpty(dtTempInfo.Rows[i]["AttID"].ToString()) && oldbpic.Exists) { oldbpic.Delete(); } } catch (Exception) { } } } #endregion result = true; } catch { trans.Rollback(); } conn.Close(); return(result); } }