Exemplos de REL_Article_ChartMod em C# (CSharp)

Exemplo n.º 1

        /// <summary>
        /// 得到一个对象实体
        /// </summary>

        public REL_Article_ChartMod GetModel(int SysNo)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select SysNo, Article_SysNo, Chart_SysNo from  REL_Article_Chart");
            strSql.Append(" where SysNo=@SysNo ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@SysNo", SqlDbType.Int, 4)
            };
            parameters[0].Value = SysNo;
            REL_Article_ChartMod model = new REL_Article_ChartMod();
            DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "")
                {
                    model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
                }
                if (ds.Tables[0].Rows[0]["Article_SysNo"].ToString() != "")
                {
                    model.Article_SysNo = int.Parse(ds.Tables[0].Rows[0]["Article_SysNo"].ToString());
                }
                if (ds.Tables[0].Rows[0]["Chart_SysNo"].ToString() != "")
                {
                    model.Chart_SysNo = int.Parse(ds.Tables[0].Rows[0]["Chart_SysNo"].ToString());
                }
                return(model);
            }
            else
            {
                return(null);
            }
        }

Exemplo n.º 2

Arquivo: REL_Article_ChartDal.cs Projeto: Kjubo/luckysign

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(REL_Article_ChartMod model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into REL_Article_Chart(");
            strSql.Append("Article_SysNo,Chart_SysNo)");
            strSql.Append(" values (");
            strSql.Append("@Article_SysNo,@Chart_SysNo)");
            strSql.Append(";select SCOPE_IDENTITY()");
            SqlCommand cmd = new SqlCommand(strSql.ToString());
            SqlParameter[] parameters = {
                 new SqlParameter("@Article_SysNo",SqlDbType.Int,4),
                 new SqlParameter("@Chart_SysNo",SqlDbType.Int,4),
             };
            if (model.Article_SysNo != AppConst.IntNull)
                parameters[0].Value = model.Article_SysNo;
            else
                parameters[0].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[0]);
            if (model.Chart_SysNo != AppConst.IntNull)
                parameters[1].Value = model.Chart_SysNo;
            else
                parameters[1].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[1]);

            return SqlHelper.ExecuteNonQuery(cmd, parameters);
        }

Exemplo n.º 3

        /// <summary>
        /// 更新一条数据
        /// </summary>

        public int Update(REL_Article_ChartMod model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update REL_Article_Chart set ");
            strSql.Append("Article_SysNo=@Article_SysNo,");
            strSql.Append("Chart_SysNo=@Chart_SysNo");
            strSql.Append(" where SysNo=@SysNo ");
            SqlCommand cmd = new SqlCommand(strSql.ToString());

            SqlParameter[] parameters =
            {
                new SqlParameter("@SysNo",         SqlDbType.Int, 4),
                new SqlParameter("@Article_SysNo", SqlDbType.Int, 4),
                new SqlParameter("@Chart_SysNo",   SqlDbType.Int, 4)
            };
            if (model.SysNo != AppConst.IntNull)
            {
                parameters[0].Value = model.SysNo;
            }
            else
            {
                parameters[0].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[0]);
            if (model.Article_SysNo != AppConst.IntNull)
            {
                parameters[1].Value = model.Article_SysNo;
            }
            else
            {
                parameters[1].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[1]);
            if (model.Chart_SysNo != AppConst.IntNull)
            {
                parameters[2].Value = model.Chart_SysNo;
            }
            else
            {
                parameters[2].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[2]);
            return(SqlHelper.ExecuteNonQuery(cmd, parameters));
        }

