コード例 #1
0
        public bool AddJournalInfo(JournalInfoEntity journalInfoEntity)
        {
            bool flag = false;
            StringBuilder sqlCommandText = new StringBuilder();

            sqlCommandText.Append("@JournalName");
            sqlCommandText.Append(", @SiteUrl");
            sqlCommandText.Append(", @ServiceStartDate");
            sqlCommandText.Append(", @ServiceEndDate");
            sqlCommandText.Append(", @Linkman");
            sqlCommandText.Append(", @LinkTel");
            sqlCommandText.Append(", @Fax");
            sqlCommandText.Append(", @Email");
            sqlCommandText.Append(", @Mobile");
            sqlCommandText.Append(", @Address");
            sqlCommandText.Append(", @ZipCode");
            sqlCommandText.Append(", @AuthorizationCode");
            sqlCommandText.Append(", @Status");
            sqlCommandText.Append(", @Note");

            DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.JournalInfo ({0}) VALUES ({1})",sqlCommandText.ToString().Replace("@", ""),sqlCommandText.ToString()));

            db.AddInParameter(cmd,"@JournalName",DbType.AnsiString,journalInfoEntity.JournalName);
            db.AddInParameter(cmd,"@SiteUrl",DbType.AnsiString,journalInfoEntity.SiteUrl);
            db.AddInParameter(cmd,"@ServiceStartDate",DbType.DateTime,journalInfoEntity.ServiceStartDate);
            db.AddInParameter(cmd,"@ServiceEndDate",DbType.DateTime,journalInfoEntity.ServiceEndDate);
            db.AddInParameter(cmd,"@Linkman",DbType.AnsiString,journalInfoEntity.Linkman);
            db.AddInParameter(cmd,"@LinkTel",DbType.AnsiString,journalInfoEntity.LinkTel);
            db.AddInParameter(cmd,"@Fax",DbType.AnsiString,journalInfoEntity.Fax);
            db.AddInParameter(cmd,"@Email",DbType.AnsiString,journalInfoEntity.Email);
            db.AddInParameter(cmd,"@Mobile",DbType.AnsiString,journalInfoEntity.Mobile);
            db.AddInParameter(cmd,"@Address",DbType.AnsiString,journalInfoEntity.Address);
            db.AddInParameter(cmd,"@ZipCode",DbType.AnsiString,journalInfoEntity.ZipCode);
            db.AddInParameter(cmd,"@AuthorizationCode",DbType.AnsiString,journalInfoEntity.AuthorizationCode);
            db.AddInParameter(cmd,"@Status",DbType.Byte,journalInfoEntity.Status);
            db.AddInParameter(cmd,"@Note",DbType.AnsiString,journalInfoEntity.Note);

            try
            {
                db.ExecuteNonQuery(cmd);
                flag = true;
            }
            catch(SqlException sqlEx)
            {
                throw sqlEx;
            }
            return flag;
        }
コード例 #2
0
 public ActionResult AddAjax(JournalInfoEntity journalEntity)
 {
     try
     {
         if (!Request.IsAjaxRequest())
         {
             return Content("{\"result\":\"failure\",\"msg\":\"非法请求\"}");
         }
         string msg = "";
         if (ModelState.IsValid)
         {
             IJournalInfoService journalService = ServiceContainer.Instance.Container.Resolve<IJournalInfoService>();
             JournalInfoQuery queryEntity = new JournalInfoQuery();
             queryEntity.JournalName = WKT.Common.Security.SecurityUtils.SafeSqlString(journalEntity.JournalName);
             IList<JournalInfoEntity> list = journalService.GetJournalInfoList(queryEntity);
             if (list.Count > 0)
             {
                 msg = "{\"result\":\"failure\",\"msg\":\"该编辑部已经存在\"}";
             }
             else
             {
                 bool flag = journalService.AddJournalInfo(journalEntity);
                 if (flag)
                 {
                     msg = "{\"result\":\"success\"}";
                 }
                 else
                 {
                     msg = "{\"result\":\"failure\",\"msg\":\"添加失败,请检查\"}";
                 }
             }
         }
         else
         {
             msg = "{\"result\":\"failure\",\"msg\":\"" + this.ExpendErrors() + "\"}";
         }
         return Content(msg);
     }
     catch (Exception ex)
     {
         LogProvider.Instance.Error("添加编辑部异常:" + ex.Message);
         return Content("{\"result\":\"error\",\"msg\":\"" + ex.Message + "\"}");
     }
 }
