/// <summary>
        /// 新增
        /// </summary>
        /// <param name="model">实体</param>
        /// <returns></returns>
        public bool AddNew(Models.ys_AssetsStock model)
        {
            string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_AssetsStock]
           ([Id]
           ,[StockName]
           ,[ManagerId]
           ,[ManagerName]
           ,[IsRemoved]
           ,[CreateTime])
     VALUES
          ( @Id
           ,@StockName
           ,@ManagerId
           ,@ManagerName
           ,@IsRemoved
           ,@CreateTime)";

            SqlParameter s1 = new SqlParameter("@Id", model.Id);
            SqlParameter s2 = new SqlParameter("@StockName", model.StockName);
            SqlParameter s3 = new SqlParameter("@ManagerId", model.ManagerId);
            SqlParameter s4 = new SqlParameter("@ManagerName", model.ManagerName);
            SqlParameter s7 = new SqlParameter("@CreateTime", model.CreateTime);
            SqlParameter s8 = new SqlParameter("@IsRemoved", model.IsRemoved);

            SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s7, s8 };
            return(Models.SqlHelper.ExecuteNoQuery(sqlText, cmdPara) > 0 ? true : false);
        }
Esempio n. 2
0
 public override void AddNew()
 {
     IsAddNew          = true;
     model             = new Models.ys_AssetsStock();
     model.Id          = Guid.NewGuid();
     txtStockName.Text = cboxMgUser.Text = txtID.Text = "";
     txtStockName.Focus();
 }
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="model">实体</param>
        /// <returns></returns>
        public bool Modify(Models.ys_AssetsStock model)
        {
            string sqlText = @"UPDATE [AssetsSys].[dbo].[ys_AssetsStock]
   SET [StockName] = @StockName
      ,[ManagerId] = @ManagerId
      ,[ManagerName] = @ManagerName
      ,[IsRemoved] = @IsRemoved
      ,[CreateTime] = @CreateTime
 WHERE [Id] = @Id";

            SqlParameter s1 = new SqlParameter("@Id", model.Id);
            SqlParameter s2 = new SqlParameter("@StockName", model.StockName);
            SqlParameter s3 = new SqlParameter("@ManagerId", model.ManagerId);
            SqlParameter s4 = new SqlParameter("@ManagerName", model.ManagerName);
            SqlParameter s7 = new SqlParameter("@CreateTime", model.CreateTime);
            SqlParameter s8 = new SqlParameter("@IsRemoved", model.IsRemoved);

            SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s7, s8 };
            return(Models.SqlHelper.ExecuteNoQuery(sqlText, cmdPara) > 0 ? true : false);
        }
Esempio n. 4
0
 /// <summary>
 /// 修改
 /// </summary>
 /// <param name="model">实体</param>
 /// <returns></returns>
 public bool Modify(Models.ys_AssetsStock model)
 {
     return(dal.Modify(model));
 }
Esempio n. 5
0
 /// <summary>
 /// 新增
 /// </summary>
 /// <param name="model">实体</param>
 /// <returns></returns>
 public bool AddNew(Models.ys_AssetsStock model)
 {
     return(dal.AddNew(model));
 }