public static MokuaiDto GetOneMokuaiDto(string table,string strwhere)
        {
            MokuaiDto mokuaiDto=new MokuaiDto();

            mokuaiDto = MokuaiDal.GetOneMokuai(table, strwhere);

            return mokuaiDto;
        }
        public ActionResult MokuaiInsert(MokuaiAddViewModel model)
        {
            MokuaiDto mokuaiDto = new MokuaiDto();

            mokuaiDto.MokuaiTitle = model.MokuaiTitle;

            mokuaiDto.MokuaiImg = model.MokuaiImg;

            mokuaiDto.MokuaiContent = model.MokuaiContent;
            mokuaiDto.MokuaiInfo = model.MokuaiInfo;
            mokuaiDto.MokuaiDateTime = System.DateTime.Now;

            MokuaiBll.AddMokuai(mokuaiDto);

            return RedirectToAction("MokuaiIndex");
        }
Пример #3
0
        public static void AddMokuai(MokuaiDto mokuaiDto)
        {
            SqlParameter[] arParames = MokuaiDal.getParameters(mokuaiDto);
            SqlConnection myconn = new SqlConnection(CommonDal.ConnectionString);
            try
            {
            SqlHelper.ExecuteNonQuery(CommonDal.ConnectionString, CommandType.StoredProcedure, "CreateMokuai", arParames);
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {

                myconn.Close();
                myconn.Dispose();
            }
        }
Пример #4
0
        public static List<MokuaiDto> GetMokuaiList(string strwhere)
        {
            List<MokuaiDto> mokuailist = new List<MokuaiDto>();

            SqlParameter[] arParames = new SqlParameter[2];
            arParames[0] = new SqlParameter("@table ", SqlDbType.VarChar, 200);
            arParames[0].Value = "QxsqMokuai";

            arParames[1] = new SqlParameter("@Where ", SqlDbType.VarChar, 8000);
            arParames[1].Value = strwhere;
             SqlConnection myconn = new SqlConnection(CommonDal.ConnectionString);
            try
            {
            DataTable dt = null;
            DataSet ds = SqlHelper.ExecuteDataset(CommonDal.ConnectionString, CommandType.StoredProcedure, "getModelByWhere", arParames);
            dt = ds.Tables[0];
            foreach (DataRow dr in dt.Rows)
            {
                MokuaiDto MokuaiDto = new MokuaiDto();

                MokuaiDto = MokuaiDal.getDataRowToMokuaiDto(dr);

                mokuailist.Add(MokuaiDto);

            }

            return mokuailist;
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {

                myconn.Close();
                myconn.Dispose();
            }
        }
Пример #5
0
        private static SqlParameter[] getParameters(MokuaiDto mokuaiDto)
        {
            SqlParameter[] arParames = new SqlParameter[6];

            arParames[0] = new SqlParameter("@MokuaiId", SqlDbType.Int);
            arParames[0].Value = mokuaiDto.MokuaiId;

            arParames[1] = new SqlParameter("@MokuaiTitle", SqlDbType.VarChar, 500);
            arParames[1].Value = mokuaiDto.MokuaiTitle;

            arParames[2] = new SqlParameter("@MokuaiImg", SqlDbType.VarChar, 500);
            arParames[2].Value = mokuaiDto.MokuaiImg;

            arParames[3] = new SqlParameter("@MokuaiContent", SqlDbType.Text);
            arParames[3].Value = mokuaiDto.MokuaiContent;

            arParames[4] = new SqlParameter("@MokuaiInfo", SqlDbType.Text);
            arParames[4].Value = mokuaiDto.MokuaiInfo;

            arParames[5] = new SqlParameter("@MokuaiDateTime", SqlDbType.DateTime);
            arParames[5].Value = mokuaiDto.MokuaiDateTime;

            return arParames;
        }
Пример #6
0
        private static MokuaiDto getDataRowToMokuaiDto(DataRow dr)
        {
            MokuaiDto mokuaiDto = new MokuaiDto();

            mokuaiDto.MokuaiId = int.Parse(dr["MokuaiId"].ToString());
            mokuaiDto.MokuaiTitle = dr["MokuaiTitle"].ToString();
            mokuaiDto.MokuaiImg = dr["MokuaiImg"].ToString();

            mokuaiDto.MokuaiContent = dr["MokuaiContent"].ToString();
            mokuaiDto.MokuaiInfo = dr["MokuaiInfo"].ToString();

            mokuaiDto.MokuaiDateTime = DateTime.Parse(dr["MokuaiDateTime"].ToString());

            return mokuaiDto;
        }
 public static void UpdateMokuaiDto(MokuaiDto mokuaiDto)
 {
     MokuaiDal.UpdateMokuai(mokuaiDto);
 }
 public static void AddMokuai(MokuaiDto mokuaiDto)
 {
     MokuaiDal.AddMokuai(mokuaiDto);
 }