protected void SchemaSeri(AttaList _attaListDal, ECommerce.Admin.Model.Infos infomodel, string adpause) { StringBuilder strSqlAddLab = new StringBuilder(); strSqlAddLab.Append("insert into InfoLabel("); strSqlAddLab.Append("IID,ALID)"); strSqlAddLab.Append(" values ("); strSqlAddLab.Append("@IID,@ALID)"); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.Infos model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Infos("); strSql.Append("IName,PicAttID,IType,TIID,LID,SortNum,Status,CreateDate,Context,ConPosition,ConColor,ConSize,XPosition,YPosition,VideoAttID,NType,HotType,ADTime,ADPic,ADLink)"); strSql.Append(" values ("); strSql.Append("@IName,@PicAttID,@IType,@TIID,@LID,@SortNum,@Status,@CreateDate,@Context,@ConPosition,@ConColor,@ConSize,@XPosition,@YPosition,@VideoAttID,@NType,@HotType,@ADTime,@ADPic,@ADLink)"); 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, "PicAttID", DbType.String, model.PicAttID); db.AddInParameter(dbCommand, "IType", DbType.Int32, model.IType); db.AddInParameter(dbCommand, "TIID", DbType.Int32, model.TIID); db.AddInParameter(dbCommand, "LID", DbType.Int32, model.LID); db.AddInParameter(dbCommand, "SortNum", DbType.Int32, model.SortNum); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "Context", DbType.String, model.Context); db.AddInParameter(dbCommand, "ConPosition", DbType.String, model.ConPosition); db.AddInParameter(dbCommand, "ConColor", DbType.String, model.ConColor); db.AddInParameter(dbCommand, "ConSize", DbType.String, model.ConSize); db.AddInParameter(dbCommand, "XPosition", DbType.String, model.XPosition); db.AddInParameter(dbCommand, "YPosition", DbType.String, model.YPosition); db.AddInParameter(dbCommand, "VideoAttID", DbType.String, model.VideoAttID); db.AddInParameter(dbCommand, "NType", DbType.Byte, model.NType); db.AddInParameter(dbCommand, "HotType", DbType.Byte, model.HotType); db.AddInParameter(dbCommand, "ADTime", DbType.String, model.ADTime); db.AddInParameter(dbCommand, "ADPic", DbType.String, model.ADPic); db.AddInParameter(dbCommand, "ADLink", DbType.String, model.ADLink); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }
/// <summary> /// 得到一个对象实体 /// </summary> public ECommerce.Admin.Model.Infos GetModel(int IID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select IID,IName,PicAttID,IType,TIID,LID,SortNum,Status,CreateDate,Context,ConPosition,ConColor,ConSize,XPosition,YPosition,VideoAttID,NType,HotType,ADTime,ADPic,ADLink from Infos "); strSql.Append(" where IID=@IID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "IID", DbType.Int32, IID); ECommerce.Admin.Model.Infos model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
private void AddInfo(Database db, DbTransaction trans, Infos oldinfomodel, int tiid, int itid) { #region 新增info var oldbpic = new FileInfo(Server.MapPath("/UploadFiles/" + oldinfomodel.PicAttID)); var newPicAttaId = ""; if ("" != oldinfomodel.PicAttID && oldbpic.Exists) { newPicAttaId = Guid.NewGuid().ToString(); if ("C0pY" == oldinfomodel.PicAttID.Substring(0, 4)) { newPicAttaId = "C0pY" + newPicAttaId + oldinfomodel.PicAttID.Substring(40); } else { newPicAttaId = "C0pY" + newPicAttaId + oldinfomodel.PicAttID; } oldbpic.CopyTo(Server.MapPath("/UploadFiles/" + newPicAttaId)); } var newVAttaId = ""; if (!string.IsNullOrEmpty(oldinfomodel.VideoAttID)) { var oldvideo = new FileInfo(Server.MapPath("/UploadFiles/" + oldinfomodel.VideoAttID)); newVAttaId = Guid.NewGuid().ToString(); if (oldvideo.Exists) { if ("C0pY" == oldinfomodel.VideoAttID.Substring(0, 4)) { newVAttaId = "C0pY" + newVAttaId + oldinfomodel.VideoAttID.Substring(40); } else { newVAttaId = "C0pY" + newVAttaId + oldinfomodel.VideoAttID; } oldvideo.CopyTo(Server.MapPath("/UploadFiles/" + newVAttaId)); } else { newVAttaId = ""; } } var newadAttaId = ""; if (!string.IsNullOrEmpty(oldinfomodel.ADPic)) { var oldvideo = new FileInfo(Server.MapPath("/UploadFiles/" + oldinfomodel.ADPic)); newadAttaId = Guid.NewGuid().ToString(); if (oldvideo.Exists) { if ("C0pY" == oldinfomodel.ADPic.Substring(0, 4)) { newadAttaId = "C0pY" + newadAttaId + oldinfomodel.ADPic.Substring(40); } else { newadAttaId = "C0pY" + newadAttaId + oldinfomodel.ADPic; } oldvideo.CopyTo(Server.MapPath("/UploadFiles/" + newadAttaId)); } else { newadAttaId = ""; } } StringBuilder addinfo = new StringBuilder(); addinfo.Append("insert into Infos("); addinfo.Append( "IName,PicAttID,IType,TIID,LID,SortNum,Status,CreateDate,Context,ConPosition,ConColor,ConSize,XPosition,YPosition,VideoAttID,NType,HotType,ADTime,ADPic,ADLink)"); addinfo.Append(" values ("); addinfo.Append( "@IName,@PicAttID,@IType,@TIID,@LID,@SortNum,@Status,@CreateDate,@Context,@ConPosition,@ConColor,@ConSize,@XPosition,@YPosition,@VideoAttID,@NType,@HotType,@ADTime,@ADPic,@ADLink)"); addinfo.Append(";select @@IDENTITY"); DbCommand dbComAddInfo = db.GetSqlStringCommand(addinfo.ToString()); db.AddInParameter(dbComAddInfo, "IName", DbType.String, oldinfomodel.IName); db.AddInParameter(dbComAddInfo, "PicAttID", DbType.String, newPicAttaId); db.AddInParameter(dbComAddInfo, "IType", DbType.Int32, oldinfomodel.IType); db.AddInParameter(dbComAddInfo, "TIID", DbType.Int32, tiid); db.AddInParameter(dbComAddInfo, "LID", DbType.Int32, oldinfomodel.LID); db.AddInParameter(dbComAddInfo, "SortNum", DbType.Int32, oldinfomodel.SortNum); db.AddInParameter(dbComAddInfo, "Status", DbType.Byte, oldinfomodel.Status); db.AddInParameter(dbComAddInfo, "CreateDate", DbType.DateTime, oldinfomodel.CreateDate); db.AddInParameter(dbComAddInfo, "Context", DbType.String, oldinfomodel.Context); db.AddInParameter(dbComAddInfo, "ConPosition", DbType.String, oldinfomodel.ConPosition); db.AddInParameter(dbComAddInfo, "ConColor", DbType.String, oldinfomodel.ConColor); db.AddInParameter(dbComAddInfo, "ConSize", DbType.String, oldinfomodel.ConSize); db.AddInParameter(dbComAddInfo, "XPosition", DbType.String, oldinfomodel.XPosition); db.AddInParameter(dbComAddInfo, "YPosition", DbType.String, oldinfomodel.YPosition); db.AddInParameter(dbComAddInfo, "VideoAttID", DbType.String, newVAttaId); db.AddInParameter(dbComAddInfo, "NType", DbType.Byte, oldinfomodel.NType); db.AddInParameter(dbComAddInfo, "HotType", DbType.Byte, oldinfomodel.HotType); db.AddInParameter(dbComAddInfo, "ADTime", DbType.String, oldinfomodel.ADTime); db.AddInParameter(dbComAddInfo, "ADPic", DbType.String, newadAttaId); db.AddInParameter(dbComAddInfo, "ADLink", DbType.String, oldinfomodel.ADLink); object niid = db.ExecuteScalar(dbComAddInfo, trans); #endregion #region 新增InfoLabel var infolabel = "select * from InfoLabel where IID=" + oldinfomodel.IID; DbCommand dbComInfoLabel = db.GetSqlStringCommand(infolabel); var dtInfoLabel = db.ExecuteDataSet(dbComInfoLabel, trans).Tables[0]; if (dtInfoLabel.Rows.Count > 0) { var addinfolabel = ""; for (int i = 0; i < dtInfoLabel.Rows.Count; i++) { addinfolabel += "insert into InfoLabel(IID,ALID) values ('" + niid + "','" + dtInfoLabel.Rows[i]["ALID"] + "');"; } DbCommand dbComAddInfoLabel = db.GetSqlStringCommand(addinfolabel); db.ExecuteNonQuery(dbComAddInfoLabel, trans); } #endregion #region 新增AdInfo var adInfo = "select * from AdInfos where IID=" + oldinfomodel.IID; DbCommand dbComAdInfo = db.GetSqlStringCommand(adInfo); var dtAdInfo = db.ExecuteDataSet(dbComAdInfo, trans).Tables[0]; if (dtAdInfo.Rows.Count > 0) { var addAdInfo = ""; for (int i = 0; i < dtAdInfo.Rows.Count; i++) { addAdInfo += "insert into AdInfos(IID,Inf_IID) values ('" + niid + "','" + dtAdInfo.Rows[i]["Inf_IID"] + "');"; } DbCommand dbComAddAdInfo = db.GetSqlStringCommand(addAdInfo); db.ExecuteNonQuery(dbComAddAdInfo, trans); } #endregion #region 新增AttaList var attalist = "select * from AttaList where IID=" + oldinfomodel.IID; DbCommand dbComAttaList = db.GetSqlStringCommand(attalist); var dtAttaList = db.ExecuteDataSet(dbComAttaList, trans).Tables[0]; if (dtAttaList.Rows.Count > 0) { var addAttaList = ""; for (int i = 0; i < dtAttaList.Rows.Count; i++) { var oldfile = new FileInfo(Server.MapPath("/UploadFiles/" + dtAttaList.Rows[i]["AttID"])); var newAttaId = ""; if ("" != dtAttaList.Rows[i]["AttID"].ToString() && oldfile.Exists) { newAttaId = Guid.NewGuid().ToString(); if ("C0pY" == dtAttaList.Rows[i]["AttID"].ToString().Substring(0, 4)) { newAttaId = "C0pY" + newAttaId + dtAttaList.Rows[i]["AttID"].ToString().Substring(40); } else { newAttaId = "C0pY" + newAttaId + dtAttaList.Rows[i]["AttID"]; } oldfile.CopyTo(Server.MapPath("/UploadFiles/" + newAttaId)); } addAttaList += "insert into AttaList(AttID,IID) values (N'" + newAttaId + "','" + niid + "');"; } DbCommand dbComAddAttaList = db.GetSqlStringCommand(addAttaList); db.ExecuteNonQuery(dbComAddAttaList, trans); } #endregion #region 新增TemplateInfo var templatesql = "select * from TempInfo where ParentID=" + oldinfomodel.IID; DbCommand dbComTemplate = db.GetSqlStringCommand(templatesql); var dt = db.ExecuteDataSet(dbComTemplate, trans).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { var addTempInfo = ""; var attidbp = dt.Rows[i]["AttID"]; var newAttaId = ""; if (DBNull.Value != attidbp) { if (!string.IsNullOrEmpty(attidbp.ToString())) { var oldfile = new FileInfo(Server.MapPath("/UploadFiles/" + attidbp)); if (oldfile.Exists) { newAttaId = Guid.NewGuid().ToString(); if ("C0pY" == attidbp.ToString().Substring(0, 4)) { newAttaId = "C0pY" + newAttaId + attidbp.ToString().Substring(40); } else { newAttaId = "C0pY" + newAttaId + attidbp.ToString(); } oldfile.CopyTo(Server.MapPath("/UploadFiles/" + newAttaId)); } } } if (dt.Rows[i]["TIPage"] == DBNull.Value) { addTempInfo = "insert into TempInfo(ITID,TID,ParentID,AttID) values ('" + itid + "','" + dt.Rows[i]["TID"] + "','" + niid + "',N'" + newAttaId + "');select @@IDENTITY"; } else { addTempInfo = "insert into TempInfo(ITID,TID,TIPage,ParentID,AttID) values ('" + itid + "','" + dt.Rows[i]["TID"] + "','" + dt.Rows[i]["TIPage"] + "','" + niid + "',N'" + newAttaId + "');select @@IDENTITY"; } DbCommand dbComAddTempInfo = db.GetSqlStringCommand(addTempInfo); var ntiid = db.ExecuteScalar(dbComAddTempInfo, trans); var infos = "select * from Infos where TIID=" + dt.Rows[i]["TIID"]; DbCommand dbComInfos = db.GetSqlStringCommand(infos); var dtInfos = db.ExecuteDataSet(dbComInfos, trans).Tables[0]; if (dtInfos.Rows.Count > 0) { foreach (DataRow dataRow in dtInfos.Rows) { var imodel = _infosDal.DataRowToModel(dataRow); AddInfo(db, trans, imodel, Convert.ToInt32(ntiid), itid); } } } } #endregion }
/// <summary> /// 对象实体绑定数据 /// </summary> public ECommerce.Admin.Model.Infos ReaderBind(IDataReader dataReader) { ECommerce.Admin.Model.Infos model = new ECommerce.Admin.Model.Infos(); object ojb; ojb = dataReader["IID"]; if (ojb != null && ojb != DBNull.Value) { model.IID = Convert.ToInt32(ojb); } model.IName = dataReader["IName"].ToString(); model.PicAttID = dataReader["PicAttID"].ToString(); ojb = dataReader["IType"]; if (ojb != null && ojb != DBNull.Value) { model.IType = Convert.ToInt32(ojb); } ojb = dataReader["TIID"]; if (ojb != null && ojb != DBNull.Value) { model.TIID = Convert.ToInt32(ojb); } ojb = dataReader["LID"]; if (ojb != null && ojb != DBNull.Value) { model.LID = Convert.ToInt32(ojb); } 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); } ojb = dataReader["CreateDate"]; if (ojb != null && ojb != DBNull.Value) { model.CreateDate = Convert.ToDateTime(ojb); } model.Context = dataReader["Context"].ToString(); model.ConPosition = dataReader["ConPosition"].ToString(); model.ConColor = dataReader["ConColor"].ToString(); model.ConSize = dataReader["ConSize"].ToString(); model.XPosition = dataReader["XPosition"].ToString(); model.YPosition = dataReader["YPosition"].ToString(); model.VideoAttID = dataReader["VideoAttID"].ToString(); ojb = dataReader["NType"]; if (ojb != null && ojb != DBNull.Value) { model.NType = Convert.ToInt32(ojb); } ojb = dataReader["HotType"]; if (ojb != null && ojb != DBNull.Value) { model.HotType = Convert.ToInt32(ojb); } model.ADTime = dataReader["ADTime"].ToString(); model.ADPic = dataReader["ADPic"].ToString(); model.ADLink = dataReader["ADLink"].ToString(); return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public ECommerce.Admin.Model.Infos DataRowToModel(DataRow row) { ECommerce.Admin.Model.Infos model = new ECommerce.Admin.Model.Infos(); if (row != null) { if (row["IID"] != null && row["IID"].ToString() != "") { model.IID = Convert.ToInt32(row["IID"].ToString()); } if (row["IName"] != null) { model.IName = row["IName"].ToString(); } if (row["PicAttID"] != null) { model.PicAttID = row["PicAttID"].ToString(); } if (row["IType"] != null && row["IType"].ToString() != "") { model.IType = Convert.ToInt32(row["IType"].ToString()); } if (row["TIID"] != null && row["TIID"].ToString() != "") { model.TIID = Convert.ToInt32(row["TIID"].ToString()); } if (row["LID"] != null && row["LID"].ToString() != "") { model.LID = Convert.ToInt32(row["LID"].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()); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = Convert.ToDateTime(row["CreateDate"].ToString()); } if (row["Context"] != null) { model.Context = row["Context"].ToString(); } if (row["ConPosition"] != null) { model.ConPosition = row["ConPosition"].ToString(); } if (row["ConColor"] != null) { model.ConColor = row["ConColor"].ToString(); } if (row["ConSize"] != null) { model.ConSize = row["ConSize"].ToString(); } if (row["XPosition"] != null) { model.XPosition = row["XPosition"].ToString(); } if (row["YPosition"] != null) { model.YPosition = row["YPosition"].ToString(); } if (row["VideoAttID"] != null) { model.VideoAttID = row["VideoAttID"].ToString(); } if (row["NType"] != null && row["NType"].ToString() != "") { model.NType = Convert.ToInt32(row["NType"].ToString()); } if (row["HotType"] != null && row["HotType"].ToString() != "") { model.HotType = Convert.ToInt32(row["HotType"].ToString()); } if (row["ADTime"] != null) { model.ADTime = row["ADTime"].ToString(); } if (row["ADPic"] != null) { model.ADPic = row["ADPic"].ToString(); } if (row["ADLink"] != null) { model.ADLink = row["ADLink"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ECommerce.Admin.Model.Infos model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Infos set "); strSql.Append("IName=@IName,"); strSql.Append("PicAttID=@PicAttID,"); strSql.Append("IType=@IType,"); strSql.Append("TIID=@TIID,"); strSql.Append("LID=@LID,"); strSql.Append("SortNum=@SortNum,"); strSql.Append("Status=@Status,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("Context=@Context,"); strSql.Append("ConPosition=@ConPosition,"); strSql.Append("ConColor=@ConColor,"); strSql.Append("ConSize=@ConSize,"); strSql.Append("XPosition=@XPosition,"); strSql.Append("YPosition=@YPosition,"); strSql.Append("VideoAttID=@VideoAttID,"); strSql.Append("NType=@NType,"); strSql.Append("HotType=@HotType,"); strSql.Append("ADTime=@ADTime,"); strSql.Append("ADPic=@ADPic,"); strSql.Append("ADLink=@ADLink"); strSql.Append(" where IID=@IID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "IID", DbType.Int32, model.IID); db.AddInParameter(dbCommand, "IName", DbType.String, model.IName); db.AddInParameter(dbCommand, "PicAttID", DbType.String, model.PicAttID); db.AddInParameter(dbCommand, "IType", DbType.Int32, model.IType); db.AddInParameter(dbCommand, "TIID", DbType.Int32, model.TIID); db.AddInParameter(dbCommand, "LID", DbType.Int32, model.LID); db.AddInParameter(dbCommand, "SortNum", DbType.Int32, model.SortNum); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "Context", DbType.String, model.Context); db.AddInParameter(dbCommand, "ConPosition", DbType.String, model.ConPosition); db.AddInParameter(dbCommand, "ConColor", DbType.String, model.ConColor); db.AddInParameter(dbCommand, "ConSize", DbType.String, model.ConSize); db.AddInParameter(dbCommand, "XPosition", DbType.String, model.XPosition); db.AddInParameter(dbCommand, "YPosition", DbType.String, model.YPosition); db.AddInParameter(dbCommand, "VideoAttID", DbType.String, model.VideoAttID); db.AddInParameter(dbCommand, "NType", DbType.Byte, model.NType); db.AddInParameter(dbCommand, "HotType", DbType.Byte, model.HotType); db.AddInParameter(dbCommand, "ADTime", DbType.String, model.ADTime); db.AddInParameter(dbCommand, "ADPic", DbType.String, model.ADPic); db.AddInParameter(dbCommand, "ADLink", DbType.String, model.ADLink); int rows = db.ExecuteNonQuery(dbCommand); if (rows > 0) { return(true); } else { return(false); } }