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