Exemplo n.º 4

        /// <summary>
        /// 增加一条数据
        /// </summary>

        public int Add(REL_Article_ChartMod model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into REL_Article_Chart(");
            strSql.Append("Article_SysNo,Chart_SysNo)");
            strSql.Append(" values (");
            strSql.Append("@Article_SysNo,@Chart_SysNo)");
            strSql.Append(";select SCOPE_IDENTITY()");
            SqlCommand cmd = new SqlCommand(strSql.ToString());

            SqlParameter[] parameters =
            {
                new SqlParameter("@Article_SysNo", SqlDbType.Int, 4),
                new SqlParameter("@Chart_SysNo",   SqlDbType.Int, 4),
            };
            if (model.Article_SysNo != AppConst.IntNull)
            {
                parameters[0].Value = model.Article_SysNo;
            }
            else
            {
                parameters[0].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[0]);
            if (model.Chart_SysNo != AppConst.IntNull)
            {
                parameters[1].Value = model.Chart_SysNo;
            }
            else
            {
                parameters[1].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[1]);

            return(SqlHelper.ExecuteNonQuery(cmd, parameters));
        }

Exemplo n.º 5

Arquivo: REL_Article_ChartDal.cs Projeto: Kjubo/luckysign

 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public REL_Article_ChartMod GetModel(int SysNo)
 {
     StringBuilder strSql = new StringBuilder();
     strSql.Append("select SysNo, Article_SysNo, Chart_SysNo from  REL_Article_Chart");
     strSql.Append(" where SysNo=@SysNo ");
     SqlParameter[] parameters = {
     new SqlParameter("@SysNo", SqlDbType.Int,4 )
      		};
     parameters[0].Value = SysNo;
     REL_Article_ChartMod model = new REL_Article_ChartMod();
     DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters);
     if (ds.Tables[0].Rows.Count > 0)
     {
         if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "")
         {
             model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
         }
         if (ds.Tables[0].Rows[0]["Article_SysNo"].ToString() != "")
         {
             model.Article_SysNo = int.Parse(ds.Tables[0].Rows[0]["Article_SysNo"].ToString());
         }
         if (ds.Tables[0].Rows[0]["Chart_SysNo"].ToString() != "")
         {
             model.Chart_SysNo = int.Parse(ds.Tables[0].Rows[0]["Chart_SysNo"].ToString());
         }
         return model;
     }
     else
     {
         return null;
     }
 }

Exemplo n.º 6

Arquivo: REL_Article_ChartDal.cs Projeto: Kjubo/luckysign

 /// <summary>
 /// 更新一条数据
 /// </summary>
 public int Update(REL_Article_ChartMod model)
 {
     StringBuilder strSql = new StringBuilder();
     strSql.Append("update REL_Article_Chart set ");
     strSql.Append("Article_SysNo=@Article_SysNo,");
     strSql.Append("Chart_SysNo=@Chart_SysNo");
     strSql.Append(" where SysNo=@SysNo ");
     SqlCommand cmd = new SqlCommand(strSql.ToString());
     SqlParameter[] parameters = {
          new SqlParameter("@SysNo",SqlDbType.Int,4),
          new SqlParameter("@Article_SysNo",SqlDbType.Int,4),
          new SqlParameter("@Chart_SysNo",SqlDbType.Int,4)
      };
     if (model.SysNo != AppConst.IntNull)
         parameters[0].Value = model.SysNo;
     else
         parameters[0].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[0]);
     if (model.Article_SysNo != AppConst.IntNull)
         parameters[1].Value = model.Article_SysNo;
     else
         parameters[1].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[1]);
     if (model.Chart_SysNo != AppConst.IntNull)
         parameters[2].Value = model.Chart_SysNo;
     else
         parameters[2].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[2]);
     return SqlHelper.ExecuteNonQuery(cmd, parameters);
 }

Exemplo n.º 7

        /// <summary>
        /// 更新一条数据
        /// </summary>

        public void Update(REL_Article_ChartMod model)
        {
            dal.Update(model);
        }

Exemplo n.º 8

        /// <summary>
        /// 增加一条数据
        /// </summary>

        public int Add(REL_Article_ChartMod model)
        {
            return(dal.Add(model));
        }

Exemplo n.º 9

Arquivo: REL_Article_ChartBllcs.cs Projeto: Kjubo/luckysign

 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Update(REL_Article_ChartMod model)
 {
     dal.Update(model);
 }

Exemplo n.º 10

Arquivo: REL_Article_ChartBllcs.cs Projeto: Kjubo/luckysign

 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(REL_Article_ChartMod model)
 {
     return dal.Add(model);
 }