Example #1
0
        public bool insertNewEntity(AppendStock s)
        {
            int rowsAffected = 0;

            SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@AppendID", SqlDbType.NVarChar), new SqlParameter("@AppendType", SqlDbType.Int), new SqlParameter("@StoreHouseID", SqlDbType.Int), new SqlParameter("@HouseDetailID", SqlDbType.Int), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@TradeDate", SqlDbType.NVarChar), new SqlParameter("@TotalPrice", SqlDbType.Float), new SqlParameter("@AlreadyPay", SqlDbType.Float), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.Int), new SqlParameter("@CreateDate", SqlDbType.NVarChar) };
            parameters[0].Value  = s.AppendID;
            parameters[1].Value  = s.AppendType;
            parameters[2].Value  = s.StoreHouseID;
            parameters[3].Value  = s.HouseDetailID;
            parameters[4].Value  = s.UserName;
            parameters[5].Value  = s.TradeDate;
            parameters[6].Value  = s.TotalPrice;
            parameters[7].Value  = s.AlreadyPay;
            parameters[8].Value  = s.Description;
            parameters[9].Value  = s.State;
            parameters[10].Value = s.CreateDate;
            SQLHelper.RunProcedure("p_AppendStock_insertNewEntity", parameters, out rowsAffected);
            return(1 == rowsAffected);
        }
Example #2
0
    protected void init()
    {
        string action = Request.QueryString["action"].ToString();

        if (action.Equals("add"))
        {
            string str0 = Request.QueryString["AppendID"].ToString();
            string str1 = Request.QueryString["CreateDate"].ToString();
            string str2 = Request.QueryString["StoreHouseID"].ToString();
            string str3 = Request.QueryString["HouseDetailID"].ToString();
            string str4 = Request.QueryString["AppendType"].ToString();
            string str5 = Request.QueryString["AlreadyPay"].ToString();
            string str6 = Request.QueryString["TradeDate"].ToString();
            string str7 = Request.QueryString["Description"].ToString();

            AppendStock a = new AppendStock();
            a.AlreadyPay    = float.Parse(str5);
            a.AppendID      = str0;
            a.AppendType    = int.Parse(str4);
            a.CreateDate    = str1;
            a.Description   = str7;
            a.HouseDetailID = int.Parse(str3);
            a.StoreHouseID  = int.Parse(str2);
            a.TradeDate     = str6;
            a.UserName      = getUserName();

            Leyp.SQLServerDAL.Stock.Factory.getAppendStockDAL().insertNewEntity(a);
            Response.Write("0");
            Response.End();
        }
        else if (action.Equals("delete"))
        {
            string str0 = Request.QueryString["AppendID"].ToString();
            Leyp.SQLServerDAL.Stock.Factory.getAppendStockDAL().deleteEitity(str0);
            Response.Write("成功删除单据" + str0);
            Response.End();
        }
    }