コード例 #3
0
        public bool UpdateJournalInfo(JournalInfoEntity journalInfoEntity)
        {
            bool flag = false;
            StringBuilder whereCommandText = new StringBuilder();
            whereCommandText.Append("  JournalID=@JournalID");
            StringBuilder sqlCommandText = new StringBuilder();
            sqlCommandText.Append(" JournalName=@JournalName");
            sqlCommandText.Append(", SiteUrl=@SiteUrl");
            sqlCommandText.Append(", ServiceStartDate=@ServiceStartDate");
            sqlCommandText.Append(", ServiceEndDate=@ServiceEndDate");
            sqlCommandText.Append(", Linkman=@Linkman");
            sqlCommandText.Append(", LinkTel=@LinkTel");
            sqlCommandText.Append(", Fax=@Fax");
            sqlCommandText.Append(", Email=@Email");
            sqlCommandText.Append(", Mobile=@Mobile");
            sqlCommandText.Append(", Address=@Address");
            sqlCommandText.Append(", ZipCode=@ZipCode");
            sqlCommandText.Append(", AuthorizationCode=@AuthorizationCode");
            sqlCommandText.Append(", Status=@Status");
            sqlCommandText.Append(", Note=@Note");
            sqlCommandText.Append(", AddDate=@AddDate");

            DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.JournalInfo SET {0} WHERE  {1}",sqlCommandText.ToString(),whereCommandText.ToString()));

            db.AddInParameter(cmd,"@JournalID",DbType.Int64,journalInfoEntity.JournalID);
            db.AddInParameter(cmd,"@JournalName",DbType.AnsiString,journalInfoEntity.JournalName);
            db.AddInParameter(cmd,"@SiteUrl",DbType.AnsiString,journalInfoEntity.SiteUrl);
            db.AddInParameter(cmd,"@ServiceStartDate",DbType.DateTime,journalInfoEntity.ServiceStartDate);
            db.AddInParameter(cmd,"@ServiceEndDate",DbType.DateTime,journalInfoEntity.ServiceEndDate);
            db.AddInParameter(cmd,"@Linkman",DbType.AnsiString,journalInfoEntity.Linkman);
            db.AddInParameter(cmd,"@LinkTel",DbType.AnsiString,journalInfoEntity.LinkTel);
            db.AddInParameter(cmd,"@Fax",DbType.AnsiString,journalInfoEntity.Fax);
            db.AddInParameter(cmd,"@Email",DbType.AnsiString,journalInfoEntity.Email);
            db.AddInParameter(cmd,"@Mobile",DbType.AnsiString,journalInfoEntity.Mobile);
            db.AddInParameter(cmd,"@Address",DbType.AnsiString,journalInfoEntity.Address);
            db.AddInParameter(cmd,"@ZipCode",DbType.AnsiString,journalInfoEntity.ZipCode);
            db.AddInParameter(cmd,"@AuthorizationCode",DbType.AnsiString,journalInfoEntity.AuthorizationCode);
            db.AddInParameter(cmd,"@Status",DbType.Byte,journalInfoEntity.Status);
            db.AddInParameter(cmd,"@Note",DbType.AnsiString,journalInfoEntity.Note);
            db.AddInParameter(cmd,"@AddDate",DbType.DateTime,journalInfoEntity.AddDate);

            try
            {
                db.ExecuteNonQuery(cmd);
                flag = true;
            }
            catch(SqlException sqlEx)
            {
                throw sqlEx;
            }
            return flag;
        }
コード例 #4
0
 public List<JournalInfoEntity> MakeJournalInfoList(IDataReader dr)
 {
     List<JournalInfoEntity> list=new List<JournalInfoEntity>();
     while(dr.Read())
     {
      JournalInfoEntity journalInfoEntity=new JournalInfoEntity();
     journalInfoEntity.JournalID = (Int64)dr["JournalID"];
     journalInfoEntity.JournalName = (String)dr["JournalName"];
     journalInfoEntity.SiteUrl = (String)dr["SiteUrl"];
     journalInfoEntity.ServiceStartDate = (DateTime)dr["ServiceStartDate"];
     journalInfoEntity.ServiceEndDate = (DateTime)dr["ServiceEndDate"];
     journalInfoEntity.Linkman = (String)dr["Linkman"];
     journalInfoEntity.LinkTel = (String)dr["LinkTel"];
     journalInfoEntity.Fax = (String)dr["Fax"];
     journalInfoEntity.Email = (String)dr["Email"];
     journalInfoEntity.Mobile = (String)dr["Mobile"];
     journalInfoEntity.Address = (String)dr["Address"];
     journalInfoEntity.ZipCode = (String)dr["ZipCode"];
     journalInfoEntity.AuthorizationCode = (String)dr["AuthorizationCode"];
     journalInfoEntity.Status = (Byte)dr["Status"];
     journalInfoEntity.Note = (String)dr["Note"];
     journalInfoEntity.AddDate = (DateTime)dr["AddDate"];
        list.Add(journalInfoEntity);
     }
     dr.Close();
     return list;
 }
コード例 #5
0
 public JournalInfoEntity MakeJournalInfo(DataRow dr)
 {
     JournalInfoEntity journalInfoEntity=null;
     if(dr!=null)
     {
          journalInfoEntity=new JournalInfoEntity();
          journalInfoEntity.JournalID = (Int64)dr["JournalID"];
          journalInfoEntity.JournalName = (String)dr["JournalName"];
          journalInfoEntity.SiteUrl = (String)dr["SiteUrl"];
          journalInfoEntity.ServiceStartDate = (DateTime)dr["ServiceStartDate"];
          journalInfoEntity.ServiceEndDate = (DateTime)dr["ServiceEndDate"];
          journalInfoEntity.Linkman = (String)dr["Linkman"];
          journalInfoEntity.LinkTel = (String)dr["LinkTel"];
          journalInfoEntity.Fax = (String)dr["Fax"];
          journalInfoEntity.Email = (String)dr["Email"];
          journalInfoEntity.Mobile = (String)dr["Mobile"];
          journalInfoEntity.Address = (String)dr["Address"];
          journalInfoEntity.ZipCode = (String)dr["ZipCode"];
          journalInfoEntity.AuthorizationCode = (String)dr["AuthorizationCode"];
          journalInfoEntity.Status = (Byte)dr["Status"];
          journalInfoEntity.Note = (String)dr["Note"];
          journalInfoEntity.AddDate = (DateTime)dr["AddDate"];
     }
     return journalInfoEntity;
 }
コード例 #6
0
        public bool DeleteJournalInfo(JournalInfoEntity journalInfoEntity)
        {
            bool flag = false;
            StringBuilder sqlCommandText = new StringBuilder();
            sqlCommandText.Append("DELETE FROM dbo.JournalInfo");
            sqlCommandText.Append(" WHERE  JournalID=@JournalID");

            DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());

            db.AddInParameter(cmd,"@JournalID",DbType.Int64,journalInfoEntity.JournalID);

            try
            {
                db.ExecuteNonQuery(cmd);
                flag = true;
            }
            catch(SqlException sqlEx)
            {
                throw sqlEx;
            }
            return flag;
        }
コード例 #7
0
 /// <summary>
 /// 从存储媒介删除实体数据
 /// </summary>
 /// <param name="journalInfo">JournalInfoEntity实体对象</param>
 /// <returns>true:删除成功 false:删除失败</returns>
 public bool DeleteJournalInfo(JournalInfoEntity journalInfo)
 {
     return JournalInfoBusProvider.DeleteJournalInfo(journalInfo);
 }
コード例 #8
0
 /// <summary>
 /// 将实体数据存入存储媒介(持久化一个对象)
 /// </summary>
 /// <param name="journalInfo">JournalInfoEntity实体对象</param>
 /// <returns>true:存储成功 false:存储失败</returns>
 public bool AddJournalInfo(JournalInfoEntity journalInfo)
 {
     return JournalInfoBusProvider.AddJournalInfo(journalInfo);
 }
コード例 #9
0
 /// <summary>
 /// 更新存储媒介中的实体数据
 /// </summary>
 /// <param name="journalInfo">JournalInfoEntity实体对象</param>
 /// <returns>true:更新成功 false:更新失败</returns>
 public bool UpdateJournalInfo(JournalInfoEntity journalInfo)
 {
     return JournalInfoBusProvider.UpdateJournalInfo(journalInfo);
 }
コード例 #10
0
 public ActionResult EditAjax(JournalInfoEntity journalEntity)
 {
     try
     {
         if (!Request.IsAjaxRequest())
         {
             return Content("{\"result\":\"failure\",\"msg\":\"非法请求\"}");
         }
         string msg = "";
         if (ModelState.IsValid)
         {
             IJournalInfoService journalService = ServiceContainer.Instance.Container.Resolve<IJournalInfoService>();
             bool flag = journalService.UpdateJournalInfo(journalEntity);
             if (flag)
             {
                 msg = "{\"result\":\"success\"}";
             }
             else
             {
                 msg = "{\"result\":\"failure\",\"msg\":\"修改失败,请检查\"}";
             }
         }
         else
         {
             msg = "{\"result\":\"failure\",\"msg\":\"" + this.ExpendErrors() + "\"}";
         }
         return Content(msg);
     }
     catch (Exception ex)
     {
         LogProvider.Instance.Error("修改编辑部信息异常:" + ex.Message);
         return Content("{\"result\":\"error\",\"msg\":\"" + ex.Message + "\"}");
     }
 }
コード例 #11
0
 /// <summary>
 /// 从存储媒介删除实体数据
 /// </summary>
 /// <param name="journalInfo">JournalInfoEntity实体对象</param>
 /// <returns>true:删除成功 false:删除失败</returns>
 public bool DeleteJournalInfo(JournalInfoEntity journalInfo)
 {
     return JournalInfoDataAccess.Instance.DeleteJournalInfo(journalInfo);
 }
コード例 #12
0
 /// <summary>
 /// 将实体数据存入存储媒介(持久化一个对象)
 /// </summary>
 /// <param name="journalInfo">JournalInfoEntity实体对象</param>
 /// <returns>true:存储成功 false:存储失败</returns>
 public bool AddJournalInfo(JournalInfoEntity journalInfo)
 {
     return JournalInfoDataAccess.Instance.AddJournalInfo(journalInfo);
 }